XML to JSON

Reads values from an XML column and converts them into JSON format.

• If there are multiple pieces of text around inner elements, they are translated into elements of a JSON array.
• Text content inside XML elements is stored under a specified key (default key is text).
• If enabled, XML attributes are converted to JSON keys with an @ prefix.
• If enabled, XML processing instructions are converted to JSON keys with a ? prefix.

<a>Hello <b>world</b>!</a>

{
   "a": [
     "Hello ",
     {
       "b": {
         "text": "world"
       }
     },
     "!"
   ]
}

Options

Input column

Column containing XML values

Output handling

Select how the output JSON column should be handled.

• Append: Adds a new JSON column.
• Replace: Replaces the original column with the JSON column.

New column name

Name of the new (JSON) column

Text body translated to JSON with key

This key will be used for XML text content to be represented in JSON

Translate comments

When checked, comments (such as <!-- comment -->) will be translated with key: #comment, otherwise they are omitted in the JSON output

Translate processing instructions

When checked, processing instructions (such as <?do?>) will be translated with prefix ?, otherwise they are omitted in the JSON output

Views

This node has no views

Workflows

• 1.ReadData - solutionKNIME Hub
• 20210826 Pikairos Execute Failed Java Heap Space IIKNIME Forum
• 20220105 Pikairos How to convert the Polynomial Regression Learner curves to math formulaKNIME Forum
• 20220810 Pikairos Read Excel 97-2003 XML Spreadsheet 2003 filesKNIME Hub
• 20230215 Pikairos Extract XLSX Sheet NamesKNIME Hub
• Show all 61 workflows

Links

• XML to CSV / Table conversion without using XPathby qqilihq on 2021-05-28

  forum.knime.com/p/124933

Developers