No Results Suddenly From the API

LuisG

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>

Karisa Latta

Hey @LuisG !

I'm sorry for the trouble here.

I've submitted your case to the engineers and will update you as soon as possible! It looks like MKeyes is also using the Export to NAV option like you're trying here. Can you tell me if they are also getting no results for February 2019?

Looking forward to solving this!

LuisG

Yes, no results for February 2019. I had to do it manually.

Karisa Latta

Thanks for confirming. I've shared as many details as I can with the team and hope to hear back soon!

Julia

We may be experiencing a similar issue... except we aren't even getting a file with headers.

Karisa Latta

Hey @Julia !

Can you please share your API export template with me like Luis did? I'll be happy to have the team investigate your issue as well. Please be sure to redact any sensitive information in the template (like your partner ID and secret) before sharing!

I look forward to your reply.

Julia

@Karisa Caudill nevermind, we got it all sorted out. Looks like the IP address changed that our API was coming from, and our firewall blocked it.

Karisa Latta

@Julia whew!

Thank you for letting me know. Please don't hesitate to write back if you need any other help.

LuisG

@Karisa Caudill Would I have any issues this month when I try to do the upload?

LuisG

@Karisa Caudill Still the same issue for March? can you please assist?

Nicole Trepanier

Hi @LuisG I've let the team know that this issue is still occurring so I should have an update soon. Can you confirm that there haven't been any changes to your IP address similar to the resolved issue above?

LuisG

@Nicole Trepanier I'm not really an IT person to know about that. Is there any way that you can guide me on what to try?

Karisa Latta

Hey @LuisG !

I'm not sure how to guide you to figure out the IP issue. However, the team is still trying to investigate your case. They can't find any API logs associated with your account connected to your Community profile though.

Would you mind letting us know what email address is associated with your API partner login? If you're not comfortable sharing that on a public forum like our Community, please email [email protected] with that info and mention this Community post # 3883. Please only share the partner email address and not any secret keys or passwords.

Thanks so much for your patience here!

LuisG

Hi @Karisa Caudill ,

So I wasn't here when the implementation happened but you can try [email protected] or [email protected]. The first one is our CFO and the second one is our person that we usually go with IT questions.

Nicole Trepanier

@LuisG Thanks! I'll have them try these and get back to you.

MarkusH

@Karisa Caudill we are experiencing the same issue. CSV is created but empty, just showing the headers. For us it never populated any data as we just started to implement and integration. First assumption would of course be a wrong config but I have taken the examples provided here: https://integrations.expensify.com/Integration-Server/doc

Was a solution found to the issue mentioned above?

Thank you for your help!

Karisa Latta

@LuisG we think we sorted out the issue! Sorry for the delay here. If [email protected] is using the API to make your calls, the issue is that [email protected] is no longer on that policy. If you can't "see" a report in the UI via policy rights, then you can't export it via the API either.

@MarkusH can you ensure that the person making the API call is a Policy Admin?

MarkusH

@Karisa Caudill I was trying to make the API calls with another user which should be admin. Still no data was returned.

Karisa Latta

@MarkusH thanks for confirming! Would you mind sharing the email address of the API user? If you're not comfortable sharing that information here, please send a message to [email protected] asking for me and referring to this Community post.

I'll check the logs and setting to see what's going on for you. If you can also share your API call template, that'd be a huge help. Be sure to redact your partner ID, partner secret, and any other sensitive info from the call.