Bulk Lead Upsert

Owned by Lakshmi Manda, created
Last updated: Jun 16, 2023 by Amritesh Singh
4 min read

In this Article

Overview

You can use the Bulk Lead Upsert Snap to upsert a large number of leads into the Lead database.

Prerequisites

A valid account with the required permissions. For more info, see Roles and Permissions.

Support for Ultra Pipelines

Works in Ultra Pipelines. 

Limitations

  • API Limits: 

  • Marketo supports a variety of objects for extraction, such as Bulk Custom Object Import, Bulk Lead Import, and Bulk Program Member Import; however, this Snap supports only Lead upsert objects. See Bulk Lead Import API for more information.

  • This Snap accepts values for the Timeout (seconds), Number of Retries, and Retry Interval (seconds) fields from Pipeline parameters only. These fields do not support values from upstream Snaps when you enable the expression icon.

Known Issues

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

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

Snap Input and Output

Input/Output

Type of View

Number of Views

Examples of Upstream and Downstream Snaps

Description

Input/Output

Type of View

Number of Views

Examples of Upstream and Downstream Snaps

Description

Input 

Binary



  • Min: 0

  • Max: 2

  • Mapper Snap

  • File Reader

Requires the Upsert format and additional detail, if required, to insert or update a large number of records into the Lead database.

Output

Document



  • Min: 0

  • Max: 1

  • Mapper Snap

  • Copy Snap

Insertion of large leads into the Lead database.

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.