JSONPath Query
Extract data from JSON using JSONPath expressions. Query nested objects and arrays with powerful path syntax.
Examples:
JSON Input
Query Result
What is JSONPath Query?
JSONPath is a query language for JSON, similar to XPath for XML. It lets you extract specific data from complex JSON structures using path expressions like $.store.book[*].author. JSONKit's query tool supports the full JSONPath specification with instant results, match counting, and built-in example queries to get you started.
How to use
- Paste your JSON into the input editor.
- Type a JSONPath expression, such as $.store.book[*].author, into the query field.
- Click Execute to see every matching value and the number of matches.
- Use the Examples menu to try common patterns like filters and recursive search.
Features
- Full JSONPath support, including wildcards, array slices, recursive descent (..) and filter expressions.
- Shows the number of matches together with the results.
- Built-in examples to learn the syntax quickly.
- Runs in your browser with no data upload.
Frequently asked questions
- What is JSONPath?
- JSONPath is a query language for JSON, similar to XPath for XML. An expression starts at the root ($) and walks through keys and array indexes to select one or more values.
- How do I filter an array by a value?
- Use a filter expression. For example, $.store.book[?(@.price < 10)] selects every book whose price is below 10, and $..book[?(@.isbn)] selects books that have an isbn field.
- How do I find a key anywhere in the document?
- Use recursive descent with two dots. For example, $..author returns every author value no matter how deeply it is nested.