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.
The XML
<a>Hello <b>world</b>!</a>{
"a": [
"Hello ",
{
"b": {
"text": "world"
}
},
"!"
]
}Options
Popular Predecessors
- XML Reader10 %
Loop End3 %- PMML to Cell3 %
- GET Request3 %
- Webpage Retriever3 %
- String to XML2 %
- XPath2 %
- Loop End2 %
Recursive Loop End2 %- Try (Data Ports)2 %
List Files2 %- JSON to Table2 %
- XML Column Combiner2 %
- Generic Web Service Client2 %
- JSON Transformer2 %
- Generic XML Reader1 %
Row Filter (deprecated)1 %- XML to JSON1 %
- Table Row to Variable1 %
- Excel Reader1 %
- Web Page Content Extractor1 %
- File Reader (Complex Format)1 %
File Reader1 %- Table Creator1 %
- Column Filter1 %
- Missing Value1 %
- String Manipulation1 %
- Container Input (JSON)1 %
- JSON to XML1 %
- POST Request1 %
- Column to XML1 %
- XML Row Combiner1 %
XML Reader1 %- HTML Parser1 %
- URL to File Path1 %
- Row Sampler1 %
- Sorter1 %
- Variable to Table Column1 %
- File Reader1 %
- String to JSON1 %
- JSON Path< 1 %
- Columns to JSON< 1 %
- MarvinSketch< 1 %
Variable to Table Column< 1 %- Java Snippet< 1 %
- XSLT< 1 %
- Page Source< 1 %
- European PubMed Central Advanced Search< 1 %
- Table Reader< 1 %
Variable Condition Loop End< 1 %- Parallel Chunk Start< 1 %
- Java Snippet (simple)< 1 %
- XML Writer< 1 %
Line Reader< 1 %- Chunk Loop Start< 1 %
- GroupBy< 1 %
- HTTP Result Data Extractor< 1 %
Database Reader< 1 %Row Splitter (deprecated)< 1 %Extract Attribute< 1 %- Variable to Table Row< 1 %
- Loop End (Column Append)< 1 %
- Concatenate< 1 %
- XML to PMML< 1 %
Column Rename< 1 %Column Splitter< 1 %- Ungroup< 1 %
- Rule-based Row Filter< 1 %
CASE Switch Data (End)< 1 %- Tika Parser< 1 %
- HTTP Retriever< 1 %
- Load Local XML Files< 1 %
- Split Collection Column< 1 %
- Binary Objects to Strings< 1 %
Download< 1 %Unzip Files< 1 %Recursive Loop Start< 1 %- Column Resorter< 1 %
- Top k Row Filter< 1 %
- Table Transposer< 1 %
- DB Reader< 1 %
- Tika Parser URL Input< 1 %
- RSS Feed Reader< 1 %
- Strings to Document< 1 %
- File Chooser (legacy)< 1 %
- PUT Request< 1 %
Date&Time Shift< 1 %- HTML Node to Text< 1 %
- Get WebElement Data< 1 %
- Variable Creator< 1 %
Counting Loop Start< 1 %- Group Loop Start< 1 %
- Joiner< 1 %
- Empty Table Switch< 1 %
- Workflow Summary Extractor< 1 %
- Parallel Chunk End< 1 %
- DB Query Reader< 1 %
- JSON Reader< 1 %
JSON Reader< 1 %
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
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.