How to Get & Transform from Json web API

Copper Contributor

Hi,

I am trying to Get & Transform data from a web API.

When I go to the URL through a browser I can view the data.

I copy the URL. Open Excel 365, click get data ...from web and paste the URL.

It looks like Excel is recognizing that it is a Json, because power query has Json.Document.....

However, it is not letting me view the actual data, each line only has "Record"

When I try Close & Load it loads [Record] into the rows in column A.

Any ideas on what is going on?

Kind Regards,

Dom

1 Reply
Can you right-click on the column with the Records and choose drill-down?