Expensify.org/hunger SNAP campaign status
We’re no longer accepting new participants as our focus is on reimbursing existing claims. While we’re unable to provide a specific timeline on when your report will be reimbursed, we’re doing our best to drive donations and keep reimbursements moving forward. If you know anyone who can donate to this campaign please encourage them to enable Personal or Corporate Karma on their Expensify account.

We're currently experiencing issues with our American Express and Capital One connections. Please visit our status page for more details and to subscribe to updates.

API Request no longer working

SynergyResourcesSynergyResources 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

Sign In or Register to comment.