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 values and just keep the column with the values. The name of the column the node selects is “texts” but you could change that.

[Edit: I just see the values I extracted might not match your exact values, you might have to try again to find a path or check the results]

kn_example_xml_like_file.knwf (1.3 MB)

3 Likes