Versions Compared

Old Version 1

changes.mady.by.user Kalpana Malladi

Saved on

compared with

New Version Current

changes.mady.by.user Gouri Bhagchandani

Saved on

Key

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

In this article

Table of Contents
minLevel1
maxLevel2
absoluteUrltrue

Overview

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

...

Snap Type

The Marketo Bulk Import Snap is a Read/ Write/Parse/Transform/Flow/Format-type Snap that reads/fetches/writes/parses/executes/transforms/calls/creates… .

Prerequisites

A valid account with the required permissions.

Support for Ultra Pipelines  

Works 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

Input 

Document

  • Min: 0

  • Max:

2

  • 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

    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

    • 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

    Info

    • 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 fieldsetfield set.

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

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

    Field Name

    Field Type

    Field Dependency

    Description

    Label*

    Default Value: Marketo Bulk Import
    Example: Marketo Bulk Import

    String

    The

    N/A

    Specify a unique 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.

    Marketo Entity*

     

    Default Value: Leads
    Example: Custom Objects

    String/Expression

    Select an entity

    N/A

    Select one of the following entities for which you

    must perform the bulk operation

    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:

     None

     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

    items

    leads data.

    Lookup Field


    Default Value:

     None

     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…

    twitterID.

    Note

    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 Value: 0
    Example:

    2

    1000

    String

    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 Value: 0
    Example: 3

    String

    Integer/Expression

    None

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

    Retry Interval (seconds)


    Default Value: 1
    Example: 4

    String

    Integer/Expression

    None

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

    Snap Execution

    Default Value: Execute 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.

    Troubleshooting

    ...

    Error

    ...

    Reason

    ...

    Resolution

    ...

    Account validation failed.

    ...

    The Pipeline ended before the batch could complete execution due to a connection error.

    ...

    Verify that the Refresh token field is configured to handle the inputs properly. If you are not sure when the input data is available, configure this field as zero to keep the connection always open.

    Examples

    Excluding Fields from the Input Data Stream

    We can exclude the unrequired fields from the input data stream by omitting them in the Input schema field set. This example demonstrates how we can use the <Snap Name> to achieve this result:

    <screenshot of Pipeline/Snap and description>

    Download this Pipeline. 

    Downloads

    ...

    Download and import the Pipeline into SnapLogic.

    ...

    Configure Snap accounts, as applicable.

    ...

    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.

    Image Added

    		Image Added

    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

    Attachments
    patterns*.slp, *.zip

    ...

    Snap Pack History

    Expand

    Insert excerpt
    Marketo Snap Pack
    Marketo Snap Pack
    nameMarketo_SPH
    nopaneltrue

    ...

    ...