Edit on GitHubRecords Not Deleted From the
Records Not Deleted From the OPPORTUNITY_LINE_ITEM Tablelink
Updated 12 days ago
Issuelink
The OPPORTUNITY_LINE_ITEM table is not capturing all deletes.
Environmentlink
Connector: Salesforce
Answerlink
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.
Causelink
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.