SOLVED

Insert Only for Bulk Lead Import API

Go to solution
Joon_Park
Level 2

Insert Only for Bulk Lead Import API

I see in the documentation that Bulk Lead Import is a "createOrUpdate" record operation.

Is there any way to do a "createOnly" operation? We are using a document scraper to bulk import leads and the resume scraper has a ~80% success rate and certain important values (such as phone number) sometimes does not get scraped and is blanking out values.

I know I can block field updates, but we also do not want to update any fields from this process and we cannot block field updates from all of the fields we are scraping.

1 ACCEPTED SOLUTION

Accepted Solutions
SanfordWhiteman
Level 10 - Community Moderator

Re: Insert Only for Bulk Lead Import API

Import using proxy fields, not the real fields. Continue to dedupe on the standard Email Address.

Trigger on Person is Created, constrained by

  Source Type = Web service API - Import to list

  List = {your relevant list name that identifies these batches}

For those that qualify, Change Data Value for each real field → {{lead.corresponding proxy field}}.

View solution in original post

4 REPLIES 4
Erik_Larson
Level 2

Re: Insert Only for Bulk Lead Import API

Yeah one way that comes to mind is to enqueue a separate job. For example you could kick off a "no phone number" job where you grab the records w/o a phone number, drop the phone column, and import these records.

SanfordWhiteman
Level 10 - Community Moderator

Re: Insert Only for Bulk Lead Import API

Import using proxy fields, not the real fields. Continue to dedupe on the standard Email Address.

Trigger on Person is Created, constrained by

  Source Type = Web service API - Import to list

  List = {your relevant list name that identifies these batches}

For those that qualify, Change Data Value for each real field → {{lead.corresponding proxy field}}.

Joon_Park
Level 2

Re: Insert Only for Bulk Lead Import API

Sanford coming in for the save as always, thank you!

Jiten_Savla
Level 1

Re: Insert Only for Bulk Lead Import API

Hello,
I'm trying to send a csv for bulk lead import to Marketo REST API and I get the following response.

{
"requestId": "cf55#17013f75a94",
"success": false,
"errors": [
{
"code": "1006",
"message": "Header field 'CompanyGUID' not found"
},
{
"code": "1006",
"message": "Header field 'CompanyName' not found"
},
{
"code": "1006",
"message": "Header field 'CompanyNameAKA' not found"
}
]
}

 

For reference, this is the CSV I' using,

CompanyGUID,CompanyName,CompanyNameAKA
'GUID123', 'CompanyName', 'AKACompany'

Tags (1)