JSONpath in Python Tasks

This topic contains JSONpath examples.

Examples

See the following JSON document. It shows how JSONpath expressions can be added to it.

```json { "json_response": { "entities": [ { "id": "email:[email protected]", "name": "[email protected]", "type": "EmailAddress", "count": 12 }, { "id": "email:[email protected]", "name": "[email protected]", "type": "EmailAddress", "count": 2 }, { "id": "email:[email protected]", "name": "[email protected]", "type": "EmailAddress", "count": 5 }, { "id": "idn:firebase.com", "name": "firebase.com", "type": "InternetDomainName", "count": 9 }, { "id": "idn:mopub.com", "name": "mopub.com", "type": "InternetDomainName", "count": 1 }, { "id": "ip:23.2.3.3", "name": "23.2.3.3", "type": "IpAddress", "count": 27 }, { "id": "ip:123.1.1.1", "name": "123.1.1.1", "type": "IpAddress", "count": 2 }, { "id": "ip:123.4.5.6", "name": "123.4.5.6", "type": "IpAddress", "count": 1 } ] } } ```

You can form expressions to suit your requirement using the supported JSONpath syntax and filters.

Expression	Result
$	Entire object
$.json_response	Entire json_response object
$.json_response.entities[0]	First entity
$.['json_response']['entities'][0]	First entity
$.json_response.entities[0,2]	First and third entity
$.json_response.entities[:2]	First two entities
$.json_response.entities[-2:]	Last two entities
$.json_response.entities[*].name	The name of all the entities
$..id	All the ids
$.json_response.entities[?(@.count > 6)]	All entities with count greater than 6
$..entities[?(@.type == "InternetDomainName")]	All entities with type InternetDomainName