JSON parse issue in Enrich Data by Webservice

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

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 documentedhere. 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:

Best Answer

  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified ExpertPosts:949Unicorn
    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

    sgenzer Thomas_Ott

Answers

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

    hmm very interesting. Thank you@BalazsBarany. I was usinghttp://goessner.net/articles/JsonPath/一直帮助但clearly not aligned with the JSON parser used here. Another good bookmark to keep on hand.

    Scott

    Thomas_Ott
Sign InorRegisterto comment.