IntegrationIntermediaterestqueryalldeleted-records
Implement REST queryAll for archived deleted records in compliance sync
Real World Scenario
Warehouse must reflect Salesforce deletes for GDPR; standard query excludes deleted records causing resurrected customers in analytics.
Expected Answer
• queryAll endpoint includes IsDeleted true records
• getDeleted SOAP equivalent REST Bulk queryDeleted job
• Sync tombstone flag warehouse dim_customer is_active false
• Retention align Salesforce recycle bin 15 days warehouse policy
• Hard delete permanent purge separate event stream
• Reconcile delete count Salesforce vs warehouse weekly
• Legal hold prevents delete sync override flag
Follow-Up Questions & Answers
Click to expand — each follow-up includes a direct, interview-ready answer
Main difference: use case and scale. queryAll endpoint includes IsDeleted true records. getDeleted SOAP equivalent REST Bulk queryDeleted job. Pick based on your integration pattern and team capability. Analytics sync ignoring deletes corrupts customer counts—queryAll or getDeleted mandatory. Balance speed of delivery with maintainability.
Architect Perspective
Analytics sync ignoring deletes corrupts customer counts—queryAll or getDeleted mandatory.