Skip to main content
Solved

API --> httpcaller --> excel transformation

  • November 22, 2018
  • 2 replies
  • 58 views
Y
Forum|alt.badge.img

Hello:

(apologies if this is a double post. I wrote it and then signed in)

I'm learning FME and APIs and have been trying to use httpcaller to retreive information from an API and convert the information into excel columns. I've figured out the httpcaller portion, but I end up with an excel file with a single column that contains all of the data for each row instead of separating each bit of data into their own columns.

Any ideas on how to take the httpcaller API JSON output and convert it into a usable excel sheet? Current sample output is below.

Thanks!

Best answer by jdh

The response you are getting from the httpcaller is in JSON. You need to use a JSONExtractor or JSONFlattener prior to the excel writer.

 

 

You will also need to expose the attributes (if known/static) or use the schemasetter and dynamic settings on the writer.

 

1 Attachments
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

jdh
Contributor
Forum|alt.badge.img+38
  • jdhContributor
  • Contributor
  • Best Answer
  • November 22, 2018

The response you are getting from the httpcaller is in JSON. You need to use a JSONExtractor or JSONFlattener prior to the excel writer.

 

 

You will also need to expose the attributes (if known/static) or use the schemasetter and dynamic settings on the writer.

 

Y
Forum|alt.badge.img
  • yong_sa
  • Author
  • November 23, 2018

Thanks everyone for pointing me in the right direction. While I couldn't get the extractor or flattener to work, I ended up using a JSONFragmenter and AttributeExposer to get at some of the columns we needed.

The next step is to figure out how to get the nested array values from the APIs.

Community Stats

32,128
Posts
121,966
Replies
39,779
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.