Related JSON Tools

JSON Minifier

Compress JSON by removing whitespace and formatting

JSON Beautifier

Format and beautify JSON with proper indentation

JSON Converter

Convert JSON to XML, CSV, YAML and other formats

JSON Schema Validator

Validate JSON data against a JSON schema

JSON Path Finder

Extract and query JSON data using JSONPath expressions. Navigate complex structures and filter data with powerful path-based queries.

JSONPath Query

Data Extraction

Array Filtering

Path Navigation

JSONPath Expression

Enter a JSONPath expression to query your JSON data

Common JSONPath Examples:

JSON Data

Paste your JSON data here or upload a file

Query Results

Results from your JSONPath query

Execute a JSONPath query to see results here

📖 JSONPath Syntax Reference

Basic Syntax

$Root element

.propertyChild property

[index]Array index

[*]All array elements

..Recursive descent

Advanced Features

[start:end]Array slice

[?(@.prop)]Filter expression

.*All properties

@Current item (in filters)

What is JSONPath?

JSONPath is a query language for JSON, similar to XPath for XML. It allows you to extract specific data from JSON documents using path expressions. JSONPath provides a simple way to navigate and filter complex JSON structures.

With JSONPath, you can access nested objects, filter arrays based on conditions, and extract multiple values that match specific patterns, making it an essential tool for data processing and API integration.

Key Features

Path Expressions

Use dot notation and bracket syntax for navigation

Array Filtering

Filter arrays with conditional expressions

Wildcard Support

Use wildcards to match multiple elements

Multiple Results

Extract multiple matching values at once

Deep Navigation

Navigate deeply nested JSON structures

Real-time Results

See results update as you type

JSONPath Syntax Guide

Basic Operators

$Root element

.Child operator

..Recursive descent

*Wildcard

[]Array index/slice

Example Expressions

$.store.book[0].title

First book title

$.store.book[*].author

All book authors

$..price

All prices in document

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

Books under $10

Common Use Cases

API Data Processing

• Extract specific fields from API responses
• Filter data based on conditions
• Transform nested data structures

Configuration Management

• Extract configuration values
• Validate configuration structure
• Update specific settings

Data Analysis

• Analyze large JSON datasets
• Extract metrics and statistics
• Filter and aggregate data

Testing & Validation

• Verify API response structure
• Extract test data
• Validate data integrity

JSONPath Examples

Example 1: E-commerce Data

Sample JSON:

{
  "store": {
    "book": [
      {
        "category": "reference",
        "author": "Nigel Rees",
        "title": "Sayings of the Century",
        "price": 8.95
      },
      {
        "category": "fiction",
        "author": "Evelyn Waugh",
        "title": "Sword of Honour",
        "price": 12.99
      }
    ],
    "bicycle": {
      "color": "red",
      "price": 19.95
    }
  }
}

JSONPath Queries:

$.store.book[*].title

Result: All book titles

$..price

Result: [8.95, 12.99, 19.95]

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

Result: Books under $10

Example 2: User Data

Sample JSON:

{
  "users": [
    {
      "id": 1,
      "name": "John Doe",
      "email": "john@example.com",
      "active": true,
      "roles": ["user", "admin"]
    },
    {
      "id": 2,
      "name": "Jane Smith",
      "email": "jane@example.com",
      "active": false,
      "roles": ["user"]
    }
  ]
}

JSONPath Queries:

$.users[?(@.active)].name

Result: Active user names

$.users[*].roles[*]

Result: All user roles

$.users[0].email

Result: First user's email

Frequently Asked Questions

What is the difference between JSONPath and XPath?

JSONPath is designed specifically for JSON data, while XPath is for XML. JSONPath uses simpler syntax with dot notation and bracket expressions, making it more intuitive for JSON navigation.

How do I filter arrays with conditions?

Use the filter expression syntax: $[?(@.property operator value)]. For example,$.users[?(@.age > 18)] finds all users older than 18.

Can I use JSONPath with nested arrays?

Yes, JSONPath handles nested arrays well. Use multiple bracket notations like $.data[0].items[*]or recursive descent $..items[*] to access deeply nested array elements.

What operators are supported in filter expressions?

Common operators include: == (equals), != (not equals), < (less than),> (greater than), <= (less than or equal), >= (greater than or equal).

How do I extract all values of a specific property?

Use the recursive descent operator: $..propertyName will find all occurrences of "propertyName" throughout the entire JSON document, regardless of nesting level.

Is my JSON data secure when using this tool?

Yes, all JSONPath processing is performed locally in your browser. Your JSON data is never sent to our servers, ensuring complete privacy and security of your information.