Converts XML values to JSON values.
Attributes are translated with prefix @, processing instructions with ? prefix to their name as a key in a JSON object.
When there are multiple texts surrounding inner elements, those are translated as JSON array elements instead of an object with the specified key.
Example:<a b="2"><v>some text</v></a> gets translated to:{"a": {"@b": "2", "v": {"#text": "some text"} } }
Options
Popular Predecessors
- XML Reader15 %
- GET Request10 %
- Webpage Retriever10 %
- XPath6 %
- String to XML3 %
- HTML Parser2 %
- Column Filter2 %
Loop End2 %- PMML to Cell2 %
- Loop End1 %
Recursive Loop End1 %- XML to JSON1 %
- Try (Data Ports)1 %
List Files1 %- JSON to Table1 %
- JSON to XML1 %
- XML Column Combiner1 %
- Column to XML1 %
XML Reader1 %- Generic Web Service Client1 %
- JSON Transformer1 %
- Generic XML Reader< 1 %
Row Filter (deprecated)< 1 %- XML Row Combiner< 1 %
- Table Row to Variable< 1 %
- Excel Reader< 1 %
- Web Page Content Extractor< 1 %
- File Reader (Complex Format)< 1 %
File Reader< 1 %- Table Creator< 1 %
- Missing Value< 1 %
- String Manipulation< 1 %
- Container Input (JSON)< 1 %
- POST Request< 1 %
- URL to File Path< 1 %
- Row Sampling< 1 %
- Sorter< 1 %
- Variable to Table Column< 1 %
- File Reader< 1 %
- String to JSON< 1 %
- 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 (legacy)< 1 %
- Unzip Files (legacy)< 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 48 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.