JSON Path Finder - Extract JSON Paths Online
Paths will appear here once you enter valid JSON.
Find the Path to Any Value
Paste JSON on the left and the right panel lists every path in the
document, from $ down to each leaf, with its value and
type. Instead of counting braces to work out that the city you want is
$.orders[3].shipping.city, find the value in the
list and copy its path. Type in the filter box to narrow the list by
path or type, and click a row or its Copy button to copy the path.
Run a JSONPath Query
Type an expression into the query box and the table shows only the matching values and their paths. Supported syntax:
$.users[*].email: every user's email$..id: everyidkey at any depth$.items[0],$.items[-1],$.items[0:3]: index, last item, slice$['first name']: keys with spaces or symbols$.users[?(@.age > 30)]: filter with==,!=,<,<=,>,>=$.users[?(@.email)]: items that have a given key
Paths in Other Tools
Paths are shown in JSONPath form. Keys that are valid identifiers use
dot notation and anything else uses brackets, so a key with a hyphen
appears as $["content-type"]. Other tools spell the same
location slightly differently:
- jq: drop the
$:.orders[3].shipping.city. - JavaScript: replace
$with your variable:data.orders[3].shipping.city. Bracketed keys work unchanged. - Python: every step needs brackets:
data["orders"][3]["shipping"]["city"]. - PostgreSQL jsonb:
data #> '{orders,3,shipping,city}', or the SQL/JSON path'$.orders[3].shipping.city'withjsonb_path_query.
Filters support a single comparison or key check per expression. There
is no && / || and no functions such
as length(), so for more complex queries use jq or a
JSONPath library. To browse a document visually, use the
JSON tree viewer.
Related Tools
JSON Formatter & Beautifier
Format and beautify JSON with customisable indentation and syntax highlighting.
JSON Validator
Validate JSON syntax and get clear, human-readable error messages.
JSON Minifier
Minify JSON by removing all unnecessary whitespace for smaller payloads.
JSON Tree Viewer
Visualise JSON as a collapsible tree to explore deeply nested structures.