Skip to end of banner
Go to start of banner

Bulk Import

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 27 Next »

In this article

Overview

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

Snap Type

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

The Marketo Bulk Import Snap does not import data for the selected Custom Objects or display an error for invalid data or data type mismatch. Instead, the import job provides a warning without Snap failure or error details.

Snap Views

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 while 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 ((blue star)): Indicates a list that is dynamically populated based on the configuration.

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

  • Add icon ( (blue star) ): Indicates that you can add fields in the fieldset.

  • Remove icon ( (blue star)): Indicates that you can remove fields from the fieldset.

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

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
No files shared here yet.

Snap Pack History


  • No labels