Import Package Error

  • 16Views
  • Last Post 4 weeks ago
0
votes
Cameron Craig posted this 4 weeks ago

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
0
votes
Dmitriy Muzurov posted this 4 weeks ago

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.

0
votes
Dmitriy Muzurov posted this 4 weeks ago

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" = 'joek288@yahoo.co.jp'

SELECT Id, "Email Address", "First Name","Last Name", "Country" FROM Leads WHERE "Email Address" = 'teamhard68@gmail.com'

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.

Close