JSONPath query
Select values from JSON using a JSONPath expression with code evaluation disabled.
Bookmark this page
Keep this page handy for next time.
- On a computer
- Press Ctrl + D, or Command + D on a Mac.
- On a phone or tablet
- Open your browser's menu or Share menu and look for Add Bookmark, Bookmark or Add to favourites.
A bookmark saves the page link. Save any tool results separately.
Processed on your device
How to use this tool
- Paste JSON and enter a JSONPath expression.
- Use property, index and wildcard selectors to retrieve values.
- Results are returned as a JSON array.
Things to know
- Script and filter evaluation is disabled. Expressions that require executing JavaScript are rejected.
- Each text input accepts up to 5 MiB. Output is limited to 25 MiB and combined text settings to 1 MiB.
- Structured documents accept up to 128 nesting levels and 250,000 values; query and schema modes have additional limits.
- Supported paths select properties, non-negative indexes, wildcards and descendants. Expressions accept 4,096 characters and 128 steps, with at most 10,000 matches. Unions, slices and filters are not supported.
You might also need
More in data & csvCSV column organiser
Select, reorder and rename CSV columns.
JSON formatter and validator
Validate and format JSON without rounding large integers.
CSV and JSON converter
Convert CSV records to JSON and JSON records to quoted CSV.
JSON and JSON Lines converter
Convert a JSON array to JSONL or combine JSON Lines into an array.
JSON and YAML converter
Convert between JSON and YAML while retaining large integer values.
JSON flatten and unflatten
Flatten JSON to JSON Pointer values and rebuild it without losing array types.
JSON Patch generator and applier
Generate RFC 6902 patches or safely apply a local patch to JSON.
JSON Schema generator
Infer a draft-07 schema from an example JSON document.
JSON Schema validator
Check JSON data against a local draft-07 JSON Schema.