Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In this Article

...

  • Bulk Lead Upsert Snap fails with error 1006 for SSV file format as input.

  • Marketo Snaps do not support some special characters (for example, (𝖖𝖗𝖘𝖬𝖭𝖮𝗕𝗖𝘧𝘨𝘩𝛀𝛁𝛂𝛃𝛄𝛅𝛆𝛇,𝖗𝖘𝖬𝛌𝛗𝛘𝛙𝛴).

...

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 ValueBulk Lead Upsert
ExampleBulk Lead Upsert

Timeout (seconds)

Integer/Expression

Specify the timeout for the operation in seconds.

Default Value0
Example3

Number Of Retries

Integer/Expression

Specify the number of attempts the Snap must make in case of connection failure or timeout.

Minimum value0

Default Value0
Example3

Retry Interval (seconds)

Integer/Expression

Specify the minimum number of seconds the Snap must wait before each retry attempt.

Minimum value1

Default Value1
Example3

Upsert format*

Dropdown list

Choose the file format of the extracted data. The available options are:

  • csv

  • tsv

Default ValueCSV
Exampletsv

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.

Default Valueemail 
Examplecookies

List ID

Integer/Expression

Enter the ID of the static list to which you want to import lead data.

Default ValueN/A
Example150

Partition

String/Expression

Enter the name of the lead partition where you want to import the data.

Default ValueN/A
ExampleDefault

Snap Execution

Dropdown list

Select one of the three following modes in which the Snap executes:

  • Validate & Execute. Performs limited execution of the Snap and generates a data preview during Pipeline validation, then performs full execution of the Snap (unlimited records) during Pipeline runtime.

  • Execute only. Performs full execution of the Snap during Pipeline execution without generating preview data.

  • Disabled. Disables the Snap and all Snaps downstream from it.

Default ValueExecute Only
ExampleValidate and Execute

...

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:

  1. Read the binary data using the File Reader Snap.

  2. 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

...

Bulk Lead Upsert Input

Bulk Lead Upsert Output

Image RemovedImage Added

Download this Pipeline. 

...