In this Article
You can use the Bulk Lead Upsert Snap to upsert a large number of leads into the Lead database.
A valid account with the required permissions. For more info, see Roles and Permissions.
Works in Ultra Pipelines.
API Limits:
Marketo supports a variety of objects for extraction, such as Bulk Custom Object Import, Bulk Lead Import, and Bulk Program Member Import; however, this Snap supports only Lead upsert objects. See Bulk Lead Import API for more information.
This Snap accepts values for the Timeout (seconds), Number of Retries, and Retry Interval (seconds) fields from Pipeline parameters only. These fields do not support values from upstream Snaps when you enable the expression icon.
Bulk Lead Upsert Snap fails with error 1006 for SSV file format as input.
Marketo Snaps do not support some special characters (for example, (𝖖𝖗𝖘𝖬𝖭𝖮𝗕𝗖𝘧𝘨𝘩𝛀𝛁𝛂𝛃𝛄𝛅𝛆𝛇,𝖗𝖘𝖬𝛌𝛗𝛘𝛙𝛴).
Input/Output | Type of View | Number of Views | Examples of Upstream and Downstream Snaps | Description |
|---|---|---|---|---|
Input | Binary |
|
| Requires the Upsert format and additional detail, if required, to insert or update a large number of records into the Lead database. |
Output | Document |
|
| Insertion of large leads into the Lead database. |
|
Field Name | Field Type | Description |
|---|---|---|
Label* | String | Specify a name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your Pipeline. Default Value: Bulk Lead Upsert |
Timeout (seconds) | Integer/Expression | Specify the timeout for the operation in seconds. Default Value: 0 |
Number Of Retries | Integer/Expression | Specify the number of attempts the Snap must make in case of connection failure or timeout. Minimum value: 0 Default Value: 0 |
Retry Interval (seconds) | Integer/Expression | Specify the minimum number of seconds the Snap must wait before each retry attempt. Minimum value: 1 Default Value: 1 |
Upsert format* | Dropdown list | Choose the file format of the extracted data. The available options are:
Default Value: CSV |
Lookup Field | String/Emai/Integer/Expression | Enter the field to refine and narrow down your search. Use this field to find existing leads if you are performing an update operation. You can use 'Id' only for update only operations. You can use 'Id' only for update only operations. Default Value: email |
List ID | Integer/Expression | Enter the ID of the static list to which you want to import lead data. Default Value: N/A |
Partition | String/Expression | Enter the name of the lead partition where you want to import the data. Default Value: N/A |
Snap Execution | Dropdown list | Select one of the three following modes in which the Snap executes:
Default Value: Execute Only |
None.
This example Pipeline demonstrates how we can insert lead data in bulk into the Lead database using the Bulk Lead Upsert Snap. We build the Pipeline to automate the following activities:
Read the binary data using the File Reader Snap.
Insert data in bulk using the Bulk Lead Upsert Snap.
First, we configure the File Reader Snap to read binary data. The username.csv has been uploaded. Upon validation, we see the output with uploaded file details.
File Reader Input | File Reader Output |
|---|---|
 |  |
Next, we configure the Bulk Lead Upsert Snap as follows. Upon validation, we see an output confirming the insertion of data into the Lead database.
Bulk Lead Upsert Input | Bulk Lead Upsert Output |
|---|---|
 |  |
Important Steps to Successfully Reuse Pipelines
|
): Indicates a list that is dynamically populated based on the configuration.