How to check multiple keys in JsonPath

Question

I am trying to find an object in a JSON array using JsonPath. Here is my JSON:

[
  {
    "bpm": "766",
    "time": "20:14:57",
    "confidence": "0"
  },
  {
    "bpm": "766",
    "time": "20:14:57",
    "confidence": "0"
  },
  {
    "bpm": "767",
    "time": "20:14:33",
    "confidence": "0"
  }
]

I am using SelectToken with the following JsonPath query to try to find a JSON object using two keys bpm and time. There is supposed to be an and operator between bpm and time.

Here is my query:

$.[?(@.bpm=='767',@.time=='20:14:33')]

But I'm getting an error saying there is an unexpected character , after '767'. What am I doing wrong?

Brian Rogers · Accepted Answer · 2020-04-28 19:45:25Z

1

In Newtonsoft's implementation of JsonPath, the and operator is a double ampersand &&, not a comma ,. Change your expression as shown below and it should work properly:

var array = JArray.Parse(json);
var obj = array.SelectToken("$.[?(@.bpm=='767' && @.time=='20:14:33')]");

Fiddle: https://dotnetfiddle.net/gpU56p

edited Apr 28, 2020 at 19:45

answered Apr 28, 2020 at 19:25

Brian Rogers

130k31 gold badges315 silver badges315 bronze badges

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

Collectives™ on Stack Overflow

How to check multiple keys in JsonPath

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