Bulk Extract

Overview

You can use this Snap to perform bulk extract (export) for the selected entity. When using date-based filters, specify all dates in UTC format.


Marketo Bulk Extract Overview
  • This is a Read-type Snap.
  • Ultra: Works in Ultra Pipelines only when the Snap is in the non-lineage path.

Prerequisites

A valid account with the required permissions.

Limitations

  • Works in Ultra Pipelines only when the Snap is in the non-lineage path.
  • 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.
  • The Marketo Bulk Extract Snap supports only one filter at a time for bulk export with Leads or Custom Objects as the Entity type. So, if you select multiple filters for these Entity types, Snap displays an error.

Known issues

  • This Snap fails with a lineage error when used in the lineage path.
  • Marketo Snaps do not support some special characters (for example, (๐––๐–—๐–˜๐–ฌ๐–ญ๐–ฎ๐—•๐—–๐˜ง๐˜จ๐˜ฉ๐›€๐›๐›‚๐›ƒ๐›„๐›…๐›†๐›‡,๐–—๐–˜๐–ฌ๐›Œ๐›—๐›˜๐›™๐›ด).

Snap views

Type Description Examples of upstream and downstream Snaps
Input This Snap has at most one document input view. Requires the Export format with filter data to retrieve the respective entity from Marketo. Mapper
Output This Snap has at most two document output views. The extracted data relating to the specific entity.
Learn more about Error handling.

Snap settings

Note: Learn about the common controls in the Snap settings dialog.
Field/Field set Description
Label*

String		 Specify a unique name for the Snap. Supports expressions.

Default value: Marketo Bulk Extract
Marketo Entity

String/Expression/ Suggestion

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

  • Leads - Marketo provides interfaces for the extraction of large sets of person data.
  • Activities - Extracts activities-related data.
  • Program Members - Extracts program members' data.
  • Custom Objects - Extracts custom object related data.

Default value: Leads
API Name*

String/Expression

Appears when you select Custom Objects for Marketo Entity.

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

Default value: N/A
Include export ID

Checkbox

Select this checkbox to display the export ID in the output.

Default value: Deselected
Include record count

Checkbox

When you select this checkbox, the number of records processed by the export job is included in the output document. The numberOfRecords field is read from the response, and its value is added to the output data under the key numberOfRecords. Each output document includes a copy of the numberOfRecords field with the processed record count reported by the Marketo export job.

Default value: Deselected
Timeout (seconds)

String/Expression

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

Default value: 0

Example: 1000
Number of Retries

String/Expression

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

Default value: 0

Example: 3
Retry Interval (seconds)

String/Expression

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

Default value: 1

Example: 4
Snap execution

Dropdown list
Choose one of the three modes in which the Snap executes. Available options are:
  • 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.

Default value: Validate and Execute

Examples