I can get an API to load a JSON file and save it from the web. Is there a video or part of the course on how to load a saved JSON file into Power Query?
I see how to directly go to the web, but I can't seem to get all the data I need that way (seem to only get the 1st record when I do it that way).
Hi Rick,
There isn't a specific section of the course dealing with JSON.
I'm a little unclear as to what you are dealing with. You mention a JSON 'file' but I'd expect an API to return raw JSON which is then
1. Converted to a Table
2. Lists and Records in that Table are then expanded to get the data you want.
In this blog post Getting Started With API's in Power Query I use an example API that returns JSON from the Queensland Wildlife Service, and in the sample file I transform that JSON into the data I want.
I'd expect you to have to perform the same steps.
Can you please provide a sample file showing what you are doing.
regards
Phil
Hi Rick,
There's no specific tutorial on loading JSON files, but there is a JSON connector in the Get Data > From File > From JSON in the Power Query get data menu.
Mynda
