Why Are Deletes Missing From the Salesforce OPPORTUNITY_LINE_ITEM Table?

You may notice that some deleted records are not captured in the Salesforce OPPORTUNITY_LINE_ITEM table. This is due to how Salesforce handles deletes for the OpportunityLineItem object.

Fivetran uses the getDeleted() call to capture deletes. However, this call is not reliable for the OPPORTUNITY_LINE_ITEM table.

In most cases, Salesforce records are stored in the recycling bin for 15 days. However, OpportunityLineItem records are directly deleted and aren't sent to the recycling bin. For more information, see Salesforce's OpportunityLineItem documentation.

Due to this limitation, deleted records may be purged before we can detect and sync the deletion.

How Fivetran captures missing deletes

To address this limitation, we re-import the OPPORTUNITY_LINE_ITEM table to capture deletes. The re-import frequency depends on the time it takes for a table to re-sync.

We continue to sync updates at your configured sync frequency. The re-import frequency only impacts how often we capture the missed deletes.

For more information, see the Re-import tables section of the Salesforce documentation.