JSON Path Finder

Query JSON documents using JSONPath expressions.

JSONPath Examples
$ - Root element
$.store.book - All books in store
$.store.book[0] - First book
$.store.book[-1] - Last book
$.store.book[0,1] - First two books
$.store.book[:2] - First two books (slice)
$.store.book[*].author - All authors
$..author - All authors (recursive)
$.store.* - All things in store
$.store..price - All prices
$..book[?(@.price<10)] - Books cheaper than 10
$..book[?(@.author=~'/.*Tolkien/i')] - Books by Tolkien (regex)
Sample JSON

What Is JSONPath?

JSONPath is a query language for JSON data, similar to how XPath works for XML. It allows you to navigate, search, and extract specific values from complex JSON structures using path expressions. Originally proposed by Stefan Gössner in 2007, JSONPath has become a widely adopted standard for querying JSON data in APIs, configuration systems, and data processing pipelines.

JSONPath Syntax

ExpressionMeaningExample
$Root object$ — entire document
.keyChild property$.store.name
[n]Array element by index$.items[0]
[*]All elements in an array$.items[*].name
..Recursive descent (search all levels)$..price — all prices anywhere
[start:end]Array slice$.items[0:3] — first 3 items
[?()]Filter expression$.items[?(@.price < 10)]

Common Use Cases

  • API Response Parsing: Extract specific fields from large API responses without parsing the entire document manually.
  • Data Transformation: Select and reshape JSON data in ETL pipelines and data processing workflows.
  • Configuration Querying: Navigate complex configuration files to find specific settings.
  • Testing & Assertions: Validate specific values in API responses during automated testing.
  • Log Analysis: Extract fields from structured JSON log entries for monitoring and alerting.

How to Use This Tool

  1. Paste your JSON data into the left panel.
  2. Enter a JSONPath expression (e.g., $.store.book[*].author).
  3. Click Find to execute the query.
  4. View the matching results highlighted in the output.

Why Use This Tool?

  • Query and extract specific data from complex JSON structures.
  • Test JSONPath expressions before using them in code.
  • Visual result highlighting makes it easy to verify queries.
  • Essential for working with REST APIs and JSON data stores.

Frequently Asked Questions

What is the difference between JSONPath and jq?

JSONPath is a query language with XPath-like syntax, commonly used in libraries across many programming languages. jq is a command-line JSON processor with its own query syntax, primarily used in shell scripts. Both achieve similar results but have different syntax and ecosystems.

Does JSONPath modify the original JSON?

No. JSONPath is read-only — it selects and extracts data from JSON without modifying the source document.