Forum Discussion

Morten Ross's avatar
Morten Ross
Copper Contributor
Dec 01, 2017

API source not displaying data, only structure/field names

I have successfully collected data from many API sources through PowerQuery, Excel 2016, but one returns no data only data structure:

 

 

This one is successful:

let
    Source = Json.Document(Web.Contents("http://www.coincap.io/page/BTC")),
    #"Converted to Table" = Record.ToTable(Source)
in
    #"Converted to Table"

 Coincap - data successfully displayed

 

This one only returns structure:

let
    Source = Json.Document(Web.Contents("https://data.norges-bank.no/api/data/EXR/B..NOK.SP?lastNObservations=1&format=sdmx-json")),
    #"Converted to Table" = Record.ToTable(Source)
in
    #"Converted to Table"

 Norges Bank - fails to display data

 How can I get the data displayed?

 

Is the problem the API provider, and can only be corrected by them? If yes, what is the problem?

No RepliesBe the first to reply

Resources