Extract variable with filter expression on array not working

Google Cloud Apigee
1

I am trying to extract the county by checking for type “administrative_area_level_2”. Since types is an array, I need to check on index 0. I have also tried using indexOf, but with no success.

Here is what my jsonpath looks like:

$.address_components[?(@.types[0] == 'administrative_area_level_2')].long_name

.. and here is the payload.

{
"address_components" : [
            {
               "long_name" : "94043",
               "short_name" : "94043",
               "types" : [ "postal_code" ]
            },
            {
               "long_name" : "Mountain View",
               "short_name" : "Mountain View",
               "types" : [ "locality", "political" ]
            },
            {
               "long_name" : "Santa Clara County",
               "short_name" : "Santa Clara County",
               "types" : [ "administrative_area_level_2", "political" ]
            },
            {
               "long_name" : "California",
               "short_name" : "CA",
               "types" : [ "administrative_area_level_1", "political" ]
            },
            {
               "long_name" : "United States",
               "short_name" : "US",
               "types" : [ "country", "political" ]
            }
         ]
}

When I run it in a testing tool (ex. jsonpath.com), it returns “Santa Clara County”, but I am unable to see the same result when I try to extract it in Apigee. Am I missing something? Any help would be greatly appreciated.

1 Like
2

This could be because Edge is using an old version of the JSONPath library. An update is in the works.

See https://community.apigee.com/questions/51302/json-range-operator-not-working.html

1 Like
3

Yes, that is why

This query works in Apigee X and hybrid.

$.address_components[?(@.types[0] == 'administrative_area_level_2')].long_name