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.

No Results Suddenly From the API

LuisGLuisG Expensify Customer Posts: 6 Expensify Newcomer

Hello,

We have had an integration from our ERP system to Expensify to download expenses to post in a journal in the ERP. It has worked without a problem for over a year.

Suddenly, this month I am getting no results back for February 2019. Below is the request to generate the CSV file but it only contains the column headers

Is anyone else experiencing the same problem, or has anyone had to resolve this?

*************************

requestJobDescription:{

"type":"file",

"credentials":{

  "partnerUserID":"UserID",

  "partnerUserSecret":"secret"

},

"onReceive":{

  "immediateResponse":["returnRandomFileName"]

},

"inputSettings":{

  "type":"combinedReportData",

  "filters":{

"startDate":"2019-02-01",

"endDate":"2019-03-19",

"reportState":"APPROVED,REIMBURSED,ARCHIVED",

"markedAsExported":"Exported to NAV"

  }

},

"outputSettings":{

  "fileExtension":"csv"

}

}

template:

<#if addHeader == true>HeaderRow,Merchant,Amount,Category,TemplateName,BatchName,LineNumber<#lt></#if>

<#assign lineNumber = 10000>

<#list reports as report>

<#list report.transactionList as expense>DataRow,<#t>${expense.merchant},<#t>${expense.amount},<#t>${expense.category},<#t>GENERAL,<#t>DEFAULT,<#t>${lineNumber}<#lt>

<#assign lineNumber = lineNumber + 10000>

</#list>

</#list>

Answers

Sign In or Register to comment.