Question
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!!