Skip to main content
Solved

reading dutch json

  • April 4, 2018
  • 5 replies
  • 19 views

robert_punt
Contributor
Forum|alt.badge.img+7

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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

5 replies

david_r
Celebrity
  • 8394 replies
  • April 4, 2018

Here's one way to do it:


takashi
Celebrity
  • 7843 replies
  • 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+7
  • Author
  • Contributor
  • 23 replies
  • 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

That does the trick. @takashi

 

  thank you very much.

robert_punt
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • 23 replies
  • April 4, 2018

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
Celebrity
  • 8394 replies
  • April 4, 2018
@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.