Skip to main content
  • EN

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!

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.

 

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


Community Stats

30,351
Posts
115,342
Replies
38,086
Members
Terms & ConditionsCookie 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.