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 Predecessors
- Table Creator6 %
- String Manipulation5 %
CSV Reader4 %- JSON Column Combiner4 %
JSON Reader3 %File Reader3 %- Container Input (JSON)3 %
- JSON Path3 %
- Excel Reader3 %
- GroupBy3 %
- JSON Schema Validator3 %
- JSON Reader3 %
- Ungroup2 %
- XML to JSON2 %
- JSON Path (Dictionary)2 %
Variable to Table Row2 %Table Reader2 %- Constant Value Column2 %
Row Filter (deprecated)2 %- Empty Table Creator2 %
- String to JSON2 %
- Table to JSON2 %
- JSON to Table2 %
- GET Request2 %
- POST Request2 %
- Columns to JSON2 %
- CSV Reader2 %
- Column Expressions2 %
- Chunk Loop Start1 %
MongoDB Reader1 %- String to Path1 %
- Column List Loop Start1 %
- Extract Variables (Data)1 %
Excel Reader (XLS)1 %XML Reader1 %- Nominal Value Row Filter1 %
- Try (Data Ports)< 1 %
Table Row To Variable Loop Start< 1 %- Concatenate< 1 %
- Rule-based Row Filter< 1 %
- Rule Engine< 1 %
- Extract Table Spec< 1 %
- Unzip Files (legacy)< 1 %
Recursive Loop Start< 1 %- Column Filter< 1 %
- Rule-based Row Splitter< 1 %
- XPath< 1 %
- Mass Calculator< 1 %
Line Reader< 1 %List Files< 1 %Loop End< 1 %Variable Condition Loop End< 1 %- Create Table Structure< 1 %
- Partitioning< 1 %
Column Rename< 1 %- Empty Table Switch< 1 %
- Sentence Extractor< 1 %
- String Input (legacy)< 1 %
- JSON Transformer< 1 %
- JSON Diff< 1 %
- Python Source (legacy)< 1 %
- HTTP Retriever< 1 %
- Elasticsearch Console (ES 6)< 1 %
- Binary Objects to Strings< 1 %
- Variable to Table Row< 1 %
- Line Reader< 1 %
- Cross Joiner< 1 %
- Column Splitter< 1 %
- Table Transposer< 1 %
- Unpivot< 1 %
- MongoDB Reader< 1 %
- HTML Parser< 1 %
Views
- This node has no views
Workflows
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.