Rest API to convert JSON to Excel and return Response to Requester

[murphy-brian]

Would like to take the results of an Ultra Task API request and return results in Excel Document instead of JSON. Anyone done this or have any ideas?

[SandeepVemula]

add Excel formatter Snap

[murphy-brian]

Thanks, but that creates a binary output how do you send it back to the HTTP requester?

[jarkorful]

I might be missing something in translation, but add a formatter and then a parser.

[murphy-brian]

Trying to take the output of a pipeline initiated as an Ultra Task then converts the stream into an Excel document then send it back to the Requester. So think if you have a pipeline that queries the a DB then sends the results back as either a JSON or Excel document as a Restful service. The Excel formatter can only connect to a binary input. Not looking to write to file but output as a stream of binary data with a mime type of “application/vnd.ms-excel.xlt” or something else