Insert Only for Bulk Lead Import API

[Joon_Park]

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.

[Erik_Larson]

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 · Accepted solution]

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]

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

[Jiten_Savla]

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'