Deluge: changing type of file from .xslx to .xslm
Hello,
I am creating an excel merge by sending Zoho CRM data to Formstack Documents (formerly Webmerge) through API.
The document created is .xslx, as Webmerge does not allow to generate .xlsm templates.
I was wodnering if it would be possible to cnover the file from .xslx to .xlsm through deluge? My code looks like this:
resp = invokeurl
[
url :"https://www.webmerge.me/merge/xxx/u6hizn?test=1&download=1"
type :POST
parameters:mp.toString()
headers:{"Content-Type":"application/json"}
];
info resp;
resp.setFileType("xlsm");
//Then I upload it to Workdrive:
workdrive_id2 = deal.get("zohoworkdriveforcrm__Workdrive_Folder_ID");
resp2 = zoho.workdrive.uploadFile(resp,workdrive_id2,"Calculateur multilogement.xlsm",TRUE,"workdrive_connector");
The document is correctly creatd in Workdrive, but when I download it and try to open it, I get the following error:
Excel cannot open the file "xxxx" because the format or file extension is not valid.
This error did not happen when I set the name to .xslx and did not use the line "resp.setFileType("xslm")".
This error did not happen when I set the name to .xslx and did not use the line "resp.setFileType("xslm")".
Thank you!