JSONPath Guide: Query JSON Data Like SQL (with Examples)

What is JSONPath?

JSONPath is a query language for JSON, similar to XPath for XML. It lets you extract specific values from complex JSON structures using path expressions.

Basic Syntax

Filter Expressions

// All users with age over 18
$.users[?(@.age > 18)]

// Products in stock
$.products[?(@.inStock == true)]

// Items matching a string
$.items[?(@.status == 'active')]

JavaScript: jsonpath-plus

import { JSONPath } from 'jsonpath-plus';

const result = JSONPath({
  path: '$.store.book[?(@.price < 10)].title',
  json: data
});
console.log(result); // array of matching values

Python: jsonpath-ng

from jsonpath_ng import parse

expr = parse('$.store.book[*].author')
matches = [m.value for m in expr.find(data)]
print(matches)

Test JSONPath expressions live against your own JSON using the JSONPath Tester at jsondecode.com.