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?
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.