API Filter Timestamp

Peter_Lay

Hi Expensify,

I've been building an integration to our SAP system and this is pertaining to the Expense Export https://integrations.expensify.com/Integration-Server/doc/#report-exporter

"filters":{
                "startDate":"2016-01-01",
                "endDate":"2016-02-01",

In this document, it states that we can use startDate and endDate as the filters, we need to identify the delta between timeframes. Is it possible to filter based on timestamp? as opposed to date. Such as, 9/10/2020:10:30:00?

This will enable us to pull in the Expense reports that hasn't already been imported into the system.

Thanks!

Peter. L.

John Schuster

Hey there, Peter! These filters cannot be manually adjusted further to include time stamps.

That said, the start parameter filter automatically assume a timestamp of 00:00:00, while the end parameter filter automatically assumes a timestamp of 23:59:59 so:

startDate: 2020-01-01
endDate: 2020-02-02

would be equivalent to

startDate: 2020-01-01 00:00:00
endDate: 2020-02-02 23:59:59