Skip to main content
R
Rasmus_Bidstru1
Level 4
January 8, 2015
Question

Import list by ID

  • January 8, 2015
  • 4 replies
  • 3518 views
Is it possible to export a list (with the system ID), change eg. email adresse or other field, and import the file again matching the record by system ID, and just updating the new values?

regards
Rasmus
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

4 replies

Adam_Vavrek1
Adam_Vavrek1
Level 8
January 8, 2015
Hi Rasmus,

Marketo de-dupes based on the email address. If you do what you described above and change the email address in your exported file and re-import to Marketo, a new lead will be created and will not update the existing lead's email address. If a lead with the same email address exists upon re-import, Marketo will update that lead. You can update other fields using the email address (as opposed to the ID) but you'll need to edit the email another way.
R
Rasmus_Bidstru1Author
Level 4
January 8, 2015
Ok :)

One of our issues is that we have multiple leads with the same email address, so if we update the using by looking at the email, it will find 2-3 leads with the same email. thats why i wanted to use the Marketo ID to find the correct people.
Jep_Castelein2
Jep_Castelein2
Level 10
January 8, 2015
You'll have to use the API to update by ID. It's not that hard, but you'll need the help of a software developer. You can export a list including the Marketo ID, but you'll need the API to save back the updates. 

In the REST API, you can use the Marketo ID to update records:  http://developers.marketo.com/documentation/rest/createupdate-leads/.  Potentially you can also use the "Import Lead" functionality and specify the Marketo ID as the lookup field: http://developers.marketo.com/documentation/rest/import-lead/ (please test this, as I haven't done this myself yet). 

In the SOAP API, you can do the same: http://developers.marketo.com/documentation/soap/syncmultipleleads/ , however you cannot use the importToList function, because that only uses the email address for matching.  
    P
    PhillipWi1
    Level 9
    September 1, 2015

    Rasmus we have the same problem. We use SFID as the unique identifier, but Marketo dedupes list imports on email address. This makes no sense and makes it really difficult to update leads.

    Terms & ConditionsAccessibility statement

    Loading footer...