Bulk Import Based on Marketo Lead ID | Community
Skip to main content
Andrew_Burch
Andrew_Burch
New Participant
March 16, 2021
Solved

Bulk Import Based on Marketo Lead ID

  • March 16, 2021
  • 1 reply
  • 3656 views

Long time lurker, first time poster... so, please be patient with me. 

I'm working with our developers to beef up our initial Marketo + CRM sync and incorporate Marketo lead ID's. Ideally we would like to use the Bulk Import API with Marketo's Lead ID being the primary key (no longer email) hoping this new method would correct email address changes. We just ran a test and it doesnt seem like the Bulk Import API incorporated the Marketo Lead ID at all. Does the Bulk Import API only use email address? 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman
When you say format the payload correctly, do you mean the actual API call or the format of the CSV file we're sending as part of the bulk import?

Both.

 

...as long as the field names of the CSV match up with what is in Marketo's API names it should work.

That's correct but the lookup key needs to be set in the URL as well.

https://{{Marketo.Munchkin}}.mktorest.com/bulk/v1/leads.json?format=csv&lookupField=id

 

1 reply

SanfordWhiteman
SanfordWhiteman
New Participant
March 16, 2021

Bulk Import absolutely supports Lead ID as the lookup key. Of course you need to format the payload correctly, so you'd need to show what you sent to Marketo.

Andrew_Burch
Andrew_BurchAuthor
New Participant
March 16, 2021

Hey Stanford! Thank you for the reply--and thank you in general for all your replies to the forum! We've never met, but I've learned a lot from you!

 

When you say format the payload correctly, do you mean the actual API call or the format of the CSV file we're sending as part of the bulk import? I'm hearing from my dev that he was told as long as the field names of the CSV match up with what is in Marketo's API names it should work.

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
March 16, 2021
When you say format the payload correctly, do you mean the actual API call or the format of the CSV file we're sending as part of the bulk import?

Both.

 

...as long as the field names of the CSV match up with what is in Marketo's API names it should work.

That's correct but the lookup key needs to be set in the URL as well.

https://{{Marketo.Munchkin}}.mktorest.com/bulk/v1/leads.json?format=csv&lookupField=id

 

Terms & ConditionsAccessibility statement

Loading footer...