JsonPath not working

Google Cloud Apigee
1

I am trying to apply the JsonPath:$.Party.aRolePlayer.Person.Registration[?(@.typeName = ‘ECN’)].externalReference

on the following Json and it is not working. I get a blank response. It works fine https://jsonpath.curiousconcept.com/.

{ 
        "Party": { 
                "retrievalLevel": 2099, 
                "aRolePlayer": { 
                        "Person": { 
                                "Registration": [ 
                                        { 
                                                "typeName": "something1", 
                                                "externalReference": "abcdefgh" 
                                        }, { 
                                                "typeName": "something2", 
                                                "externalReference": "12345678" 
                                        } 
                                ] 
                        } 
                } 
        } 
}

I am guessing the JsonPath implementation inside EDGE do not support this particular syntax ?

2

I know we have a bug in Edge which can’t handle with complex json with nested json structure. See https://apigeesc.atlassian.net/browse/APIRT-860 for more details. It is not fixed yet.

3

Thanks @arghya das

4

…and your workaround, of course, is to just use a Javascript callout to extract that field.

1 Like
5

This question is from a long time ago, of course… but as of 5-6 years ago, at least, this works in Apigee. Using this JSON:

{
  "Party": {
    "retrievalLevel": 2099,
    "aRolePlayer": {
      "Person": {
        "Registration": [
          {
            "typeName": "ECN",
            "externalReference": "abcdefgh"
          },
          {
            "typeName": "something2",
            "externalReference": "12345678"
          }
        ]
      }
    }
  }
}

with this query

$.Party.aRolePlayer.Person.Registration[?(@.typeName == 'ECN')].externalReference

I get the expected

[
  "abcdefgh"
]
1 Like