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 ?
Solved! Go to Solution.
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.
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.
Thanks @arghya das
...and your workaround, of course, is to just use a Javascript callout to extract that field.