MCPcopy Index your code
hub / github.com/json-path/JsonPath

github.com/json-path/JsonPath @json-path-3.0.0 sqlite

repository ↗ · DeepWiki ↗ · release json-path-3.0.0 ↗
2,169 symbols 10,457 edges 204 files 223 documented · 10% 5 cross-repo links
README

Jayway JsonPath

A Java DSL for reading JSON documents.

Build Status Maven Central Javadoc

Jayway JsonPath is a Java port of Stefan Goessner JsonPath implementation.

Getting Started

JsonPath is available at the Central Maven Repository. Maven users add this to your POM.

[!NOTE]
Version 3.0.0 Uses Java 17 baseline to support Jackson 3


<dependency>
    <groupId>com.jayway.jsonpath</groupId>
    <artifactId>json-path</artifactId>
    <version>3.0.0</version>
</dependency>

If you need help ask questions at Stack Overflow. Tag the question 'jsonpath' and 'java'.

JsonPath expressions always refer to a JSON structure in the same way as XPath expression are used in combination with an XML document. The "root member object" in JsonPath is always referred to as $ regardless if it is an object or array.

JsonPath expressions can use the dot–notation

$.store.book[0].title

or the bracket–notation

$['store']['book'][0]['title']

Operators

Operator Description
$ The root element to query. This starts all path expressions.
@ The current node being processed by a filter predicate.
* Wildcard. Available anywhere a name or numeric are required.
.. Deep scan. Available anywhere a name is required.
.<name> Dot-notated child
['<name>' (, '<name>')] Bracket-notated child or children
[<number> (, <number>)] Array index or indexes
[start:end] Array slice operator
[?(<expression>)] Filter expression. Expression must evaluate to a boolean value.

Functions

Functions can be invoked at the tail end of a path - the input to a function is the output of the path expression. The function output is dictated by the function itself.

Function Description Output type
min() Provides the min value of an array of numbers Double
max() Provides the max value of an array of numbers Double
avg() Provides the average value of an array of numbers Double
stddev() Provides the standard deviation value of an array of numbers Double
length() Provides the length of an array Integer
sum() Provides the sum value of an array of numbers Double
keys() Provides the property keys (An alternative for terminal tilde ~) Set<E>
concat(X) Provides a concatinated version of the path output with a new item like input
append(X) add an item to the json path output array like input
first() Provides the first item of an array Depends on the array
last() Provides the last item of an array Depends on the array
index(X) Provides the item of an array of index: X, if the X is negative, take from backwards Depends on the array

Filter Operators

Filters are logical expressions used to filter arrays. A typical filter would be [?(@.age > 18)] where @ represents the current item being processed. More complex filters can be created with logical operators && and ||. String literals must be enclosed by single or double quotes ([?(@.color == 'blue')] or [?(@.color == "blue")]).

Operator Description
== left is equal to right (note that 1 is not equal to '1')
!= left is not equal to right
< left is less than right
<= left is less or equal to right
> left is greater than right
>= left is greater than or equal to right
=~ left matches regular expression [?(@.name =~ /foo.*?/i)]
in left exists in right [?(@.size in ['S', 'M'])]
nin left does not exists in right
subsetof left is a subset of right [?(@.sizes subsetof ['S', 'M', 'L'])]
anyof left has an intersection with right [?(@.sizes anyof ['M', 'L'])]
noneof left has no intersection with right [?(@.sizes noneof ['M', 'L'])]
size size of left (array or string) should match right
empty left (array or string) should be empty

Path Examples

