cancel
Showing results for 
Search instead for 
Did you mean: 

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

murphy-brian
New Contributor III

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?

5 REPLIES 5

SandeepVemula
Contributor

add Excel formatter Snap

murphy-brian
New Contributor III

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

jarkorful
New Contributor

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

murphy-brian
New Contributor III

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