JSONPath Tester (Query JSON)

What is JSONPath?

JSONPath = "XPath for JSON". A query syntax to extract slices of data from JSON objects/arrays. Common in:

• Postman: API response assertions — $.data.users[0].id === 1.
• jq (CLI): similar patterns for command-line JSON.
• AWS CLI: --query 'Reservations[*].Instances[*].PublicIpAddress'.
• OpenSearch / Elasticsearch: query nested fields.
• LangChain / LLM: extract structured output from LLM responses.

Syntax cheat sheet

• $ — root.
• $.foo or $["foo"] — property.
• $[0] — index, $[-1] — last.
• $[*] — all elements/properties.
• $[0:3] — slice.
• $..price — recursive descent (every price at any level).
• $.items[?(@.price > 100)] — filter.

Real-world example

// API response
{
  "store": {
    "books": [
      { "title": "AI for Everyone", "price": 350000 },
      { "title": "Sapiens", "price": 280000 }
    ]
  }
}

// Get all titles:
$.store.books[*].title  // ["AI for Everyone", "Sapiens"]

// Books with price > 300k:
$.store.books[?(@.price > 300000)]

// Recursive — every price in the document:
$..price  // [350000, 280000]

JSONPath vs JSON Pointer (RFC 6901)

• JSONPath: query language — flexible, supports wildcards and filters.
• JSON Pointer (/foo/0/bar): points to a single location, no wildcards.