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.

API Filter Timestamp

Peter_LayPeter_Lay Expensify Customer Posts: 30 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 SchusterJohn Schuster Expensify Team Posts: 56 Expensify Team

    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
    


Sign In or Register to comment.