Loading JSON Data from AWS URL

[Addy]

I have JSON data which is placed on aws url and I have to work this with other data. How to convert this json data to csv format.

Regards
Addy

[mlauber71]

We had a discussion about JSON and I provided an example workflow:

Json to Table

I just stumbled across this entry and maybe I can help since I had a similar problem recently. The point is that in order to import a JSON file you have to Import it with the JSON reader define a JSON path to the variables ungroup the variables Then you have a normal table with columns. json.knar

Also this thread might give you some insight:

Problems with parsing a XML-like file

I attach a workflow that extracts your values. I converted the XML file to JSON and then used the JSON path editor to define a path. The tricky thing is to find the path. That took some time. I exported the JSON file and used an editor (Atom on MacOS) to find the right row. Then you would have to click on an item you want and hopefully it would select and mark blue the values you want. I am not a JSON expert so I would have to click around until it fits. Then the workflow would ungroup the valu…

Basically you have to define an XPath that matches the data you want to extract, and sometimes you then have to do further manipulations like Ungroup.

If you could upload and example we might have a look.