# Loading JSON Data from AWS URL **URL:** \ **Category:** KNIME Analytics Platform\ **Tags:** json\ **Created:** [January 30, 2019, 4:30pm UTC](https://forum.knime.com/t/loading-json-data-from-aws-url/13330 "2019-01-30T16:30:24Z")\ **Posts on this page:** 1\ **Showing post:** 2
**Author:** ![mlauber71](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mlauber71/32/73590_2.png) [@mlauber71](https://forum.knime.com/u/mlauber71)\ **Post date:** [January 30, 2019, 7:16pm UTC](https://forum.knime.com/t/loading-json-data-from-aws-url/13330/2 "2019-01-30T19:16:19Z")
We had a discussion about JSON and I provided an example workflow: > [@Json to Table](https://forum.knime.com/t/json-to-table/8731/4): > > 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](https://www.knime.com/sites/default/files/json.knar) Also this thread might give you some insight: > [@Problems with parsing a XML-like file](https://forum.knime.com/t/problems-with-parsing-a-xml-like-file/11463/4): > > 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](https://nodepit.com/node/org.knime.xml.node.xpath2.XPathNodeFactory) that matches the data you want to extract, and sometimes you then have to do further manipulations like [Ungroup](https://nodepit.com/node/org.knime.base.node.preproc.ungroup.UngroupNodeFactory). If you could upload and example we might have a look. --- _[View the full topic](https://forum.knime.com/t/loading-json-data-from-aws-url/13330)._