JSONPath is a query language for JSON, similar to XPath for XML.
The result of a simple query (also called definite JSONPath) is a single value. The result of a collection query (also called indefinite JSONPath) is a list of multiple values. Results of JSONPath queries are converted to the selected KNIME type. If the result is a list and the selected KNIME type is not compatible, the execution will fail. If the result cannot be converted to the selected KNIME type, a missing value will be returned.
JSONPath queries can be automatically generated via the node configuration dialog. To create a simple query, select a single value from the JSON-Cell Preview window and click "Add single query". To create a collection query, select a value that is part of a list of values from the JSON-Cell Preview window and click "Add collection query". Alternatively, you can write your own JSONPath query by clicking the "Add JSONPath" button.
Example input:
{"book": [
{"year": 1999,
"title": "Timeline",
"author": "Michael Crichton"},
{"year": 2000,
"title": "Plain Truth",
"author": "Jodi Picoult"}
]}
Example JSONPath queries and evaluation results:
$.book[0]{"year": 1999,
"title": "Timeline",
"author": "Michael Crichton"} (JSON or String single value)
$.book[*].year[1999,2000] (JSON, Int or Real list)
$.book[2].year? (no such part)
$.book[?(@.year==1999)].titleTimeline (String) or "Timeline" (JSON)
The default path ($..*) will select all possible subparts (excluding the whole JSON value).
When you request the paths instead of values for the $.book[0].* JSONPath, you will get the paths -in bracket notation- as a list of Strings:
- $['book'][0]['year']
- $['book'][0]['title']
- $['book'][0]['author']
The filters ?(expr)can be used to select contents with specific properties, for example $..book[?(@.publisher)] selects the books that specify their publisher (@ refers to the actual element).
The JSON Path node uses the Jayway JSONPath implementation.
Options
Settings
Popular Predecessors
- GET Request13 %
- Ungroup9 %
- String to JSON7 %
- JSON Reader6 %
Row Filter (deprecated)5 %- XML to JSON4 %
- POST Request4 %
- Column Filter4 %
- JSON Path4 %
- Chunk Loop Start2 %
- JSON to Table2 %
- MongoDB Reader2 %
- Table to JSON1 %
Row Splitter (deprecated)1 %- Loop End1 %
- Concatenate< 1 %
- Salesforce SOQL< 1 %
- Rule-based Row Filter< 1 %
- Container Input (JSON)< 1 %
- Columns to JSON< 1 %
MongoDB Reader< 1 %- Table Creator< 1 %
- Table Row to Variable< 1 %
- Missing Value< 1 %
- String Manipulation< 1 %
- JSON Transformer< 1 %
Recursive Loop End< 1 %- Math Formula< 1 %
- JSON Row Combiner< 1 %
JSON Reader< 1 %- MongoDB Aggregation< 1 %
- Column Expressions< 1 %
Column Rename< 1 %Table Row to Variable< 1 %Column Appender< 1 %Recursive Loop Start< 1 %- CSV Reader< 1 %
Table Row to Variable< 1 %- Column Filter (legacy)< 1 %
- String Input (legacy)< 1 %
- Call Workflow (Row Based)< 1 %
List Files< 1 %- GroupBy< 1 %
CASE Switch Data (Start)< 1 %Python Script (1⇒1)< 1 %- DB Query Reader< 1 %
- RowID< 1 %
- Rule-based Row Splitter< 1 %
- Recursive Loop End< 1 %
- Row Filter (Labs)< 1 %
CSV Reader< 1 %File Reader< 1 %- Sorter< 1 %
- Column Splitter< 1 %
- IF Switch< 1 %
- Parallel Chunk End< 1 %
- String to Number< 1 %
- Joiner< 1 %
- CASE Switch Start< 1 %
- Group Loop Start< 1 %
Joiner< 1 %- PUT Request< 1 %
- Elasticsearch Console (ES 6)< 1 %
- Java Snippet Row Splitter< 1 %
- Date&Time-based Row Filter< 1 %
- Column to XML< 1 %
- Neo4j Writer< 1 %
- Excel Reader< 1 %
- Row Sampling< 1 %
- End IF< 1 %
- Java IF (Table)< 1 %
- JSON Schema Validator< 1 %
- Column Rename (Regex)< 1 %
- Date&Time Difference< 1 %
- Run Garbage Collector< 1 %
Variable to Table Row< 1 %- Java Snippet< 1 %
- Column List Loop Start< 1 %
- String Manipulation (Variable)< 1 %
- Unpivot< 1 %
- JSON Column Combiner< 1 %
- HTTP Result Data Extractor< 1 %
- Pivot< 1 %
Regex Extractor< 1 %- Variable to Table Column< 1 %
- Generic Loop Start< 1 %
- Table Row to Variable Loop Start< 1 %
- Workflow Summary Extractor< 1 %
- DB Writer< 1 %
Counting Loop Start< 1 %Variable Condition Loop End< 1 %- Nominal Value Row Filter< 1 %
- Shuffle< 1 %
- JSON Diff< 1 %
- XPath< 1 %
- HTTP Retriever< 1 %
- HTML Parser< 1 %
Table Column to Variable< 1 %Interval Loop Start< 1 %- Parallel Chunk Start< 1 %
- JSON Path (Dictionary)< 1 %
- Elasticsearch Console (ES 7)< 1 %
- Table Reader< 1 %
- Recursive Loop Start< 1 %
- Table Manipulator< 1 %
- DB Reader< 1 %
- List Files/Folders< 1 %
- Python Script (legacy)< 1 %
- PATCH Request< 1 %
- Workflow Service Input< 1 %
- XML Reader< 1 %
- Create Completion< 1 %
Python Snippet< 1 %- Split Collection Column< 1 %
- Breakpoint< 1 %
- Wait...< 1 %
- Catch Errors (Data Ports)< 1 %
Loop End (2 ports)< 1 %Loop End< 1 %- Column Auto Type Cast< 1 %
- Column Resorter< 1 %
- Constant Value Column< 1 %
- Reference Row Filter< 1 %
- Partitioning< 1 %
- String Replacer< 1 %
- Table Transposer< 1 %
- Rule Engine< 1 %
- Cache< 1 %
Merge Variables< 1 %Python Script (1⇒1)< 1 %- String to Date&Time< 1 %
- Binary Objects to Strings< 1 %
- Try (Data Ports)< 1 %
Line Reader< 1 %Variable Loop End< 1 %- Cell Splitter< 1 %
- Cross Joiner< 1 %
- Duplicate Row Filter< 1 %
- Empty Table Switch< 1 %
- Table View (JavaScript)< 1 %
- JSON to XML< 1 %
- Webpage Retriever< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Neo4j Reader< 1 %
- Slack API Metrics< 1 %
- Table Column to Variable< 1 %
- Variable to Table Row< 1 %
- File Reader< 1 %
- Line Reader< 1 %
- Variable Creator< 1 %
- Counting Loop Start< 1 %
- Variable Condition Loop End< 1 %
- Number to String< 1 %
- Column Appender< 1 %
- Reference Row Splitter< 1 %
- Statistics< 1 %
- Counter Generation< 1 %
- Variable Expressions< 1 %
- String to Path (Variable)< 1 %
- Container Input (Table)< 1 %
- JSON Writer< 1 %
- Decompress Files< 1 %
- Interval Loop Start< 1 %
- List Models< 1 %
- Create Chat Completion< 1 %
- Column Selection Configuration< 1 %
Call Remote Workflow (Row Based)< 1 %- Create Embedding< 1 %
- Create Image< 1 %
- Column Renamer< 1 %
- Value Lookup< 1 %
- Regex Extractor< 1 %
Generic Loop Start< 1 %- Color Manager< 1 %
- Java Snippet (simple)< 1 %
- Java Edit Variable< 1 %
- Data Explorer< 1 %
- Molecule Type Cast< 1 %
- Column Merger< 1 %
- Merge Variables< 1 %
- Excel Writer< 1 %
- Download (legacy)< 1 %
Table Reader< 1 %- Boolean Input (legacy)< 1 %
- Python Source (legacy)< 1 %
- Fail in execution< 1 %
- Java Snippet Row Filter< 1 %
- Boolean Configuration< 1 %
Container Input (Variable)< 1 %- Collection to String< 1 %
- String Manipulation (Multi Column)< 1 %
- Markup Tag Filter< 1 %
- Path to String (Variable)< 1 %
- String to Path< 1 %
- Create Collection Column< 1 %
Parameterized Database Query< 1 %- Column Aggregator< 1 %
- Lag Column< 1 %
- Extract Table Spec< 1 %
- TimeDelay Loop Start< 1 %
- Date&Time Input (legacy)< 1 %
XML Reader< 1 %- Start WebDriver< 1 %
- URL to File Path< 1 %
Variable to Table Column< 1 %Variable to Table Column< 1 %- Inject Variables (Data)< 1 %
Table Column to Variable< 1 %- Add Empty Rows< 1 %
- Auto-Binner< 1 %
Number To String< 1 %- Table Validator (Reference)< 1 %
- HiLite Row Splitter< 1 %
- String Configuration< 1 %
- CSS Editor< 1 %
Python Source< 1 %- Window Loop Start< 1 %
Extract Attribute< 1 %Flow Variable IF Switch< 1 %Database Looping< 1 %- Top k Row Filter< 1 %
- Delete Files/Folders< 1 %
- Single Selection Widget< 1 %
- Read Variables< 1 %
Table Row To Variable Loop Start< 1 %Database Reader< 1 %Concatenate (Optional in)< 1 %CASE Switch Data (End)< 1 %- Java Edit Variable (simple)< 1 %
- Mask Date/Time (legacy)< 1 %
- Chunk Loop Run-for-time Loop Start< 1 %
- Chunk Loop Run-to-time Loop Start< 1 %
- Generic Run-to-time Loop Start< 1 %
- Timed Loop End (1 port)< 1 %
- Run Heavy Garbage Collector< 1 %
- Benchmark End< 1 %
- Load text-based files< 1 %
- Upload (legacy)< 1 %
- Catch Errors (Var Ports)< 1 %
Table Column to Variable< 1 %Variable to Table Row< 1 %CSV Writer< 1 %Cell Splitter< 1 %String To Number< 1 %- Table Validator< 1 %
- Filter Apply Row Splitter< 1 %
- Nominal Value Row Splitter< 1 %
- XML to PMML< 1 %
- String Splitter (Regex)< 1 %
- Rule Engine Variable< 1 %
- Fingerprint Bayesian Learner< 1 %
- Generic Web Service Client< 1 %
- Shapefile reader< 1 %
- Nominal Row Filter Configuration< 1 %
- Credentials Configuration< 1 %
- Single Selection Configuration< 1 %
- Double Input (legacy)< 1 %
- File Chooser (legacy)< 1 %
- File Upload Widget< 1 %
- Container Output (JSON)< 1 %
- Date&Time to legacy Date&Time< 1 %
- Date&Time Shift< 1 %
- String to Date/Time (legacy)< 1 %
- HTML Node to Text< 1 %
HTTP Retriever< 1 %- List To Set< 1 %
- Active Learning Loop Start< 1 %
- Extract Variables (Data)< 1 %
- File Reader (Complex Format)< 1 %
Cell Replacer< 1 %String Replace (Dictionary)< 1 %- Rule-based Row Filter (Dictionary)< 1 %
- Amazon DynamoDB Scan< 1 %
- Explorer Browser< 1 %
- Path to String< 1 %
- Column Selection (legacy)< 1 %
- Container Input (Variable)< 1 %
- Container Output (Table)< 1 %
- DELETE Request< 1 %
- Remove Empty Rows< 1 %
- RDKit From Molecule< 1 %
- Web Page Content Extractor< 1 %
Views
- This node has no views
Workflows
[02.CX] Viber Community Report JSON Parsing WorkflowKNIME Hub- 0. TemplatesKNIME Hub
- 00_check_prime_numberKNIME Hub
00_xplan sf dbconv-insert via xport-AccountKNIME Hub- 01_ChEMBL_REST_ServicesKNIME Hub
- Show all 982 workflows
Links
- JSON to Tableby armingrudd on 2019-04-18forum.knime.com/p/58997
- Postman & HMAC Workflowby AnotherFraudUser on 2021-12-24forum.knime.com/p/142938
- Separate a JSON array and doing multiple POST Requestsby armingrudd on 2020-04-22forum.knime.com/p/88606
- Severe performance problems.by qqilihq on 2018-08-21forum.knime.com/p/46701
- Using JSON to tableby gab1one on 2019-02-26forum.knime.com/p/55196
- Show all 7 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.