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
Settings
Type information
Popular Predecessors
- GET Request13 %
- String to JSON10 %
- JSON Reader9 %
- Table to JSON7 %
JSON Reader3 %- XML to JSON3 %
- JSON to Table2 %
- Columns to JSON2 %
- XPath2 %
Column Rename2 %- JSON Path2 %
- Tika Parser URL Input2 %
- String Manipulation2 %
- Column Filter1 %
- Container Input (JSON)1 %
- JSON to XML1 %
Loop End1 %Row Splitter (deprecated)1 %- POST Request1 %
- JSON Row Combiner1 %
- Excel Reader1 %
- HTTP Result Data Extractor1 %
- Load Text Files1 %
- Recursive Loop End1 %
- Chunk Loop Start< 1 %
Row Filter (deprecated)< 1 %- Partitioning< 1 %
- Column Splitter< 1 %
- Ungroup< 1 %
- JSON Transformer< 1 %
- String to XML< 1 %
CSV Reader< 1 %- Table Creator< 1 %
- JSON Diff< 1 %
- JSON Writer< 1 %
- MongoDB Reader< 1 %
- XML Reader< 1 %
- Loop End< 1 %
- Table Manipulator< 1 %
- JSON Column Combiner< 1 %
- Benchmark End< 1 %
- CASE Switch Start< 1 %
- Java Snippet< 1 %
File Reader< 1 %MongoDB Reader< 1 %XML Reader< 1 %Line Reader< 1 %- File Reader (Complex Format)< 1 %
Recursive Loop End< 1 %- Python Script (legacy)< 1 %
- Cross Joiner< 1 %
- GroupBy< 1 %
- Parallel Chunk End< 1 %
- JSON Path (Dictionary)< 1 %
- Wait< 1 %
- Elasticsearch Console (ES 6)< 1 %
- Split Collection Column< 1 %
- Binary Objects to Strings< 1 %
- Unzip Files (legacy)< 1 %
Variable to Table Column< 1 %Table Row To Variable Loop Start< 1 %- Cluster Assigner< 1 %
- Column Auto Type Cast< 1 %
- Duplicate Row Filter< 1 %
- Row Sampling< 1 %
- Table Transposer< 1 %
- Rule-based Row Filter< 1 %
- End IF< 1 %
- DB Query Reader< 1 %
- Java Snippet Row Filter< 1 %
- Flat File Document Parser< 1 %
- Container Input (Table)< 1 %
- JSON Schema Validator< 1 %
- Preset Date/Time (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- Column to XML< 1 %
- HTTP Retriever< 1 %
- HTML Parser< 1 %
- Number Formatter< 1 %
- Table Column to Variable< 1 %
- CSV Reader< 1 %
- Group Loop Start< 1 %
Recursive Loop End (2 ports)< 1 %- Concatenate< 1 %
- Row Splitter (Labs)< 1 %
- Rule Engine< 1 %
- Workflow Summary Extractor< 1 %
- Java Snippet (simple)< 1 %
Views
- This node has no views
Workflows
02_WebServices_DataRetrievalKNIME Hub- 02_WebServices_DataRetrievalKNIME Hub
- 78946 - Extract Date Information from Cyrillic DataKNIME Hub
- 79017 - Read JSON and extract DataKNIME Hub
- 79973 - Append Data to XMLKNIME Hub
- Show all 48 workflows
Links
- JSON to Tableby armingrudd on 2019-04-24forum.knime.com/p/59303
- Json Path Understandingby armingrudd on 2019-06-18forum.knime.com/p/62465
- Looping over JSON Response Databy armingrudd on 2019-02-07forum.knime.com/p/54265
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.