Expensify.org is accepting proposals for new campaigns. Submit yours here by April 30th to receive up to $100,000 in funding for campaigns dismantling injustice related to: Climate, Homes, Hunger, Reentry, or Youth.

Incorrect filter behavior when fetching expenses using API in 2020

RandomRandom Expensify Customer Posts: 8 Expensify Newcomer
edited January 2020 in Integrations and API
I have a script running which syncs expenses from expensify to google sheets.
That script gets expenses from 'current' year by using filter similar to 
{"startDate":"2019-01-01","endDate":"2019-12-31"}

That worked correctly until Dec 31st, 2019. In 2020, the filter changed to 
{"startDate":"2020-01-01","endDate":"2020-12-31"}
but it returned empty results even though there are expenses for 2020.

When i change filter to include both years 
{"startDate":"2019-01-01","endDate":"2020-12-31"}
then it returns result for both years. Not sure if I am doing anything wrong. Any ideas ?

Answers

Sign In or Register to comment.