Can't Retrieve SFDC ID with Bulk Lead Extract | Community
Skip to main content
Ben_Neal
Ben_Neal
New Participant
June 26, 2018
Solved

Can't Retrieve SFDC ID with Bulk Lead Extract

  • June 26, 2018
  • 1 reply
  • 3409 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Steven_Vanderb3

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.

1 reply

Steven_Vanderb3
Steven_Vanderb3Accepted solution
New Participant
June 26, 2018

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_Grimes2
    Casey_Grimes2
    New Participant
    April 26, 2019

    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.

      Terms & ConditionsAccessibility statement

      Loading footer...