Blue1971
New Member
- Joined
- May 19, 2020
- Messages
- 15
- Office Version
- 2016
- Platform
- Windows
I have a URL that points to a sample server that returns JSON records:
https://sampleserver6.arcgisonline....pServer/0/query?where=1=1&outFields=*&f=pjson
I want to use the JSON records in Excel 2016 as a table.
I've attempted to do this by connecting to the URL via Excel Power Query:

However, it seems like Power Query is treating the data as CSV records, not as JSON records.

So the data is not coming into Power Query as a proper table.

How can I get Power Query to select the JSON records as a table in Excel?
Thank you.
https://sampleserver6.arcgisonline....pServer/0/query?where=1=1&outFields=*&f=pjson
I want to use the JSON records in Excel 2016 as a table.
I've attempted to do this by connecting to the URL via Excel Power Query:

However, it seems like Power Query is treating the data as CSV records, not as JSON records.

So the data is not coming into Power Query as a proper table.

How can I get Power Query to select the JSON records as a table in Excel?
Thank you.