What Happens to Records That Exist Temporarily?

Question

I have a process in Salesforce that temporarily creates records and then deletes them in seconds, minutes, or days. Are these records captured by Fivetran?

Environment

Connector: Salesforce

Answer

For most objects, Salesforce soft-deletes records when you delete them. We reflect the deleted status of these records when we fetch their record IDs from the sObject Get Deleted endpoint. If a Salesforce object doesn't have an applicable deleted endpoint, we infer the deleted status of records by running a full re-sync and determining which record IDs are missing.

In both cases, we can only reflect a record's deleted status if we have already synced it. We won't capture a record if it is created and deleted before we sync it.

For more information, see How Does Fivetran Capture Deletes.