powerquery - NASA API into table in excel

Question

I'm trying to download weather related data using the Nasa API into excel using powerquery. I'm trying to query wind speed at 50 metres, the string for which is

https://power.larc.nasa.gov/cgi-bin/v1/DataAccess.py?&request=execute&tempAverage=DAILY&identifier=SinglePoint&parameters=WS50M&userCommunity=SB&lon=142&lat=-38&startDate=20170101&endDate=20201231&outputList=JSON&user=DOCUMENTATION

I know this is the correct string because when I paste this as a url into my chrome browser, I get the desired output in JSON. However, when I try to get the output into a table in excel, I get a mere 2 records. Something is clearly amiss. Any help on this will be appreciated.

question from:https://stackoverflow.com/questions/65913144/nasa-api-into-table-in-excel

Answer 1

Waitting for answers