A lead_id in the ACTIVITY_DELETE_LEAD Table Is Missing From the LEAD Table

Issue

A lead_id in the ACTIVITY_DELETE_LEAD table is missing from the LEAD table. If a lead_id is deleted, it should appear in both tables.

Environment

Connector: Marketo

Answer

The connector extracts deleted leads data from the get deleted leads endpoint in Marketo. If you create and delete a lead before Fivetran begins a sync, the lead_id appears in the ACTIVITY_DELETE_LEAD table but not in the LEAD table.