Importing data from a JSON Weather API into Microsoft Excel using Power Query
In this article we are going to demonstrate how to import data from a RESTful Weather API. This API returns JSON-based data into Microsoft Excel. We are also going to explain how to create a loop within our script so that we can call the API multiple times for multiple locations and create a combined …
Continue reading “Importing data from a JSON Weather API into Microsoft Excel using Power Query”