Importing data from a JSON Weather API into Microsoft Excel using Power Query
This article shows how to import data into Microsoft Excel using Power Query from a RESTful Weather API. This API returns JSON-based data. 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 result table …
Continue reading “Importing data from a JSON Weather API into Microsoft Excel using Power Query”