Unable to Query Historical NOAA Weather Data from Weather Stations

Hello @pwares

The token must be provided in the request header. I tried this and it works, just enter your own token at the top. Sample PBIX file here.

let

api_url = "https://www.ncdc.noaa.gov/cdo-web/api/v2/datasets?stationid=GHCND:USW00014732&stationid=GHCND:USW00013739&stationid=GHCND:USW00014739&stationid=GHCND:USW00094823&stationid=GHCND:USW00014765",
    token = "XXXXXXXXX",

Source = Json.Document(Web.Contents(api_url,
   [ 
     Headers = [token = token ,#"Content-Type"="application/json"]
   ]
   )
   ),
    #"Converted to Table" = Record.ToTable(Source),
    Value = #"Converted to Table"{1}[Value],
    #"Converted to Table1" = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table1", "Column1", {"uid", "mindate", "maxdate", "name", "datacoverage", "id"}, {"uid", "mindate", "maxdate", "name", "datacoverage", "id"})
in
    #"Expanded Column1"

Best regards

Phil

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking Thumbs Up.