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.

Why are deletes missing from the OPPORTUNITY_LINE_ITEM table?

Fivetran uses the getDeleted() call to capture deletes. 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 to ensure deletes are captured for the OPPORTUNITY_LINE_ITEM table

To resolve this issue, contact our support team to enable re-importing of the OPPORTUNITY_LINE_ITEM table. This allows us to capture deletes regularly.

For more information on our re-import schedules, see our Salesforce re-import tables documentation. Test