Link?
For some compare and contrast between: jsonpath, jq, and jp these were for getting AWS ec2 instance IDs:
cat foo.json | jsonpath -p $.InstanceProfiles.[*].RoleId
cat foo.json | jq .InstanceProfiles[].Roles[].RoleId
cat foo.json | jp InstanceProfiles[].InstanceProfileId
apologies to mobile users!