API Request no longer working

SynergyResources
SynergyResources Expensify Customer Posts: 3

Hello,

I sent an email to concierge but was referred to here and hoping someone can help. I've written an integration years ago and have not change anything except including the email address in my output. This was a change done some time last year. In the last 2 days, myself and other customers that I've given my program too are unable to retrieve expense reports (continuously getting a Bad Request(400) error.


My request is as follows:

https://integrations.expensify.com/Integration-Server/ExpensifyIntegrations?requestJobDescription=%7B%20%22test%22:%22true%22,%20%22type%22:%22file%22,%20%22credentials%22:%20%7B%20%22partnerUserID%22:%22aa_expenses_synergyresources_net%22,%22partnerUserSecret%22:%22REMOVED_FOR_SECURITY%22%7D,%20%22onReceive%22:%7B%20%22immediateResponse%22:%20[%22returnRandomFileName%22]%20%7D,%20%22inputSettings%22:%7B%20%22type%22:%22combinedReportData%22,%20%22reportState%22:%22APPROVED%22,%20%22filters%22:%7B%20%22policyIDList%22:%22A60D109AFADC1E1E,A7C8CECC7792F607%22,%22startDate%22:%222020-03-25%22,%22endDate%22:%222020-03-25%22,%22markedAsExported%22:%22SAP%22%20%7D%20%7D,%20%22outputSettings%22:%7B%20%22fileExtension%22:%22xls%22%20%7D,%20%22onFinish%22:%20[%20%7B%22actionName%22:%22markAsExported%22,%22label%22:%22SAP%22%7D%20]%20%7D%20&template=%3C%23--%20Header%20--%3E%0D%0ASubmitted%20Date,Expense%20Date,%20Report%20ID,ReportName,UserID,Merchant,Reimbursable,%20Billable,Category,GLCode,Comments,Tag,Amount,Email%20Address%0D%0A%3C%23list%20reports%20as%20report%3E%0D%0A%3C%23list%20report.transactionList%20as%20expense%3E%0D%0A%3C%23--Compute%20the%20final%20amount,%20merchant,%20and%20created%20date%20and%20store%20them%20in%20variable%20--%3E%0D%0A%3C%23if%20expense.convertedAmount?has_content%3E%0D%0A%20%20%20%20%20%20%3C%23assign%20amount%20=%20(expense.convertedAmount/100)%3E%0D%0A%3C%23elseif%20expense.modifiedAmount?has_content%3E%0D%0A%20%20%20%20%20%20%3C%23assign%20amount%20=%20(expense.modifiedAmount/100)%3E%0D%0A%3C%23else%3E%0D%0A%20%20%20%20%20%20%3C%23assign%20amount%20=%20(expense.amount/100)%3E%0D%0A%3C/%23if%3E%0D%0A%3C%23if%20expense.modifiedMerchant?has_content%3E%0D%0A%20%20%20%20%20%20%3C%23assign%20merchant%20=%20expense.modifiedMerchant%3E%0D%0A%3C%23else%3E%0D%0A%20%20%20%20%20%20%3C%23assign%20merchant%20=%20expense.merchant%3E%0D%0A%3C/%23if%3E%0D%0A%3C%23if%20expense.modifiedCreated?has_content%3E%0D%0A%20%20%20%20%20%20%3C%23assign%20created%20=%20expense.modifiedCreated%3E%0D%0A%3C%23else%3E%0D%0A%20%20%20%20%20%20%3C%23assign%20created%20=%20expense.created%3E%0D%0A%3C/%23if%3E%0D%0A$%7Breport.submitted%7D,%3C%23t%3E%0D%0A$%7Bcreated%7D,%3C%23t%3E%0D%0A$%7Breport.reportID%7D,%3C%23t%3E%0D%0A$%7Breport.reportName%7D,%3C%23t%3E%0D%0A$%7Breport.submitterUserID%7D,%3C%23t%3E%0D%0A$%7Bmerchant%7D,%3C%23t%3E%0D%0A$%7Bexpense.reimbursable?string('true','false')%7D,%3C%23t%3E%0D%0A$%7Bexpense.billable?string('true','false')%7D,%3C%23t%3E%0D%0A$%7Bexpense.category%7D,%3C%23t%3E%0D%0A$%7Bexpense.categoryGlCode%7D,%3C%23t%3E%0D%0A$%7Bexpense.comment%7D,%3C%23t%3E%0D%0A$%7Bexpense.tag%7D,%3C%23t%3E%0D%0A$%7Bamount%7D,%3C%23t%3E%0D%0A$%7Breport.accountEmail%7D%3C%23lt%3E%0D%0A%3C/%23list%3E%0D%0A%3C/%23list%3E%0D%0A


jobDescription:

{ "test":"true", "type":"file", "credentials": { "partnerUserID":"aa_expenses_synergyresources_net","partnerUserSecret":"REMOVED_FOR_SECURITY"}, "onReceive":{ "immediateResponse": ["returnRandomFileName"] }, "inputSettings":{ "type":"combinedReportData", "reportState":"APPROVED", "filters":{ "policyIDList":"A60D109AFADC1E1E,A7C8CECC7792F607","startDate":"2020-03-25","endDate":"2020-03-25","markedAsExported":"SAP" } }, "outputSettings":{ "fileExtension":"xls" }, "onFinish": [ {"actionName":"markAsExported","label":"SAP"} ] }

<#-- Header -->

Submitted Date,Expense Date, Report ID,ReportName,UserID,Merchant,Reimbursable, Billable,Category,GLCode,Comments,Tag,Amount,Email Address

<#list reports as report>

<#list report.transactionList as expense>

<#--Compute the final amount, merchant, and created date and store them in variable -->

<#if expense.convertedAmount?has_content>

<#assign amount = (expense.convertedAmount/100)>

<#elseif expense.modifiedAmount?has_content>

<#assign amount = (expense.modifiedAmount/100)>

<#else>

<#assign amount = (expense.amount/100)>

</#if>

<#if expense.modifiedMerchant?has_content>

<#assign merchant = expense.modifiedMerchant>

<#else>

<#assign merchant = expense.merchant>

</#if>

<#if expense.modifiedCreated?has_content>

<#assign created = expense.modifiedCreated>

<#else>

<#assign created = expense.created>

</#if>

${report.submitted},<#t>

${created},<#t>

${report.reportID},<#t>

${report.reportName},<#t>

${report.submitterUserID},<#t>

${merchant},<#t>

${expense.reimbursable?string('true','false')},<#t>

${expense.billable?string('true','false')},<#t>

${expense.category},<#t>

${expense.categoryGlCode},<#t>

${expense.comment},<#t>

${expense.tag},<#t>

${amount},<#t>

${report.accountEmail}<#lt>

</#list>

</#list>


Any help would be greatly appreciated as all of my customers (as well as us as a company) are no longer able to use the software.

Answers