Forum Discussion
Morten Ross
Dec 01, 2017Copper Contributor
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"
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"
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