4 Replies Latest reply on Feb 12, 2019 8:47 AM by Sanford Whiteman

Bulk lead import with lookupField

Axel Lechat Jan 30, 2019 9:47 AM

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

Re: Bulk lead import with lookupField

Sanford Whiteman Jan 30, 2019 2:36 PM (in response to Axel Lechat)

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.
Like Show 0 Likes(0)

Actions
- Re: Bulk lead import with lookupField
  
  Axel Lechat Jan 31, 2019 2:16 AM (in response to Sanford Whiteman)
  
  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
  
  Like Show 0 Likes(0)
  
  Actions
Re: Bulk lead import with lookupField

Axel Lechat Feb 12, 2019 2:24 AM (in response to Axel Lechat)

Sanford Whiteman Hello, do you have any idea ? i still don't know what to do ?
Regards
Like Show 0 Likes(0)

Actions
- Re: Bulk lead import with lookupField
  
  Sanford Whiteman Feb 12, 2019 8:47 AM (in response to Axel Lechat)
  
  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!).
  
  Like Show 0 Likes(0)
  
  Actions

Go to original post