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 Successors
- XPath33 %
CSV Writer5 %- JSON to Table3 %
- XML Writer3 %
- Concatenate2 %
Row Filter (deprecated)2 %- String Manipulation1 %
- Ungroup1 %
- XML to JSON1 %
- Column to XML1 %
- XML Row Combiner1 %
- XML to PMML1 %
- Excel Writer1 %
- JSON to XML1 %
- Table Writer1 %
- Column Filter1 %
- XML Column Combiner1 %
XML Writer1 %- XSLT1 %
- Table to HTML String1 %
- CSV Writer< 1 %
- Java Snippet< 1 %
- Loop End< 1 %
Loop End< 1 %- RowID< 1 %
- DB Writer< 1 %
- Column Expressions< 1 %
Excel Writer (XLS)< 1 %- JSON Path< 1 %
- Container Output (JSON)< 1 %
Python Script (1⇒1)< 1 %- POST Request< 1 %
- String to XML< 1 %
- HTML Node to Text< 1 %
Column Rename< 1 %- Shuffle< 1 %
- End IF< 1 %
- Interactive Pie chart (legacy)< 1 %
- Send to Power BI< 1 %
- Table View (JavaScript)< 1 %
- JSON Diff< 1 %
- Python Script (legacy)< 1 %
- XML Row Combine and Write< 1 %
Column Appender< 1 %- Cross Joiner< 1 %
- Excel Cell Updater< 1 %
- JSON Row Combiner< 1 %
- JSON Schema Validator< 1 %
- PUT Request< 1 %
- URL Extractor< 1 %
PDB Connector Query Only< 1 %- Strings to Binary Objects< 1 %
Table Column to Variable< 1 %Database Writer< 1 %- Chunk Loop Start< 1 %
Concatenate (Optional in)< 1 %- Column Appender< 1 %
- Missing Value< 1 %
- Cell to PMML< 1 %
- Generic Web Service Client< 1 %
- Dictionary Tagger< 1 %
- String to JSON< 1 %
XML Reader< 1 %- Web Page Content Extractor< 1 %
- Chunk Loop Run-for-time Loop Start< 1 %
- Table to String< 1 %
- Variable to Table Column< 1 %
Table Row to Variable< 1 %- Table Row to Variable< 1 %
Table Writer< 1 %Counting Loop Start< 1 %Recursive Loop Start< 1 %Scorer< 1 %- Random Forest Learner< 1 %
- Cell Splitter< 1 %
- Number to String< 1 %
- String to SVG< 1 %
- Column Renamer (Dictionary)< 1 %
- One to Many< 1 %
- Double to Integer< 1 %
- Reference Column Filter< 1 %
- GroupBy< 1 %
Joiner< 1 %- Column Splitter< 1 %
- String Replacer< 1 %
- Table Difference Finder< 1 %
- Rule Engine< 1 %
- Data Explorer< 1 %
- Empty Table Switch< 1 %
CASE Switch Data (Start)< 1 %- Cache< 1 %
- Interactive Histogram (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Interactive Table (legacy)< 1 %
- DB Insert< 1 %
Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %- External SSH Tool< 1 %
- Java Snippet (simple)< 1 %
- TF< 1 %
- Bag Of Words Creator< 1 %
- Document Data Extractor< 1 %
- Document Vector< 1 %
- Strings to Document< 1 %
- Tile View (JavaScript)< 1 %
- JSON Column Combiner< 1 %
- JSON Transformer< 1 %
- Columns to JSON< 1 %
JSON Writer< 1 %- GET Request< 1 %
- Table Difference Checker< 1 %
- Text Classifier Learner< 1 %
- MapQuest Geocoder< 1 %
- Base64 Encoder< 1 %
- Feed Discovery< 1 %
- Feed Parser< 1 %
- HTML Parser< 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.