Data from API into Excel sheet shows "[List]" How to view the values?

[Chartist]

Imported data from API.
Data > From Web.
Convert > Into Table
'Close & Load'.
The result is supposed to be data, instead I get the word " [ List ] "in cell B1. How to view the actual list of data?

Thanks.

 

[Norie]

You'll probably need to do a bit more work in Power Query, for example expand the list to rows.

 

[Chartist]

You'll probably need to do a bit more work in Power Query, for example expand the list to rows.

Yes, looks like something basic, but I'm not able to figure it out. Can you point me where to start in Excel to extract the values in the list into the excel sheet?

 

[Norie]

It's Power Query you need to work in to expand the list and then return the data to Excel.

Since I don't know anything about the API you are accessing or what it returns I can't give specific instructions but you could try right clicking the List in Power Query and selecting Into Table.

 

[Chartist]

I clicked Into Table it shows another table. Then the value.

https://www.binance.com/api/v3/depth?symbol=BTCUSDT

How to get this list in the Excel spreadsheet?

 

[Bo_Ry]

Please try

let
    Source = Json.Document(Web.Contents("https://www.binance.com/api/v3/depth?symbol=BTCUSDT")),
    Expand = Table.FromRecords(List.Transform(List.Zip({Source[bids],Source[asks]}),each [bids1 = _{0}{0},bids2=_{0}{1},asks1= _{1}{0},asks2= _{1}{1}]))
in
    Expand

 

[Chartist]

Where do I paste this code? Thanks! (sorry, am a beginner with this feature)

 

[Bo_Ry]

Data > From Web
Power Query, Ribbon Home > advanced editor