how can I use jsonpath in python? (jsonpath_ng.ext)

Question

I have a json data object and want to return a specific value like in XML with xpath. But on json with jsonpath.

The documentation is ok, but I miss a good example.

Answer 1

Because I had about 1 day to understand how it works and missed an example in the docs (https://pypi.python.org/pypi/jsonpath-ng/1.4.2), I post my code example here.

example for a structure like this:

"abilities": [
            {
          ...
                "name": "device_info",
                "properties": [
                    {
                        "name": "manufacturer",
                        "value": "xxxx",
                    },
                    {
                        "name": "product",
                        "value": "yyy",

                    }
                ],
                "type": "device_info"
            },
            {....}
            ]

The code to get a value of an ability and property:

from jsonpath_ng.ext import parse

abilityname = "device_info"
propertyname = "manufacturer"
result = parse('$[?(@.name=="' + abilityname + '")].properties[?(@.name=="' + propertyname + '")]').find(myJson)
if len(result) == 1:
    return str(result[0].value['value'])
else:
    return ""