Ready

Input JSON

Characters: 0Size: 0 KB

JSONPath Expression

JSONPath Examples

$.store.book[0,1]

Select both books by index

$.store.book[-1:]

Select last book using slice

$..title

Recursively find all titles

$..book

Recursively find all book arrays

$.store.book[?(@.price >= 10)]

Books priced ≥10

$.store.book[?(@.title == "Book 1")]

Exact title match

$.store.book[?(@.price * 2 == 20)]

Price math condition

$.store.book[?(@.title.length > 5)]

Title length condition

$.store.book[*].{"name":title,"cost":price}

Custom output format

$.*~

Get all possible paths

$.store.book[?(@.price > 10)].title

Filter then project

$..book[0:2].title

Slice then project

Query Results

Characters: 0Size: 0 KB

JSONPath Syntax Guide

  • $ - Root object (required)
  • . - Child operator (e.g. .store)
  • [n] - Array index (e.g. [0])
  • [*] - Array wildcard (must follow with property)
  • .. - Recursive search (e.g. ..price)

JSONPath Query Tool Online

Professional query features:

This tool provides solutions for working with jsonpath query tool data.

Core Features

RFC 9535 Compliance

Full JSONPath standard implementation

Interactive Builder

Visual query construction with autocomplete

Multiple Output Formats

Values, paths or highlighted results

Query History

Save and recall frequent queries

Example

Input:

{
  "store": {
    "book": [
      {"title": "Book 1", "price": 10.99},
      {"title": "Book 2", "price": 15.99}
    ]
  }
}

Output:

[
  {
    "title": "Book 1",
    "price": 10.99
  },
  {
    "title": "Book 2",
    "price": 15.99
  }
]

Related Tools

JSON VisualizerInteractive explorer for JSON Path query results with tree navigationJSON ConverterTransform JSON Path query results to CSV, XML and other formatsJSON Diff ToolCompare JSON Path query results across different documentsJSON Schema GeneratorCreate schemas from JSON Path extracted data structures

Categories

JSONPathData ExtractionQuery LanguageDeveloper ToolsData AnalysisJSON Processing

Quick Tips

• Use Ctrl+Enter to format instantly

• Customize formatting options

• Drag and drop files into editor