No Results Suddenly From the API

LuisGLuisG 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.