How to download HTTP Request Body (API) as an Excel file in Integration Suite

[eunicetoh]

Hi Everyone,

I am building an integration flow which calls an Ariba API. In Postman, the API response is as shown in 2nd screenshot below. We then download the response as an .xlsx file, and it will be in a readable Excel file format.

In the Integration Flow, I am writing the API response to a data store, which returns the same thing as what we get on Postman. However, I need to download the response as an Excel file. How do I do that? Can that be configured directly in the HTTP connector step?

[csaba_szep]

Hi, 

The language used during processing in CPI is xml, else you have few options, .xlsx will not be working. 

However, there are other similar questions already like below https://community.sap.com/t5/technology-q-a/reading-an-excel-file-into-sap-cpi/qaq-p/12546084

But what you described in this way will not be possible, i think. 

Br,
Csaba