help me please to convert json to csv

[mlauber71]

@mehman521 due to the nature of the data in the file I asked KNIME to remove it from the forum.

Concerning JSON you will have to do some manipulations, especially define a ‘path’ that would define how to extract the data

Json Path Understanding

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

Here is an example how such an extraction might look like (the same might be true for XML files):

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…

Then there is a JSON to Table node that might try to automate some of that. But due to the very flexible nature of JSON files you might have to try some back and forth:

JSON to Table

You can read more about JSON and XML in this article:

XML meets JSON: Will They Blend? | KNIME