SmartTechnology solutions for business

JSONPath Explorer

Try JSONPath queries on a local document and extract results, with no API connection.

Supported: $.name, $["a b"], [0], [-1], [1:3], [*], .*, ..name (any depth), and filters such as [?(@.price < 10)] or [?(@.isbn)].

Try

Your result

Paste JSON and type a path. The matches appear here.

How to use it

  1. Paste JSON or press Try a sample.
  2. Type a path starting with $, or pick one of the suggestions.
  3. Copy the matching values or download them as JSON.

Examples

  • Every title$.store.book[*].title the title of each book
  • At any depth$..price every price field
  • A filter$.store.book[?(@.price < 10)].title titles of books under 10
Tool details and privacy

Paste JSON and type a path to see each matching value with its full path. Press any suggested path to try it.

Writing the right path for a tool, a test, or a database is easier when you see what it matches straight away.

Options

  • Read: $.name, $["a b"], [0], [-1], [1:3], [*], .*, ..name, and lists [0,2].
  • Filters: [?(@.price < 10)] and [?(@.isbn)] with ==, !=, <, <=, >, and >=.
  • Suggested paths are built from the JSON you pasted.

Limits

  • Expressions inside filters such as && or functions are not read.
  • A path that cannot be read is shown with the position of the problem.

Privacy

What you type stays in your browser. Nothing is uploaded or saved on the server.

Questions

What does $..price mean?

Every field named price, at any depth.

Do Arabic keys work?

Yes, such as $.store.اسم or $["full name"].

What if nothing matches?

A message says no value matches.

Is the JSON uploaded?

No.

Related tools

All tools