Records Not Deleted From the OPPORTUNITY_LINE_ITEM
Table
Issue
The OPPORTUNITY_LINE_ITEM
table is not capturing all deletes.
Environment
Connector: Salesforce
Answer
Contact our support to enable re-importing the OPPORTUNITY_LINE_ITEM
table. Fivetran will re-import this 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 OPPORTUNITY_LINE_ITEM
table. While most Salesforce tables store the deleted records for 15 days, OpportunityLineItem records are directly deleted. They are not sent to the recycle bin and cannot be recovered. Due to this limitation, the deleted records are sometimes purged from the OPPORTUNITY_LINE_ITEM
table before we capture them.