Home

How to Get & Transform from Json web API

%3CLINGO-SUB%20id%3D%22lingo-sub-768585%22%20slang%3D%22en-US%22%3EHow%20to%20Get%20%26amp%3B%20Transform%20from%20Json%20web%20API%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-768585%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20Get%20%26amp%3B%20Transform%20data%20from%20a%20web%20API.%3C%2FP%3E%3CP%3EWhen%20I%20go%20to%20the%20URL%20through%20a%20browser%20I%20can%20view%20the%20data.%3C%2FP%3E%3CP%3EI%20copy%20the%20URL.%20Open%20Excel%20365%2C%20click%20get%20data%20...from%20web%20and%20paste%20the%20URL.%3C%2FP%3E%3CP%3EIt%20looks%20like%20Excel%20is%20recognizing%20that%20it%20is%20a%20Json%2C%20because%20power%20query%20has%20Json.Document.....%3C%2FP%3E%3CP%3EHowever%2C%20it%20is%20not%20letting%20me%20view%20the%20actual%20data%2C%20each%20line%20only%20has%20%22Record%22%3C%2FP%3E%3CP%3EWhen%20I%20try%20Close%20%26amp%3B%20Load%20it%20loads%20%5BRecord%5D%20into%20the%20rows%20in%20column%20A.%3C%2FP%3E%3CP%3EAny%20ideas%20on%20what%20is%20going%20on%3F%3C%2FP%3E%3CP%3EKind%20Regards%2C%3C%2FP%3E%3CP%3EDom%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-768585%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-769088%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Get%20%26amp%3B%20Transform%20from%20Json%20web%20API%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-769088%22%20slang%3D%22en-US%22%3ECan%20you%20right-click%20on%20the%20column%20with%20the%20Records%20and%20choose%20drill-down%3F%3C%2FLINGO-BODY%3E
DomMcCabe
Occasional Visitor

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?