Hello community,
We pulls email_activity records from the /api/3/emailActivities endpoint, and I'm encountering inconsistent results between API calls made on different dates. I wanted to check if anyone else has run into this and found a reliable workaround.
The Problem:
I called the /api/3/emailActivities endpoint (unfiltered) on June 16, and it returned 239 records. The most recent record had a timestamp of June 16.
I called the same endpoint again on June 18 and 20 June, it returned 261 records and 271 records respectively more records than before(June 16). However, many of the new records have timestamps from June 8 and June 10, which are dates that were already in the past when I made my first call on June 16. Most recent record had tstamp of June 16 Only.
This means records from June 8 and June 10 were not returned in my June 16 call, but appeared later in my June 18 and June 20 call.
Is there a recommended approach for building a reliable incremental sync against this endpoint?
Any help, workarounds, or insights would be greatly appreciated.
Thank you!