RapidMiner

JSON parse issue in Enrich Data by Webservice

SOLVED
Community Manager

JSON parse issue in Enrich Data by Webservice

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  Smiley Happy  ]

 

Thanks.

Scott

Scott Genzer
Senior Community Manager
RapidMiner, Inc.

Attachments

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
RMStaff
Solution
Accepted by topic author sgenzer
‎06-19-2017 12:17 PM

Re: JSON parse issue in Enrich Data by Webservice

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

--
Balázs Bárány
Data Scientist, Vienna
https://datascientist.at
2 REPLIES
Highlighted
RMStaff
Solution
Accepted by topic author sgenzer
‎06-19-2017 12:17 PM

Re: JSON parse issue in Enrich Data by Webservice

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

--
Balázs Bárány
Data Scientist, Vienna
https://datascientist.at
Community Manager

Re: JSON parse issue in Enrich Data by Webservice

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

 

Scott Genzer
Senior Community Manager
RapidMiner, Inc.