JSONPath Query Tool

JSONPath Query Tool: Extract information from a JSON object with a JPath query.

Free · No sign-up required

Text input

Your result is ready to copy or download after running.

Tool options

About JSONPath Query Tool

Extract information from a JSON object with a JPath query.

Input: text. Output: text.

Example

Use “Try example” to load this public sample and its settings, then run it.

Settings used in this example
ParameterExample valueInput and choices
Query"$.store.book[*].author"Text
Result delimiter"\n"Escape sequences such as \n, \r and \t are supported

Input

{"store":{"book":[{"category":"reference","author":"Nigel Rees","title":"Sayings of the Century","price":8.95},{"category":"fiction","author":"Evelyn Waugh","title":"Sword of Honour","price":12.99},{"category":"fiction","author":"Herman Melville","title":"Moby Dick","isbn":"0-553-21311-3","price":8.99},{"category":"fiction","author":"J. R. R. Tolkien","title":"The Lord of the Rings","isbn":"0-395-19395-8","price":22.99}],"bicycle":{"color":"red","price":19.95},"newspaper":[{"format":"broadsheet","title":"Financial Times","price":2.75},{"format":"tabloid","title":"The Guardian","price":2}]}}

Result

"Nigel Rees"
"Evelyn Waugh"
"Herman Melville"
"J. R. R. Tolkien"

Parameters

ParameterDefault valueInput and choices
Query""Text
Result delimiter"\\n"Escape sequences such as \n, \r and \t are supported

Before interpreting the result

Extractors find patterns; a matching address or identifier is not proof that it exists or is reachable. Inspect the sample and matching options to understand false positives.

How to use this page

  1. Paste your input or open a local file.
  2. Adjust tool options if needed, then choose Run tool.
  3. Copy the result or download the original output bytes.

Inputs and results are not added to the public catalogue or saved in the URL. Processing happens in your browser; HTTP Request and DNS over HTTPS send the requests you explicitly run. Files up to 128 MiB can be opened; decompression and image tools may have smaller processing limits. Large results have a shortened preview. Text and HTML downloads use UTF-8; binary downloads preserve output bytes. Pasted text follows browser newline handling; open a file when exact input bytes matter.

Related tools

Browse extractors tools