Downloading Excel File in Appian using Web API.

Hi All,

I have a requirement to download the data into excel using web api in Appian. Data is coming from external API.

Using web api, I am able to dowload .csv and.xls file. But To download the .xlsx file. Is there any way.

Currently I am writing the sample code like below.

a!localVariables(
local!data:{
{name:"A",age:10},
{name:"A",age:10}

},

a!httpResponse(

headers: {
a!httpHeader(
name: "Content-Type",
value: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
),
a!httpHeader(
name: "Content-Disposition",
value: "attachment; filename= test.xlsx"
)
},

body:local!data
)

)

whenever i tried to open the file. Below is the error. Can you please tell how can we resolve this issue?

. 

Thanks in Advance!!