Collects the parts specified by JSONPaths from a JSON column. For those parts that cannot be found or have incompatible types, missing values will be returned.
Example input table:| column name | path | type |
|---|---|---|
| bookyear | $.book[*].year | List(Double) |
| invalidyear | $.book[2].year | Double |
| timeline | $.book[?(@.year==1999)].title | String |
| paths | $..* | List(Path) |
{"book": [
{"year": 1999,
"title": "Timeline",
"author": "Michael Crichton"},
{"year": 2000,
"title": "Plain Truth",
"author": "Jodi Picoult"}
]}
The results look like this:
| bookyear | invalidyear | timeline |
|---|---|---|
| {1999, 2000} | ? | Timeline |
$['book'], $['book'][0], $['book'][1],
$['book'][0]['year'], $['book'][0]['title'], $['book'][0]['author'],
$['book'][1]['year'], $['book'][1]['title'], $['book'][1]['author']Options
Popular Successors
Loop End7 %- JSON Transformer7 %
- Unpivot5 %
- JSON Path (Dictionary)5 %
- Loop End4 %
- Column Filter4 %
- Ungroup4 %
- Rule Engine4 %
- JSON Path4 %
- JSON to Table4 %
- Java Snippet3 %
- GroupBy3 %
- JSON Row Combiner3 %
- JSON Schema Validator3 %
CSV Writer3 %Column Appender3 %- Column Resorter3 %
- Catch Errors (Data Ports)2 %
Table Writer2 %Variable Condition Loop End2 %- Column Combiner2 %
Row Filter (deprecated)2 %- Pivot2 %
- JSON Column Combiner2 %
- Split Collection Column< 1 %
Database Writer< 1 %- Recursive Loop Start< 1 %
Cell Replacer< 1 %- Column Name Extractor< 1 %
- Table Validator< 1 %
- Missing Value Column Filter< 1 %
Row Splitter (deprecated)< 1 %- Table Transposer< 1 %
- Interactive Table (legacy)< 1 %
- One Row to Many< 1 %
Excel Writer (XLS)< 1 %Excel Writer (XLS)< 1 %- Dictionary Filter< 1 %
- Table View (JavaScript) (legacy)< 1 %
- JSON Row Combiner and Writer< 1 %
- String to JSON< 1 %
- JSON Diff< 1 %
- JSON to XML< 1 %
MongoDB Writer< 1 %Python Script (1⇒1)< 1 %- GET Request< 1 %
- XPath< 1 %
Views
- This node has no views
Workflows
2020_03_16_Playing_With_JSONKNIME Forum
Glysade Variable InputKNIME Hub- JSON To Table PivotingKNIME Forum
Links
- No links available
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.