Salesforce Decode
Salesforcedecode
Back to questions
IntegrationIntermediatesoft-deletearchivesync

Handle soft delete and archive sync to external systems

Real World Scenario

Deleted Salesforce Accounts still active in external MDM causing duplicate re-create on next sync.

Expected Answer

• Sync IsDeleted flag or use Deleted Record queries Bulk API • MDM tombstone pattern marking inactive not hard delete • Undelete scenario handling recycle bin recovery • Retention policy hard purge after 90 days propagated • Integration skip recreate if tombstone exists same external key • Audit delete propagation latency SLA • Legal hold prevents delete sync override

Follow-Up Questions & Answers

Click to expand — each follow-up includes a direct, interview-ready answer

Direct answer: Sync IsDeleted flag or use Deleted Record queries Bulk API Also consider: MDM tombstone pattern marking inactive not hard delete In practice: Undelete scenario handling recycle bin recovery Balance speed of delivery with maintainability.

Architect Perspective

Delete is half of CRUD—integrations ignoring deletes recreate zombie records forever.