JSON to XML

Converts JSON values to XML documents.

The json values might contain multiple objects/values in which case these cannot be represented using XML without an artificial root node. For this reason we always create a root node. You can use the XPath node to remove it when possible (or to create a collection of XML values).

In general object keys starting with @ and having simple values get translated to xml attributes, the only exception could be for the key of the text if specified (which case it will be XML text). Every non-letter or number or _ character will be removed from the keys, which might cause ambiguity or create empty names, but will be kept as an attribute with key: ns:originalKey , so it is recommended to stick to English letters in JSON object keys.

Options

Input column
Column containing JSON values
Output column
New column name
Name of the new (XML) column
Specify namespace
If unchecked, no base namespace will be set.
Namespace
The base namespace
Keep type information by adding namespace
When checked, the JSON type information will be preserved, numbers, booleans, ... will be represented as text, but their node will have a prefix identifying its type. Otherwise all kind of values will be represented as text.
Empty list (https://www.w3.org/2001/XMLSchema/list)
Only used for the [] JSON array when the Omit type information is unchecked. Otherwise it is not possible to distinguish between [] and {}.
Boolean (https://www.w3.org/2001/XMLSchema/boolean)
Prefix for the boolean values.
Decimal (https://www.w3.org/2001/XMLSchema/decimal)
Prefix for the floating point/decimal values.
Integer (https://www.w3.org/2001/XMLSchema/integer)
Prefix for the integer values.
Null (https://www.w3.org/2001/XMLSchema)
Prefix for the null values.
String (https://www.w3.org/2001/XMLSchema/string)
Prefix for the String/text values.
Root element name
There is always a root element, you can specify its name.
Array item name
Array items not always can be represented as trees (for example arrays within arrays, or primitive types within arrays). In this case an XML element with the specified name will be created for each array entry.
Use parent keys as element name for arrays
When checked, JSON such as 
{
    "a" : [
        {"b" : 2},
        {"c" : 3}
    ]
}
gets translated to 
<a>
 <b>2</b>
</a>
<a>
 <c>3</c>
</a>
otherwise, it is translated to: 
<a>
 <item>
  <b>2</b>
 </item>
 <item>
  <c>3</c>
 </item>
</a>
Use a key to represent values as XML text
When checked, simple values with the specified key will not create attributes, but provide the single text of the surrounding element.
Key for text
The key name to represent as XML text
Translate JSON keys starting with # to
JSON objects with keys starting with a hash sign such as 
{"#comment": "content"}
can either be translated to XML elements 
<comment
 ns:originalKey="#comment">
  content
</comment>
or to XML comments 
<!--content-->
Translate JSON keys starting with ? to
JSON objects with keys starting with a question mark such as 
{"?pi": "content"}
can either be translated to XML elements 
<pi ns:originalKey="?pi">
 content
</pi>
or to XML processing instructions 
<?pi content?>
Remove invalid XML characters from values
XML 1.0 supports only a limited set of characters (see RFC ). When checked, invalid characters will be removed from values.

Input Ports

Icon
A table with JSON column

Output Ports

Icon
Table with the converted XML column

Popular Predecessors

Popular Successors

Views

This node has no views

Workflows

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.

Installation

To use this node in KNIME, install the extension KNIME JSON-Processing from the below update site following our NodePit Product and Node Installation Guide:

v5.9

A zipped version of the software site can be downloaded here.

Plugin provider: KNIME AG, Zurich, Switzerland
Plugin version: 5.9.0.v202511130855
On NodePit since: 2025-12-11
Last update: 2026-01-06
Tags: StreamableModern UI
KNIME versions: Since v3.6

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!