Can't Retrieve SFDC ID with Bulk Lead Extract

[Ben_Neal]

I'm attempting to copy/replicate Lead and Contact data from Marketo to a MySQL Database via API. I'm able to to successfully retrieve the data using the Bulk Lead Extract API (http://developers.marketo.com/rest-api/bulk-extract/bulk-lead-extract/#filters) with the exception of when I retrieve the Salesforce record Id field (sfdcId) from the API the values that get returned are "null" despite the value existing in Marketo.

Am I doing something wrong here or is the Marketo API limited in this regard?

If this is a limitation in Marketo, isn't this a huge limitation? SFDC Id is the primary key for the authoritative source for Lead records and I'm unable to retrieve these values via API?

Thanks,

Ben Neal

[Steven_Vanderb3 · Accepted solution]

Try sfdcLeadId (which retains original Lead ID for converted Leads) and sfdcContactId to get that information.  sfdcId is for internal use unknown to me but it's being denoted as having a type lead_function instead of string, which is probably why it doesn't return data over Bulk API.

[Casey_Grimes]

This is a complete shot in the dark, but would it be possible to get more details on how sfdcId (and its corresponding lead_function data type) is used? I'm less interested in the overall Lead/Contact/Account ID as much as trying to understand what mechanisms let Marketo know to not deduplicate SFDC records--I'm guessing that's simply the presence of a sfdcLeadId/sfdcContactId but didn't know if sfdcId had any factor. Otherwise, I'm just assuming it's what figures out the data to pull when viewing a list with SFDC ID chosen as a column.