Why Do Some Records Sync Later Than Expected?

Question

Why do some Salesforce records sync later than expected?

Environment

Connector: Salesforce

Answer

We have observed that sometimes, there's a delay between when a record is added or updated in Salesforce and when that record is made available through the Salesforce API. As a result, if you update a record shortly before a sync begins, we may not sync it to the destination until the next sync.

We have a five-minute buffer in incremental syncs to ensure we sync these records. Instead of requesting records from the exact moment the previous sync ended, we request all records from the end of the previous sync range minus 5 minutes.

See the following example scenario:

1. You update a record in Salesforce at 12:58 p.m., but it is available through Salesforce's API at 1:02 p.m.
2. We start a sync at 1:00 p.m. and request all data added or updated between 11:55 a.m. and 1:00 p.m. Our sync does not return your updated record despite you updating it before the sync began.
3. We start a sync at 2:00 p.m. and request all data added or updated between 12:55 p.m. and 2:00 p.m. Due to the five-minute buffer, the sync returns your updated record from 12:58 p.m.