JSONPath Tester
Evaluate a JSONPath query against a parsed JSON document and show matching values and paths.
Your workspace
Server processingThis tool evaluates a JSONPath query against a provided JSON document, identifying and displaying all matching values along with their corresponding paths.
How to query JSON
- Paste your JSON document into the Input area.
- Enter your JSONPath expression in the query field.
- Submit the form to view a list of all matching values and their exact paths within the JSON structure.
Querying JSON structures
The tool parses your JSON input and applies the specified JSONPath expression to locate data. It returns a list of matches, where each entry includes the full path to the data point and the value found at that location. This is useful for verifying paths in complex or nested JSON objects.
Processing limits
The operation supports a maximum of 50,000 characters for the input JSON. All processing occurs on the server, and results are ephemeral, expiring 15 minutes after generation. Ensure you save any necessary output locally as it is not stored permanently.
JSONPath extraction
Input: {"users": [{"id": 1, "name": "Alice"}, {"id": 2, "name": "Bob"}]} JSONPath: $.users[*].name
The tool returns two matches: the path '$.users[0].name' with value 'Alice' and the path '$.users[1].name' with value 'Bob'.
JSONPath testing questions
What happens if the JSONPath query finds no matches?
If the query does not match any part of the document, the tool will return an empty list of results.
Is there a limit to the number of results displayed?
Yes, the tool displays up to 1,000 matching results per query.
Continue your workflow
CSV Delimiter Converter
Rewrite CSV using a selected delimiter with correct field quoting.
CSV to JSON
Parse comma-separated records using the first row as property names.
CSV to SQL Inserts
Generate quoted SQL INSERT statements from CSV headers and values; the result is text and is not executed.
CSV Validator
Inspect CSV rows for inconsistent field counts, duplicate column headings and malformed quoting.