Skip to main content
Solved

Access JSON URL in attribute

  • March 13, 2018
  • 2 replies
  • 26 views

dms2
Contributor
Forum|alt.badge.img+11
  • Contributor
  • 48 replies

I'm very new with FME and there's a few things I cannot get to work.

I have a feature with an URL as an attribute and it's like this:

http://serverName//document?searchText="section3"&start;=1&max;=1&f;=pjson

I want to read the JSON in it with it's attributes (which I don't know) separated to do something with them.

I've been playing with some JSON transformers like JSONFlattener and so on, but I can't get the JSON.

Any idea?

Best answer by david_r

You can use the HTTPCaller to read the JSON from the server and return it in an attribute.

You can then use the JSONFlattener or JSONFragmenter on that attribute to convert the JSON document to FME attributes.

If you need a more specific answer, please consider posting some sample JSON here.

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.

2 replies

david_r
Celebrity
  • 8394 replies
  • Best Answer
  • March 13, 2018

You can use the HTTPCaller to read the JSON from the server and return it in an attribute.

You can then use the JSONFlattener or JSONFragmenter on that attribute to convert the JSON document to FME attributes.

If you need a more specific answer, please consider posting some sample JSON here.


dms2
Contributor
Forum|alt.badge.img+11
  • Author
  • Contributor
  • 48 replies
  • March 15, 2018

You can use the HTTPCaller to read the JSON from the server and return it in an attribute.

You can then use the JSONFlattener or JSONFragmenter on that attribute to convert the JSON document to FME attributes.

If you need a more specific answer, please consider posting some sample JSON here.

That's it. I'm learning so much of you help guys. Thanks!