String to JSON

Converts the String values to JSON values.

Options

Input column

Select the String column containing JSON content.

Output column

Choose whether to replace the input column or append a new column.

• Replace input column: Replace the input column with the JSON column, keeping its name.
• Append new column: Add a new column with the JSON values.

New column name

Name of the new JSON column.

Allow comments

Allow comments (/* */, // and #) within JSON strings. Note: Comments are not part of the JSON specification but are sometimes used.

Fail on error

If checked, the node fails when encountering invalid JSON. Otherwise, missing values are generated for invalid JSON strings.

Views

This node has no views

Workflows

• 00_bindingsiteexplorationKNIME Hub
• 01 Integrate Databricks AIKNIME Hub
• 01_2010urban_InequalityKNIME Hub
• 01_xplan sf dbconv-insert via csv-AddressKNIME Hub
• 01. Agent - AMA (simple)KNIME Hub
• Show all 376 workflows

Links

• GET fails if the response does not have Content-Type setby armingrudd on 2019-07-31

  forum.knime.com/p/66923
• Import JSON data, that is non-standard-compliantby qqilihq on 2020-04-08

  forum.knime.com/p/86862
• JSON data into Knime and exported as SD file….by s.roughley on 2019-03-11

  forum.knime.com/p/55995

Developers