How Does Fivetran Capture Deletes From Salesforce?
In Salesforce, there are two types of deletes:
- Soft deletes
- Hard deletes
For more information, see Salesforce's Data Deletes and Extracts documentation.
Once you soft-delete a record in Salesforce, it is moved to the Recycle Bin. Fivetran captures soft-deleted records from the Salesforce API using the SObject Get Deleted
endpoint.
After 15 days, the record is hard-deleted and can no longer be accessed using the Salesforce API. As a result, we can't capture hard-deleted records.