JsonPath: find an element in an array by field

Question

I have an anonymous array of objects and I'd like to find an object by a specific field.

I tried this:

jsonPath.get("$.[?(@.name == 'David')]")

but I'm getting the following error:

Invalid JSON expression:
Script1.groovy: 1: Unexpected input: '                         $.[' @ line 1, column 29.
                            $.[?(@.name == 'David')]
                               ^

1 error

How do I fix that?

The json is:

[
 {"name": "David"}, {"name": "Ron"}, {"name": "Dana"}
]

score 3 · Accepted Answer · answered Sep 14 '20 at 16:13

3

The question is a bit ambiguous, But the syntax is incorrect, Json path syntax uses Groovy's GPath notation

js.getString("find {it.name == 'David'}")

answered Sep 14 '20 at 16:13

Wilfred Clement

2,674
2
14
29

Not sure I get the syntax. What is `it`? – IsaacLevon Sep 14 '20 at 16:28
1

`it` operator in `Groovy` is similar to `@` operator in `Jayway` – Wilfred Clement Sep 14 '20 at 16:43

score 0 · Answer 2 · answered Sep 14 '20 at 14:56

0

You may need

$.[?(@.name == 'David')]

=>  $.data[?(@.name == 'David')]
    $.response[?(@.name == 'David')]
    $.body[?(@.name == 'David')]
    ...

The name depends on when you extract your response

answered Sep 14 '20 at 14:56

Rony Nguyen

1,067
8
18

The array is anonymous (look at the JSON example please) – IsaacLevon Sep 14 '20 at 14:58
Only OP know that, but It's should not be anonymous lol – Rony Nguyen Sep 14 '20 at 15:03

score 0 · Answer 3 · answered Sep 14 '20 at 14:56

0

Because You are using json Array , do use - $[0] , since david is on first index.

answered Sep 14 '20 at 14:56

javaHolic

45
7

This is just an example. The placement is arbitrary – IsaacLevon Sep 14 '20 at 14:57
1

Agreed, que was ambiguous. – javaHolic Sep 14 '20 at 14:58

JsonPath: find an element in an array by field

3 Answers3