Columns to JSON Output Backslash Issue

KNIME Analytics Platform
1

Hi,

The Columns to JSON node is providing many "\" backward slashes after every word in its output. This makes it difficult to get output from JSON Path node. 

Can you please let me know how this can be avoided. Or an alternative solution will also be very helpful.

Regards,

Marvin

2

Hi,

Attached is the Workflow for your reference.

In Last Node (JSON Path) i am unable to retrieve data (e.g. id, tagged_places etc) due to the "\" in the JSON data available from Columns to JSON node.  

Hence no further processing can be done after Columns to JSON node  

However if you use JSON file (using JSON Reader node),  the data is retrieved in the desired format i.e. without "\"  in JSON output.

Alternatively, I also tried using String to JSON  and XML to JSON but the output continues to have "\".

Can you please provide me any workaround or alternative.

Thanks,

Marvin

3

The Column to JSON node is for creating a JSON document from one or mode non-JSON columns (see also the node's description). Since you already have JSON in a string column you need to use the String to JSON node. However, your JSON in invalid therefore the node cannot convert it. You can also check the validity at https://jsonformatter.curiousconcept.com/ (e.g.).

4

Hi,

Your reply was very helpful. I used the String to JSON node with Allow Comments checked which rendered JSON in desired format.

Thanks a lot !!

Regards,

Marvin.