Json Path Understanding

[juanpa]

Hi all,

I´m just new with Knime and looking to create my first Workflow

JSON GET REQUEST and JSON PATH.

I can´t figure out how to split the Json into a Table data. I just tried Json path and i can´t figure how it works the selection. ( I try to select part of the data in the cell preview and it goes yellow and grey so i´m a bit stopped )

Any help will be apppreciate it!
thanks in advance

[mlauber71]

Here is an example how JSON path could work. It could be confusing some times.

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

[armingrudd]

Hi,

In addition to @mlauber71’s great example, I suggest using JSON To XML node if there are items that you want them in multiple rows or columns. I think it’s easier to deal with such cases using XPath node.

P.S.
JSON Path tutorial:
https://support.smartbear.com/alertsite/docs/monitors/api/endpoint/jsonpath.html

XPath tutorial:
https://www.w3schools.com/xml/xml_xpath.asp