Given the 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
            },
            {
                "category": "fiction",
                "author": "Herman Melville",
                "title": "Moby Dick",
                "isbn": "0-553-21311-3",
                "price": 8.99
            },
            {
                "category": "fiction",
                "author": "J. R. R. Tolkien",
                "title": "The Lord of the Rings",
                "isbn": "0-395-19395-8",
                "price": 22.99
            }
        ],
        "bicycle": {
            "color": "red",
            "price": 19.95
        }
    },
    "expensive": 10
}
JsonPath Result
$.store.book[*].author The authors of all books
$..author All authors
$.store.* All things, both books and bicycles
$.store..price The price of everything
$..book[2] The third book
$..book[-2] The second to last book
$..book[0,1] The first two books
$..book[:2] All books from index 0 (inclusive) until index 2 (exclusive)
$..book[1:2] All books from index 1 (inclusive) until index 2 (exclusive)
$..book[-2:] Last two books
$..book[2:] All books from index 2 (inclusive) to last
$..book[?(@.isbn)] All books with an ISBN number
$.store.book[?(@.price < 10)] All books in store cheaper than 10
$..book[?(@.price <= $['expensive'])] All books in store that are not "expensive"
$..book[?(@.author =~ /.*REES/i)] All books matching regex (ignore case)
$..* Give me every thing
$..book.length() The number of books

Reading a Document

The simplest most straight forward way to use JsonPath is via the static read API.

String json = "...";

List<String> authors = JsonPath.read(json, "$.store.book[*].author");

If you only want to read once this is OK. In case you need to read an other path as well this is not the way to go since the document will be parsed every time you call JsonPath.read(...). To avoid the problem you can parse the json first.

String json = "...";
Object document = Configuration.defaultConfiguration().jsonProvider().parse(json);

String author0 = JsonPath.read(document, "$.store.book[0].author");
String author1 = JsonPath.read(document, "$.store.book[1].author");

JsonPath also provides a fluent API. This is also the most flexible one.

String json = "...";

ReadContext ctx = JsonPath.parse(json);

List<String> authorsOfBooksWithISBN = ctx.read("$.store.book[?(@.isbn)].author");


List<Map<String, Object>> expensiveBooks = JsonPath
        .using(configuration)
        .parse(json)
        .read("$.store.book[?(@.price > 10)]", List.class);

What is Returned When?

When using JsonPath in java its important to know what type you expect in your result. JsonPath will automatically try to cast the result to the type expected by the invoker.

//Will throw an java.lang.ClassCastException    
List<String> list = JsonPath.parse(json).read("$.store.book[0].author");

//Works fine
String author = JsonPath.parse(json).read("$.store.book[0].author");

When evaluating a path you need to understand the concept of when a path is definite. A path is indefinite if it contains:

  • .. - a deep scan operator
  • ?(<expression>) - an expression
  • [<number>, <number> (, <number>)] - multiple array indexes

Indefinite paths always returns a list (as represented by current JsonProvider).

By default a simple object mapper is provided by the MappingProvider SPI. This allows you to specify the return type you want and the MappingProvider will try to perform the mapping. In the example below mapping between Long and Date is demonstrated.

String json = "{\"date_as_long\" : 1411455611975}";

Date date = JsonPath.parse(json).read("$['date_as_long']", Date.class);

If you configure JsonPath to use JacksonMappingProvider, Jackson3MappingProvider, GsonMappingProvider, or JakartaJsonProvider you can even map your JsonPath output directly into POJO's.

Book book = JsonPath.parse(json).read("$.store.book[0]", Book.class);

To obtain full generics type information, use TypeRef.

TypeRef<List<String>> typeRef = new TypeRef<List<String>>() {
};

List<String> titles = JsonPath.parse(JSON_DOCUMENT).read("$.store.book[*].title", typeRef);

Predicates

There are three different ways to create filter predicates in JsonPath.

Inline Predicates

Inline predicates are the ones defined in the path.

List<Map<String, Object>> books = JsonPath.parse(json)
        .read("$.store.book[?(@.price < 10)]");

You can use && and || to combine multiple predicates [?(@.price < 10 && @.category == 'fiction')] , [?(@.category == 'reference' || @.price > 10)].

You can use ! to negate a predicate [?(!(@.price < 10 && @.category == 'fiction'))].

Filter Predicates

Predicates can be built using the Filter API as shown below:

import static com.jayway.jsonpath.JsonPath.parse;
import static com.jayway.jsonpath.Criteria.where;
import static com.jayway.jsonpath.Filter.filter;
...
        ...

Filter cheapFictionFilter = filter(
        where("category").is("fiction").and("price").lte(10D)
);

List<Map<String, Object>> books =
        parse(json).read("$.store.book[?]", cheapFictionFilter);

