Incorrect filter behavior when fetching expenses using API in 2020
Options
Random
Expensify Customer Posts: 10 Expensify Newcomer
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 ?
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
-
I'm experiencing similar issues but for me the API is not returning data from 2019-09-01 until any time in 2020. I do the same thing where I use google sheets to sync to my account
-
Sophie_Pinto Expensify Customer, Expensify Team, Expensify Student Ambassador Posts: 133 Expensify TeamOptions
