Skip to main content
Axel_Lechat
Axel_Lechat
Level 2
January 30, 2019
Question

Bulk lead import with lookupField

  • January 30, 2019
  • 2 replies
  • 3004 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

SanfordWhiteman
SanfordWhiteman
Level 10
January 30, 2019

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
Axel_LechatAuthor
Level 2
January 31, 2019

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
Axel_LechatAuthor
Level 2
February 12, 2019

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

Regards

SanfordWhiteman
SanfordWhiteman
Level 10
February 12, 2019

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

Terms & ConditionsAccessibility statement

Loading footer...