Notice the placeholder ? for the filter in the path. When multiple filters are provided they are applied in order where the number of placeholders must match the number of provided filters. You can specify multiple predicate placeholders in one filter operation [?, ?], both predicates must match.

Filters can also be combined with 'OR' and 'AND'

Filter fooOrBar = filter(
        where("foo").exists(true)).or(where("bar").exists(true)
);

Filter fooAndBar = filter(
        where("foo").exists(true)).and(where("bar").exists(true)
);

Roll Your Own

Third option is to implement your own predicates

```java Predicate booksWithISBN = new Predicate() { @Override public boolean apply(PredicateContext ctx) { return ctx.item(Map.class).containsKey("isbn"); } };

List> boo

Extension points exported contracts — how you extend this code

MapFunction (Interface)
Returns a new representation for the input value. [15 implementers]
json-path/src/main/java/com/jayway/jsonpath/MapFunction.java
JsonAsserter (Interface)
(no doc) [2 implementers]
json-path-assert/src/main/java/com/jayway/jsonassert/JsonAsserter.java
MappingProvider (Interface)
Maps object between different Types [20 implementers]
json-path/src/main/java/com/jayway/jsonpath/spi/mapper/MappingProvider.java
PathFunction (Interface)
Defines the pattern by which a function can be executed over the result set in the particular path being grabbed. The F [15 …
json-path/src/main/java/com/jayway/jsonpath/internal/function/PathFunction.java
ILateBindingValue (Interface)
Obtain the late binding value at runtime rather than storing the value in the cache thus trashing the cache [8 implementers]
json-path/src/main/java/com/jayway/jsonpath/internal/function/latebinding/ILateBindingValue.java
JsonProvider (Interface)
(no doc) [7 implementers]
json-path/src/main/java/com/jayway/jsonpath/spi/json/JsonProvider.java

Core symbols most depended-on inside this repo

assertThat
called by 977
json-path-assert/src/main/java/com/jayway/jsonassert/JsonAsserter.java
read
called by 439
json-path/src/main/java/com/jayway/jsonpath/ReadContext.java
parse
called by 361
json-path/src/main/java/com/jayway/jsonpath/ParseContext.java
where
called by 250
json-path/src/main/java/com/jayway/jsonpath/Criteria.java
filter
called by 247
json-path/src/main/java/com/jayway/jsonpath/Filter.java
using
called by 246
json-path/src/main/java/com/jayway/jsonpath/JsonPath.java
apply
called by 221
json-path/src/main/java/com/jayway/jsonpath/Predicate.java
jsonProvider
called by 194
json-path/src/main/java/com/jayway/jsonpath/Configuration.java

Shape

Method 1,873
Class 267
Interface 22
Enum 7

Languages

Java100%

Modules by API surface

json-path/src/main/java/com/jayway/jsonpath/internal/filter/ValueNodes.java112 symbols
json-path/src/main/java/com/jayway/jsonpath/spi/json/JakartaJsonProvider.java88 symbols
json-path/src/test/java/com/jayway/jsonpath/old/IssuesTest.java63 symbols
json-path/src/test/java/com/jayway/jsonpath/FilterTest.java56 symbols
json-path/src/main/java/com/jayway/jsonpath/internal/PathRef.java51 symbols
json-path/src/main/java/com/jayway/jsonpath/internal/filter/EvaluatorFactory.java47 symbols
json-path/src/main/java/com/jayway/jsonpath/spi/mapper/JakartaMappingProvider.java40 symbols
json-path/src/main/java/com/jayway/jsonpath/spi/json/JettisonProvider.java39 symbols
json-path/src/main/java/com/jayway/jsonpath/internal/filter/ValueNode.java39 symbols
json-path/src/test/java/com/jayway/jsonpath/PathCompilerTest.java37 symbols
json-path/src/main/java/com/jayway/jsonpath/internal/CharacterIndex.java37 symbols
json-path/src/test/java/com/jayway/jsonpath/WriteTest.java36 symbols

For agents

$ claude mcp add JsonPath \
  -- python -m otcore.mcp_server <graph>

⬇ download graph artifact