Hub
Pricing About
NodeNode / Manipulator

JSON Path (deprecated)

Structured DataJSONStreamable

This node has been deprecated and its use is not recommended. Please search for updated nodes instead.

Like

JSONPath is a similar to XPath alternative for JSON.

The result can be a single value or a list of multiple values.

There are two notations, dot-notation: $.book[1].title and bracket-notation: $['book'][1]['title'] (indexing starts from 0 , negative indices are relative to the last element).

Example input: {"book": [ {"year": 1999, "title": "Timeline", "author": "Michael Crichton"}, {"year": 2000, "title": "Plain Truth", "author": "Jodi Picoult"} ]}

Example results: $.book[0] - {"year": 1999, "title": "Timeline", "author": "Michael Crichton"} (JSON or String single value)
$.book[*].year - [1999,2000] (JSON or Int or Real list)
$.book[2].year - ? (no such part)
$..author - Timeline (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']
which are valid JSONPaths for the input JSON value.

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).

It uses the jayway / JsonPath implementation.

Node details

Input ports
  1. Type: Table
    Table with JSON
    A table with JSON column
Output ports
  1. Type: Table
    Table
    Table with the found parts

Extension

The JSON Path (deprecated) node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
  2. Go to item
  3. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits