Forum Discussion
Solved
parse two-level JSON data
I need to import some weather data (https://mesonet.agron.iastate.edu/json/obhistory.py?station=TVK&network=AWOS&date=2018-04-22), which has a two-level JSON structure - i.e. { name1: [ {n1}, {n2...
Hi Gregory,
If you check the file I sent second time the date is in cell A1 and named as ObservationDate
Power Query picks it up and embeds into the URL
You may change the date in this cell and after that Data->Refresh All
Very nice - thanks. I now see where this code goes - "Advanced Query Editor".
The URL of the data source specifies the data site, and embedded in it is a field which says which day of data to access. I would like to have a cell in the spreadsheet, which defines the date of interest, and have the query URL link to that. Or perhaps, form the new URL in a cell, and just have the URL link to that cell?
Or, some VBA which wold change the URL of the data source?
The basic idea is - change the date cell, and automatically by some refresh button, the data and graph changes.
Many thanks.
Hi Gregory,
If you check the file I sent second time the date is in cell A1 and named as ObservationDate
Power Query picks it up and embeds into the URL
You may change the date in this cell and after that Data->Refresh All
Ah, very nice - thank you, I had missed that!!