JSON PATH Field NULL Checking Expression

Question

I have a json array like bellow :

{
"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,
            "likes": 1
        },
        {
            "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}

I was trying to find all books price which have no likes field. Is it possible to find using Jayway Json Path library. I am trying something like this $.store.book[? (@.likes == null)].price but i don't know whether there is anything like that?

You can use jsonpath.com to validate.

Anuruddha
– Anuruddha

2018-01-05 08:01:12 +00:00
Commented Jan 5, 2018 at 8:01 — Anuruddha
– Anuruddha, Commented Jan 5, 2018 at 8:01

glytching · Accepted Answer · 2018-01-05 08:19:11Z

10

This jsonpath expression is correct:

$.store.book[?(@.likes == null)].price

But you must set DEFAULT_PATH_LEAF_TO_NULL, for example:

Configuration conf = Configuration.defaultConfiguration()
    .addOptions(Option.DEFAULT_PATH_LEAF_TO_NULL);

String pricesForBooksWithNoLikes = JsonPath.using(conf).parse(json)
    .read("$.store.book[?(@.likes == null)].price");

More details in the docs.

Here's a screenshot showing this read working, using the Jayway JsonPath Evaluator:

answered Jan 5, 2018 at 8:19

glytching

48.5k11 gold badges127 silver badges129 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

JSON PATH Field NULL Checking Expression

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related