JSON Path for Array Of Array using Jayway JSON Path

Question

I have a JSON Structured like this :

[{
  "firstName": "John",
  "age"      : 26,
  "phoneNumbers": [
    {
      "type"  : "iPhone",
      "number": "0123-4567-8888"
    },
    {
      "type"  : "home",
      "number": "0123-4567-8910"
    }
  ]
},
{
  "firstName": "Johny",
  "lastName" : "doe",
  "age"      : 26,
  "address"  : {
    "streetAddress": "naist street",
    "city"         : "Nara",
    "postalCode"   : "630-0192"
  },
  "phoneNumbers": [
    {
      "type"  : "iPhone",
      "number": "0123-4567-8888"
    },
    {
      "type"  : "home",
      "number": "0123-4567-8910"
    }
  ]
}]

I want to extract the users who have a Iphone and name is JOHN .

I have used below expression

$[?(@.firstName=='John')].phoneNumbers[?(@.type=='iPhone')]

But I want to extract the complete user information . I have tried Filter Criteria API as well , but In it I am not able to find a way to access Phone Type attribute.

Learner · Accepted Answer · 2017-12-27 04:50:06Z

1

As mentioned in this post, the Jayway implementation supports inlined AND and OR criteria. The following JSON Path should meet your requirements.

$[?(@.firstName=='John' && 'iPhone' in @.phoneNumbers[*].type)]

Below is screenshot from Jayway JsonPath Evaluator

Also, please be informed that the syntax may vary depending on the implementation used.

edited Dec 27, 2017 at 4:50

answered Dec 26, 2017 at 16:34

Learner

2392 silver badges13 bronze badges

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

3 Comments

priyas Over a year ago

thanks for your response. That's exactly I was looking for . Though I am not aware what this phoneNumbers[:100] is significant for . Can you please explain ?

Learner Over a year ago

[:100] means the first hundred phone numbers of the person. Assuming a person cannot have more than hundred phone numbers, this should work. It should ideally be the actual number of phone numbers of a person, which I could not get from jsonpath syntax for some reason. :)

Learner Over a year ago

@priyas - I found [*] to be working as expected instead of hard coding [:100]. I've updated the answer accordingly. Please check.

Happs · Accepted Answer · 2017-12-26 11:33:35Z

0

for(var i=0;i<s.length;i++){
  for(var j=0;j<s[i].phoneNumbers.length;j++){
    if(s[i].phoneNumbers[j].type == 'iPhone'){
        alert(s[i].firstName+" "+s[i].age+" "+s[i].phoneNumbers[j].type+" 
              "+s[i].phoneNumbers[j].number);
    }
  }
}

Here var s is your json object.

answered Dec 26, 2017 at 11:33

Happs

1258 bronze badges

Collectives™ on Stack Overflow

JSON Path for Array Of Array using Jayway JSON Path

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related