Invalid Expression exception for JsonPath in RestAssured

Question

We are using restassured for API automation in our project . I have sample response for which I tested JsonPath expression on https://www.jsonquerytool.com/. My Json expression is - $[*]['tags'][?(@.id==0)]. I am getting proper output when I tried expression on JsonQuerytool. But when I try same in below code , I get invalid expression message -

JsonPath jsonPathEvaluator = response.jsonPath();

ArrayList result = jsonPathEvaluator.get("$[*]['tags'][?(@.id==0)]");

Above code throws exception .

Can anyone tell me how can I programmatically query the response using JsonPathEvaluator ?

P.S - Response not pasted as it was very huge.

Answer 1

Since your issue is not in any particular query (expression does not matter) I'm answering using example from the link you provided.

RestAssured uses some special JsonPath library (which uses its own syntax in some cases) called GPath. So if you have json like this:

{
    "key": "value",
    "array": [
        {
            "key": 1
        },
        {
            "key": 2,
            "dictionary": {
                "a": "Apple",
                "b": "Butterfly",
                "c": "Cat",
                "d": "Dog"
            }
        },
        {
            "key": 3
        }
    ]
}

And expect you would use query like this: $.array[?(@.key==2)].dictionary.a

Then for RestAssured case your query would be like this: array.findAll{i -> i.key == 2}.dictionary.a

So the complete code example would be:

public static void main(String[] args) {
    JsonPath jsonPath = RestAssured
            .get("http://demo1954881.mockable.io/gath")
            .jsonPath();
    List<String> resp = jsonPath.get("array.findAll{i -> i.key == 2}.dictionary.a");
    System.out.println(resp);
}