Using API Keys in Excel
How to query an API in Excel using an API Key from the OpenWeather channel
Video Content:
00:06 - Introduction to API keys + Github API catalogue
01:40 - OpenWeatherMap API
03:40 - OpenWeatherMap API Documentation
05:25 - Excel Power Query, building our parameters for the API call + using the API key
08:12 - Generating results from our API call
10:37 - Transforming the results of the API returned data
17:55 - Loading our data into a table in Excel
19:54 - Closing remarks and Conclusion
22:15 - Outro
#api #apidevelopment #powerquery #apimanagement #excel #exceltutorial #exceltutorialforbeginners #exceltips
On this page of the site you can watch the video online Using API Keys in Excel with a duration of hours minute second in good quality, which was uploaded by the user Skills With Sid 22 December 2022, share the link with friends and acquaintances, this video has already been watched 13,573 times on youtube and it was liked by 86 viewers. Enjoy your viewing!
