export SFDC ID from List? | Community
Skip to main content
A
Anonymous
August 22, 2014
Solved

export SFDC ID from List?

  • August 22, 2014
  • 6 replies
  • 1697 views
I have a smart list set up with a custom view that includes a clumn for the SFDC ID of a lead. It seems I'm not able to export that column from MKTO. When I export to CSV, all other columns are there except the SFDC ID. I wanted to see if this was restricted on MKTO's end - or maybe I'm missing something?

Thanks in advnace!
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
It is restricted, but you can get over it by creating a custom field (do it in SFDC so it maps), make it a formula field, set the value = to the ID, and BOOM you now have a field that you can export.

6 replies

A
Anonymous
Accepted solution
August 22, 2014
It is restricted, but you can get over it by creating a custom field (do it in SFDC so it maps), make it a formula field, set the value = to the ID, and BOOM you now have a field that you can export.
    A
    Anonymous
    August 22, 2014
    What is the rational behind not exposing Salesforce IDs? Marketo should expose Salesforce IDs.
    A
    Anonymous
    August 22, 2014
    We're indeed creatinga  custom formula field to sync. I'm confused as well as to why this would be restricted - especially when there's a clear workaround...
    A
    Anonymous
    November 24, 2014
    I agree! Marketo - is there a way this can be un-restcricted and why it currently is if you can export the ID's as per the above.

     
    A
    Anonymous
    January 27, 2015
    Can anyone shed any more light on this one? My colleague who has the same access rights as me for Marketo can export with the SDFC ID but i cant??? The column deosnt export to excel and i would liek to know why.

    Please advise
    A
    Anonymous
    January 27, 2015
    Alison,

    I wasn't able to export the SFDC ID directly and it's my understanding that this is a restricted field (I'm surprised that your colleague is able to export).

    Following Jason Long's advice, we have a custom field set up to duplicate the SFDC ID field, which IS exportable. We call it "CRM Key" and the rule is:

    Value: is ‘{{lead.SFDC Id}}’

    Seems redundant, but it's the workaround we've been able to successfully use.

    I hope this helps.

    Dane
     
    Terms & ConditionsAccessibility statement

    Loading footer...