In this Article
Table of Contents | ||||
---|---|---|---|---|
|
...
This Snap results to empty output if you select the JSON format. The preview result is displayed only if you select the Table format.
Marketo Snaps do not support some special characters (for example, (
𝖖𝖗𝖘𝖬𝖭𝖮𝗕𝗖𝘧𝘨𝘩𝛀𝛁𝛂𝛃𝛄𝛅𝛆𝛇,𝖗𝖘𝖬𝛌𝛗𝛘𝛙𝛴
).
...
Field Name | Field Type | Description | ||
---|---|---|---|---|
Label* | String | Specify a 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. Default Value: Bulk Lead Extract | ||
Timeout (seconds) | Integer/Expression | Specify the timeout for the operation in seconds. Default Value: 0 | ||
Number of Retries | Integer/Expression | Specify the number of attempts the Snap must make in case of connection failure or timeout. Minimum value: 0 Default Value: 0 | ||
Retry Interval (seconds) | Integer/Expression | Specify the minimum number of seconds the Snap must wait before each retry attempt. Minimum value: 1 Default Value: 1 | ||
Export format* | Dropdown list | Select the file format of the extracted data. The available options are as follows:
Default Value: csv | ||
Start date* | String/Date/Expression | Specify the date value (the date from which you want to extract records) you desire to extract data. This enables the Snap to extract data from the specified date. See the example below for more information.
Default Value: N/A | ||
End date* | String/Date/Expression | Enter the end date (of the date range) till which you want to extract the data. This enables the Snap to extract data until the specified date.
Default Value: N/A | ||
Fields To Extract | Use this field set to specify output fields while extracting data from the Lead database. This field set contains the Output Fields field. One output field row is added by default. Click to add more rows for output fields.. Add each output field in a separate row. | |||
Output Fields | String/Expression | Enter the field to display in the exported file. Default Value: N/A | ||
Snap Execution | Dropdown list | Select one of the three following modes in which the Snap executes:
DefaultValue: Validate and Execute |
...
This example Pipelines demonstrates how we can extract data in bulk from the Lead database using the Bulk Lead Extract Snap. We build the Pipeline to automate the following activities:
Extract data in bulk using Bulk Lead Extract Snap.
Write the binary data to an end point using File Writer Snap.
...
Initially, we configure the Bulk Lead Extract Snap as follows. Note that Export format, Start and End dates fields are mandatory. Additionally, you can provide specific fields to export from the database under Output Fields.
...
Next, we configure the File Writer Snap to write binary data to an end point.
File Writer Input |
---|
Upon execution, we see the extracted data with the proposed fields as output.
...
Extracting Leads Data Created Within A Specific Date Range
This is a simple example of a stand-alone Pipeline that demonstrates how we can extract data of leads created during a specific date range. This example assumes that you have configured a valid Marketo account to be used with this Snap.
We configure the Bulk Lead Extract Snap to extract the leads created during 2021-08-01 to 2021-08-11. We also want to extract the id, first name, last name, created at, and updated at fields to view in the output.
Upon validation, this Snap generates the leads data created during the specified date range.
Downloads
Info |
---|
Important Steps to Successfully Reuse Pipelines
|
...