JSONPath tester

Results are for the sample bookstore document in the tester (load it with [sample]).

JSONPath existed for 17 years as a 2007 blog post before RFC 9535 standardised it, so libraries disagree on the details. This tester runs jsonpath-plus, which follows Goessner's original syntax with extras, and rewrites two common RFC forms so they work too: filters without parentheses ([?@.price < 10]) and negative indexes ([-1]).

RFC 9535 function extensions such as length(), count(), match(), search() and value() are not available here. Filters run in jsonpath-plus's safe evaluator, which supports comparisons, &&, ||, ! and property access, without running arbitrary JavaScript.

JavaScript with jsonpath-plus:

import { JSONPath } from 'jsonpath-plus';

const titles = JSONPath({ path: '$..book[?(@.price < 10)].title', json: data });
// ['Sayings of the Century', 'Moby Dick']

Python with jsonpath-ng (filters need the ext parser):

from jsonpath_ng.ext import parse

titles = [m.value for m in parse('$..book[?(@.price < 10)].title').find(data)]

kubectl uses JSONPath templates in curly braces, and the leading $ is optional:

kubectl get pods -o jsonpath='{.items[*].metadata.name}'
kubectl get pods -o jsonpath='{range .items[*]}{.metadata.name}{"\t"}{.status.phase}{"\n"}{end}'

Three query languages for JSON with different syntax. The same query, titles of books under 10, in each:

PostgreSQL's SQL/JSON path looks like JSONPath but puts filters after the step (? (@.price < 10)), so expressions do not copy across unchanged.

• Keys are case-sensitive. $.Store finds nothing in a document with store.
• Quote keys with spaces, dashes or dots. $.first-name does not work; write $['first-name'].
• No match is not an error. A wrong path returns an empty list. Check each step from the left, or click the key in the document view to get the exact path.
• .. can be slow and broad. $..id also matches ids inside nested objects you did not mean. Use the full path when you know it.

Format or repair the JSON first with the JSON formatter, describe its shape with the JSON Schema generator or JSON to TypeScript, and find more API tools in API tools on DevHunt.