Skip to main content
Solved

reading dutch json


robert_punt
Contributor
Forum|alt.badge.img+6

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

Best answer by takashi

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

View original
Did this help you find an answer to your question?

5 replies

david_r
Evangelist
  • April 4, 2018

Here's one way to do it:


takashi
Contributor
Forum|alt.badge.img+19
  • Contributor
  • Best Answer
  • April 4, 2018

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


robert_punt
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • April 4, 2018
takashi wrote:

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.

robert_punt
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • April 4, 2018
david_r wrote:

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
Evangelist
  • April 4, 2018
robert_punt wrote:
@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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings