Bulk lead import with lookupField

[Axel_Lechat]

Hello,

I have some issue with bulk lead import when i add one lookupfiel.

I try with "id" or "sfdcContactId", it's work when i don't use lookupfiel but i need to synchro with id or saleforce contact id, i can't use the default "email"

sample of my query ( bulk/v1/leads.json?format=csv&lookupField=id )

answer {"requestId":"123fe#1689fcebe43","success":false,"errors":[{"code":"1006","message":"Header field 'id' not found"}]}

if someone have an idea any help will be helpfull

Regards

[SanfordWhiteman]

You need to provide a full example payload. You're just showing the URL. The MIME payload is the offender here: the error says your CSV doesn't contain an id column.

[Axel_Lechat]

Hi,

Thx for you answer, this is an short example of my payload but i put an id column in my csv. i try with and without "quote" arround id

------WebKitFormBoundaryXjWP6BP8Ciq6bPeo

Content-Disposition: form-data; name="file"; filename="Person_1.csv"

Content-Type: application/vnd.ms-excel

"id","User_existant","Date_derniere_connexion","Civilite_RC"

"1037051","0",,"M."

------WebKitFormBoundaryXjWP6BP8Ciq6bPeo--

Regards

[Axel_Lechat]

Sanford Whiteman​ Hello, do you have any idea ? i still don't know what to do ?

Regards

[SanfordWhiteman]

You're passing the wrong Content-Type (this must be text/csv) and your MIME line breaks are wrong.

Please search my past Nation posts for "mime" and you will see examples of the correct format (also an international standard format, of course!).