Skip to main content
Solved

API --> httpcaller --> excel transformation

  • November 22, 2018
  • 2 replies
  • 36 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.

 

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

2 replies

jdh
Contributor
Forum|alt.badge.img+28
  • 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.

Reply


Helpful Members This Week

Community Stats

31,378
Posts
119,011
Replies
39,009
Members

Latest FME

Terms & ConditionsCookie settings

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
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.