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}, {n3} ], name2: [ [v1,v2,v3], [v1,v2,v3], ... ] ] } The Excel data import seems to just get the two top level names ("name1", "name2"), and none of the data. Sample data: { "fields": [ { "type": "datetime", "name": "Observation Valid", "description": "Observation Valid Time" }, { "type": "datetime", "name": "Observation Valid UTC", "description": "Observation Valid Time UTC" } ], "rows": [ [ "2018-04-22T00:10:00", "2018-04-22T05:10:00Z" ], [ "2018-04-22T00:15:00", "2018-04-22T05:15:00Z" ], [ "2018-04-22T00:20:00", "2018-04-22T05:20:00Z" ] ] }
Web Import: Change Website Level
Hi all, I'm trying to use Excel Web Queries to import data on books from ISBN numbers. Now, I'm completely new to Web Queries and have run into a bit of trouble. I found this website:https://isbnsearch.org/isbn/ in order to get the data I need, but when I first put it in the field, I was asked to choose a level (i.e.https://isbnsearch.org/ orhttps://isbnsearch.org/isbn/3596164532orhttps://isbnsearch.org/isbn/3596164532) At this point I wasn't quite clear on how I wanted to do this and chose the wrong level. And now I have absolutely now clue on how to get back to this point, evey time I enter this address, it simply assumed to know what I want. I may be going at this entirely wrong anyway, but if anyone would be so kindto help me I would be super grateful! And I'm very sorry if I'm posting in the wrong spot or if this has been answered before, I couldn't find an answer to this yet! Cheers sunfleur
