Forum Discussion
How to decode JSON data that I retrieved via API
- 1 year ago
Have a look at how the powerquery JSON connector decodes JSON files. It should allow you to easily generate a tabular format
Would avoid extract table from example
Hi Deku,
Thanks for the reply...... I may have figured it out......
In Web link, I added application application/json like below
Then, when the data is returned, I got the data without them being in a table.
Then, I convert the data into Table.
Then, all the data are in Column 1, row 1.
Then, I right click on column1, then, select Transform, and then JSON.
I got a List.
Then, I right click on "Expand" icon and select "Expand to New Rows". I got this:
Then, I right click on the "Expand" icon to show all columns in a table!
This is the Advanced Editor screen for me for the above steps.
When I go back to the "Recent Resources", I got this:
The "Open File As" option was NOT available before.
So, I guess I got it. But, I wonder if this is the best way as it did involve a few steps.
Thanks.
Dc7669
LGTM