Skip to main content
Solved

Access JSON URL in attribute


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

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.

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

2 replies

david_r
Evangelist
  • 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
  • March 15, 2018
david_r wrote:

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!

 


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