Filtering JSONPath with given string value

Question

If I have a JSON like so:

{
  "data": [
    {
        "service" : { "id" : 1 }
    },
    {
        "service" : { "id" : 2 }
    },
    {
        "service" : {}
    }
  ]
}

This query works:

$..service[?(@.id==2)]

And gives expected result:

[
    {
        "id" : 2
    }
]

However, if I had strings as id's:

{
  "data": [
    {
        "service" : { "id" : "a" }
    },
    {
        "service" : { "id" : "b" }
    },
    {
        "service" : {}
    }
  ]
}

Running similar query:

$..service[?(@.id == "a")]

Gives no results (empty array).
I am using this evaluator.
I was looking at docs here but could not find anything to point me in the right direction... Any help if someone knows how to write such query? Thanks :)

br00 · Accepted Answer · 2015-07-20 15:30:01Z

1

without " works

$..service[?(@.id == b)]

give this result

[
   {
      "id" : "b"
   }
]

answered Jul 20, 2015 at 15:30

br00

1,45413 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Filtering JSONPath with given string value

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