The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
JSON parse issue in Enrich Data by Webservice
sgenzer
Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,959 
Community Manager
Hi...I have never been able to send commands such as this via the Enrich Data by Webservice when using the JSON parser: $..foo[1] Often I want to find the 2nd, 3rd or whatever. I am using the notation as documented here. Ideas? Attached is a sample JSON file where I want to get $..lat, $..lat[1], $..lat[2] and so on.
[note: the attached file is a .zip file because this community site does not accept .json or .txt suffixes 
]
Thanks.
Scott
Tagged:
0
Best Answer
-
BalazsBarany
Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 
Unicorn
Are you sure your JSONPath is correct?
I always use the online parser at jsonpath.com for checking my expressions. In your case, the following expressions work:
$.results[*].geometry.location.lat (all latitudes)
$.results[0].geometry.location.lat (first latitude)
Regards,
Balázs
2
Answers
hmm very interesting. Thank you @BalazsBarany. I was using http://goessner.net/articles/JsonPath/ which has always helped but clearly not aligned with the JSON parser used here. Another good bookmark to keep on hand.
Scott