Mapping of Leads in Marketo & Salesforce

[Anonymous]

When customers enable the Marketo + Salesforce 2-way sync, Leads in Marketo are synced to Leads in Salesforce (and eventually Opportunity Contacts after conversion in Salesforce). During the sync, Is the 16-digit salesforce id for leads in Salesforce persisted in the Marketo Lead Table against the same lead?

• Can we extract this data (column) through Marketo API’s?
• If not, can we write a trigger to dump lead id in Marketo and lead id from Salesforce into a custom table and extract that join through API
• How has customer extracted this join between Marketo and Salesforce

[Anonymous]

Hi Emmanuel - Take a look at getLead and getMultipleLeads APIs.  You can query Marketo using the SFDCLEADID as the key to retrieve leads from Marketo.

[Sarah_Greig2]

Hi

I'm looking for the 15 digit SFDC id to query in Marketo but can't find the field SFDCLEADID. Any clues to what it's called now?

Sarah

[Anonymous]

Yes, the SFDC ID (it's actually 15 or 18 digits, I believe MKTO uses the 15 digit one) is mapped to a lead in Marketo if it exists in both places. Not sure why you need to join them??