Bulk Import

In this article

Overview

You can use the Marketo Bulk Import Snap to perform bulk imports for the selected entity.

Snap Type

The Marketo Bulk Import Snap is a Write-type Snap.

Prerequisites

A valid account with the required permissions.

Support for Ultra Pipelines  

Does not work in Ultra Pipelines

Limitations

None.

Known Issues

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

Snap Views

Type

Format

Number of Views

Examples of Upstream and Downstream Snaps

Description

Type

Format

Number of Views

Examples of Upstream and Downstream Snaps

Description

Input 

Document

  • Min: 0

  • Max: 1

  • Mapper

  • Copy

Marketo Entity and API Name.

Output

Document

 

  • Min: 0

  • Max: 1

  • Sort

  • Mapper

Document details of the specified Marketo Entity and API.

Error

Error handling is a generic way to handle errors without losing data or failing the Snap execution. You can handle the errors that the Snap might encounter when running the Pipeline by choosing one of the following options from the When errors occur list under the Views tab:

  • Stop Pipeline Execution: Stops the current Pipeline execution if the Snap encounters an error.

  • Discard Error Data and Continue: Ignores the error, discards that record, and continues with the remaining records.

  • Route Error Data to Error View: Routes the error data to an error view without stopping the Snap execution.

Learn more about Error handling in Pipelines.

Snap Settings

  • Asterisk ( * ): Indicates a mandatory field.

  • Suggestion icon (): Indicates a list that is dynamically populated based on the configuration.

  • Expression icon ( ): Indicates the value is an expression (if enabled) or a static value (if disabled). Learn more about Using Expressions in SnapLogic.

  • Add icon ( ): Indicates that you can add fields in the field set.

  • Remove icon ( ): Indicates that you can remove fields from the field set.

  • Upload icon ( ): Indicates that you can upload files.

Field Name

Field Type

Field Dependency

Description

Field Name

Field Type

Field Dependency

Description

Label*

 

Default ValueMarketo Bulk Import
ExampleMarketo Bulk Import

String

N/A

Specify a unique name for the Snap.

 

Marketo Entity*

 

Default Value: Leads
Example: Custom Objects

String/Expression

N/A

Select one of the following entities for which you need to perform the bulk import:

  • Leads - Marketo provides interfaces for insertion of large sets of persons data.

  • Program Members - Imports program members' data.

  • Custom Objects - Imports custom object related data.

API Name*

Default Value: N/A
Example: clothing_c

String/Expression

Appears when you select Custom Objects for Marketo Entity.

Specify the Custom Object API name for which you must import data.

List ID


Default Value: N/A
Example: 2

String/Expression

Appears when you select Leads for Marketo Entity.

Specify the ID of the static list into which you must import the leads data.

Lookup Field


Default Value: N/A
Example: 2

String/Expression

Appears when you select Leads for Marketo Entity

Specify the field to use for deduplication, such as string, email, integer. The supported field types are: ID, cookies, email, twitterID.

You can use ID for update only operations.

Partition Name


Default Value: None
Example: Partition1

String/Expression

Appears when you select Leads for Marketo Entity

Specify the name of the lead partition into which you must import.

Program ID*

Default Value: None
Example: 2771

String/Expression

Appears when you select Program Members for Marketo Entity

Specify the ID of the program for which you must import the program members.

Program Member Status*

Default Value: None
Example: No Show

String/Expression

Appears when you select Program Members for Marketo Entity

Specify a program member status to import program members.

Timeout (seconds)


Default Value0
Example: 1000

Integer/Expression

None

Specify the time in seconds to wait for the bulk operation to complete before it times out. A value of zero disables the timeout.

Number of Retries


Default Value0
Example: 3

Integer/Expression

None

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

Retry Interval (seconds)


Default Value1
Example: 4

Integer/Expression

None

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

Snap Execution

Default ValueExecute only
Example: Validate & Execute

Dropdown list

None

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

  • Validate & Execute: Performs limited execution of the Snap, and generates a data preview during Pipeline validation. Subsequently, 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 that are downstream from it.

Example

Importing Custom Objects Data In Bulk

This Pipeline demonstrates how to import data for the Custom Objects entity in bulk.

First, configure the CSV Generator Snap and click Edit CSV to pass the data.

Next, configure the custom fields partNumber and testField in the Mapper Snap for importing the data for the specified custom object.

 

Configure the Marketo Bulk Import Snap with the Custom Objects entity. Configure API Name with clothing_c. Learn how to create custom objects in the Marketo Admin UI.

On validation, the Market Bulk Import Snap imports the data for the configured Custom Objects. The output displays the details of the imported custom objects as follows.

 

Download this Pipeline

  File Modified

File Example_Marketo_Bulk Import_.slp

Oct 17, 2022 by Lakshmi Manda

Snap Pack History