Bulk lead import with lookupField

Axel_Lechat
Level 1

Bulk lead import with lookupField

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

4 REPLIES 4
SanfordWhiteman
Level 10 - Community Moderator

Re: Bulk lead import with lookupField

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
Level 1

Re: Bulk lead import with lookupField

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
Level 1

Re: Bulk lead import with lookupField

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

Regards

SanfordWhiteman
Level 10 - Community Moderator

Re: Bulk lead import with lookupField

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!).