String to Json Workflow error

Hello everyone;
How can I fix the error that appears in the picture. ? There is a workflow attached.KNIME_Botswana_project.knwf (271.2 KB)

Hi,

the json-string you are trying to parse and convert into a json-cell seems to be corrupted for some reason. Instead of trying to find out why, however, I recommend you to take another route: since you are accessing a web service that already returns json-objects you can simply use the GET Request node and replace the HTML Parser, XPath, Column Splitter and String to JSON with it. The GET Request node outputs json-cells already that can directly be fed into the JSON Path node (make sure to select the ‘URL column’ instead of one static URL in the configuration of the GET Request node).

Best,
Martin

4 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.