JSON parse issue in Enrich Data by Webservice

sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,959 Community Manager
edited December 2018 in Help

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

Best Answer

  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 Unicorn
    Solution Accepted

    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

Answers

  • sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,959 Community Manager

    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

     

Sign In or Register to comment.