API Report Exporter Returns "No Template Submitted"

Rae

I've copied the following curl request directly from the API documentation and imported it into Postman. The only parameter changes I made were to the partnerUserID, partnerUserSecret, startDate, endDate, and recipients. It returns {"responseMessage":"No Template Submitted","responseCode":410}. Can I not use the default template like I can for the Reconciliation file?

curl -X POST 'https://integrations.expensify.com/Integration-Server/ExpensifyIntegrations' \
-d 'requestJobDescription={
"type":"file",
"credentials":{
"partnerUserID":"userId",
"partnerUserSecret":"userSecret"
},
"onReceive":{
"immediateResponse":["returnRandomFileName"]
},
"inputSettings":{
"type":"combinedReportData",
"reportState":"APPROVED,REIMBURSED",
"limit":"10",
"filters":{
"startDate":"2018-08-01",
"endDate":"2018-08-20",
"markedAsExported":"Expensify Export"
}
},
"outputSettings":{
"fileExtension":"xlsx",
"fileBasename":"myExport"
},
"onFinish":[
{"actionName":"markAsExported","label":"Expensify Export"},
{"actionName":"email","recipients":"[email protected]", "message":"Report is ready."}
]
}'
--data-urlencode 'template@expensify_template.ftl'

Blake

In my experience with this I couldn't get Postman to find expensify_template.ftl. It works fine use a bash script. To get this to work in Postman added a key called 'template' and pasted the contents of the file into the value field.

Rae

Thank you, Blake. That appears to have worked. The API returned an xlsx file name. Although, it's odd that Postman seems to have no issue finding the expensify_template.ftl when calling the Reconciliation job.

How long does it usually take for the expense report file to be emailed to the recipient?

Rae

Never mind, I just received it.

RichD

thank you. had the exact same issue