Skip to main content

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:

json["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:

json["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.