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.
Add a comment
|
1 Answer
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 ""
2 Comments
chrisinmtown
Please improve this example by showing creation of the myJson object.
Markus
you can load the json for example with json.loads('your json string like upper example') hope this helps