Skip to main content
  • EN

Hi everybody, ik am trying to read an url that gives me json-format answer.

the url is like:

https://geodata.nationaalgeoregister.nl/locatieserver/v3/suggest?wt=json&q;=Nieuwe Steen 1 Hoorn

i want to read the values of the attributes "type" "weergavenaam" "id" "score"

regard,

Bert punt

Here's one way to do it:

Hi @robert_punt, I think this would be a typical use case of the JSONFragmenter. After getting the JSON document with an HTTPCaller, try a JSONFragmenter with this setting.

JSON Query:

jsonN"response"]>"docs"]

    • 0684Q00000ArKVhQAN.png

    Hi @robert_punt, I think this would be a typical use case of the JSONFragmenter. After getting the JSON document with an HTTPCaller, try a JSONFragmenter with this setting.

    JSON Query:

    jsonN"response"]>"docs"]

    • 0684Q00000ArKVhQAN.png

    That does the trick. @takashi

     

      thank you very much.

    Here's one way to do it:

    @david_r

     

    tnak you voor your comment but the solution from Takashi uses less transformers. so i am using that solution.
    @david_r

     

    tnak you voor your comment but the solution from Takashi uses less transformers. so i am using that solution.
    No worries, I agree that his solution was a bit more compact. That's the beauty of FME, lot's of ways to accomplish the same thing.

    Reply


    Community Stats

    30,469
    Posts
    115,710
    Replies
    38,288
    Members
    Terms & ConditionsCookie settings
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.