Import Package Error

  • 115Views
  • Last Post 23 July 2020
Cameron Craig posted this 21 July 2020

I am performing an UPSERT import operation which pulls a CSV fle from S3 and imports it it into the lead table in Marketo. 

It works great except there are a couple of rows which come up as errors saying: "Lead already exists"

The lead certainly does exist already in marketo, but so do the vast majority in the file, that's why we are using UPSERT. Yet only two rows come up with that error.

I have applied a target lookup which refers to the email address to find the ID number, and the email addresses are unique within the lead table.

Those particular leads do have a number of duplicate named leads within marekto however they are not the only ones to have multiple leads with the same name so it's unclear why there would just be those two errors. 

Run ID: 41053632

Order By: Standard | Newest | Votes
Dmitriy Muzurov posted this 22 July 2020

Hello Cameron,

Thank you for submitting a ticket with us.

We raised a ticket with our developers to investigate this and will contact you back once there are any details.

Dmitriy Muzurov posted this 23 July 2020

Dear Cameron,

Please execute these two queries one by one in Skyvia Query and let us know the result:

SELECT Id, "Email Address", "First Name","Last Name", "Country" FROM Leads WHERE "Email Address" = ''

SELECT Id, "Email Address", "First Name","Last Name", "Country" FROM Leads WHERE "Email Address" = ''

Also, please check that there are no duplicate records with the same email but different case (upper/lower) in your file.

We are looking forward to hearing from you.