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 37 Next »

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

  • If you enable expressions for the Marketo Entity field, it's possible that other fields that are not relevant might be displayed in the UI (because of a UI limitation). If you think a field is not relevant, leave it blank.

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

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 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 ((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 field set.

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

  • 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

 Click here to expand...

Release

Snap Pack Version 

Date

Type

Updates

November 2024

main29029

Stable

Updated and certified against the current SnapLogic Platform release.

August 2024

main27765

Stable

Upgraded the org.json.json library from v20090211 to v20240303, which is fully backward compatible.

May 2024

main26341

Stable

Updated and certified against the current SnapLogic Platform release.

February 2024

436patches25142

Latest

Fixed an issue with the Marketo Bulk Import and Bulk Lead Extract Snaps where the timeout was not disabled when the Timeout setting was set to 0.

February 2024

main25112

Stable

Updated and certified against the current SnapLogic Platform release.

November 2023

435patches24804

Latest

Fixed an issue with the Marketo Bulk Extract Snap where the timeout was not disabled when the Timeout setting was set to 0.

November 2023

435patches24332

Latest

Enhanced the Marketo Asset Read Snap to enable pagination when the maxReturn input query parameter value exceeds 200. We recommend you to set the maxReturn value to 0 or a large integer to fetch all the records.

November 2023

435patches24248

Latest

  • Enhanced the Marketo Bulk Extract Snap by adding the Include export ID checkbox. When you select this option, the Snap displays the export ID in the output.

  • Added support to Marketo Bulk Lead Extract to display the Export ID in the output.

November 2023

main23721

Stable

Updated and certified against the current SnapLogic Platform release.

August 2023

434patches22837

Latest

Updated the input and output schema for the Marketo Snaps.

August 2023

main22460

Stable

Updated and certified against the current SnapLogic Platform release.

May 2023

433patches21541

Latest

Fixed an issue with the Bulk Extract and Bulk Import Snaps where the API name was inaccessible when expressions were enabled for the Marketo Entity field and Custom Objects were selected.

May 2023

433patches21295

Latest

Fixed an issue with the Marketo Bulk Extract Snap where the Snap failed to extract data from the CSV file when the data consisted of the backslash (\) character.

May 2023

main21015

Stable

Upgraded with the latest SnapLogic Platform release.

February 2023

432patches20585

 

Latest

The Marketo Bulk Extract Snap works successfully in the non-lineage path within an Ultra task.

February 2023

main19844

 

Stable

Upgraded with the latest SnapLogic Platform release.

November 2022

431patches19248

 

Latest

The Marketo Lead Read Snap includes a new Read All Pages checkbox, which enables you to fetch all records for a selected command.

November 2022

431patches18969

 

Latest

The Marketo Bulk Import Snap now imports data for the selected Custom Objects. It also displays an error for invalid data or a mismatch of data type.

November 2022

main18944

 

Stable

 Ensure that the query parameters are unique and not defined in both input documents and properties.

October 2022

430patches18810

 

Latest

The Marketo Asset Write Snap no longer fails with 601 and 602 errors when the OAuth access token expires or is invalid.

October 2022

430patches18707

 

Latest

August 2022

main17386

 

Stable

Upgraded with the latest SnapLogic Platform release.

4.29 Patch

429patches16430

 

Latest

  • Fixed an issue with Marketo OAuth2 Account where the Snaps failed with ACCESS TOKEN EXPIRED error. Now the Snaps that use Marketo OAuth2 Account work as expected and does not display an expired token error.

  • Fixed an issue with Marketo Bulk Lead Upsert Snap where the Snap processed only successfully submitted batch jobs. Now, the Snap processes the failed batch jobs and logs the response message for each status.

  • Fixed an issue with Marketo Bulk Lead Upsert Snap where the Snap hung when parsing large data.

  • Fixed an issue with Marketo Bulk Lead Upsert and Bulk Lead Extract Snaps where the Snaps did not display valid error messages for Timeout and Number of Retries property when the input is large, empty, or Null.

  • Fixed an issue with Marketo Bulk Lead Upsert and Bulk Lead Extract Snaps where the Snaps failed without any reason when the Timeout value was less than 10 seconds.

4.29

main15993

 

Stable

Upgraded with the latest SnapLogic Platform release.

4.28

main14627

 

Stable

Enhanced the Bulk Lead Extract and Bulk Lead Upsert Snaps with retry mechanism fields to set a time limit to complete the processing of operations:

  • Timeout (seconds)

  • Number of Retries

  • Retry Interval (seconds)

4.27 Patch

427patches13147

 

Latest

Fixed an issue with the Asset Read, Lead Read, and Asset Write Snaps where the original payload was not passed through to the error view.

4.27 Patch

427patches12999

 

Latest

Fixed an issue where the Bulk Lead Extract and Bulk Lead Upsert Snaps failed when the Snaplexes were proxy-enabled.

4.27

main12833

 

Stable

Upgraded with the latest SnapLogic Platform release.

4.26 Patch

426patches11555

Latest

Fixed an issue with the Marketo Lead Read Snap, wherein the Snap generated the same next page token anytime during the day.

4.26

 main11181

 

Stable

Upgraded with the latest SnapLogic Platform release.

4.25

main9554

 

Stable

No updates made.

4.24

main8556

 

Stable

No updates made.

4.23-Patches

423patches7812

 

  • Stable

  • Latest

Introduces the Marketo Snap Pack to enable automating the process of performing operations to the Asset database and Lead database that manage the potential data for an organization in the marketing industry.


  • No labels