API Filter Timestamp

Options
Peter_Lay
Peter_Lay Expensify Customer Posts: 38 Expensify Newcomer

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.

Comments

  • John Schuster
    John Schuster Expensify Team Posts: 127 Expensify Team
    Options

    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