Import list by ID

[Rasmus_Bidstru1]

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

[Adam_Vavrek1]

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.

[Rasmus_Bidstru1]

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]

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.  

[Phillip_Wild]

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.