Issue

The OpportunityLineItem table is not capturing all deletes.

Environment

Connector: Salesforce

Answer

Please out to Support to enable reimporting the OpportunityLineItem table. Fivetran will reimport the table on a regular basis to capture all deletes.

Cause

Fivetran uses the getDeleted() call to capture deletes. This call is not reliable for the OpportunityLineItem table. While most Salesforce tables store deleted records for 15 days, OpportunityLineItem records are directly deleted. They are not sent to the recycle bin and cannot be undeleted.

Due to the above limitation, deleted records are sometimes purged from the OpportunityLineItem table before they are captured.