In this Article
Overview
You can use the Lead Read Snap to query the Lead database. Lead database objects include the following:
Leads
Companies
Named Accounts
- Named Account List
- Static List
- Usage
Opportunities
Opportunity Roles
Sales Persons
Custom Objects
Activities
List and Program Membership
Prerequisites
A valid account with the required permissions. For more info, see Roles and Permissions.
Support for Ultra Pipelines
Works in Ultra Pipelines.
Limitations
Daily Quota: The subscriptions are allocated 50,000 API calls per day (which resets daily at 12:00AM CST).
API Rate Limit: All Marketo APIs are rate-limited. The API access per instance is limited to 100 calls per 20 seconds.
Concurrency Limit: You can make a maximum of 10 concurrent API calls.
Known Issues
Macro lookup error: excerpt "Marketo_KI" was not found on page "Bulk Import" (with ID 2598273315) in space "SD".
If you're experiencing issues please see our Troubleshooting Guide.
Macro lookup error: excerpt "Marketo_KI" was not found on page "Bulk Import" (with ID 2598273315) in space "SD".
If you're experiencing issues please see our Troubleshooting Guide.
- The Get Lead Activities REST API call fails while getting activities for the first page, because it expects a
nextPageToken
on the first page. See Connecting to Marketo with the REST Snap Pack for a workaround. - If the API rate limit of 100 calls per 20 seconds exceed, the API responds with a 606 error code and the Snap fails.
Snap Input and Output
Input/Output | Type of View | Number of Views | Examples of Upstream and Downstream Snaps | Description |
---|---|---|---|---|
Input | Document |
|
| Command to query the Lead database. |
Output | Document |
|
| Document with the record on the basis of the input command. |
Snap Settings
Field Name | Description | |
---|---|---|
Label | 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: Lead Read Example: Reading Lead | |
Command | Enter the command to query the Asset database to retrieve the desired records. Alternatively, click the Suggestion icon to fetch a list of commands. Some commands require specific data in the input view. In such cases, place the Mapper Snap as an upstream Snap Lead Read Snap, validate the pipeline and note the Target Schema in Mapper Snap. Refer to the Marketo Lead Database document for details of each command Default Value: N/A | |
Query Parameters | You can use this fieldset to define the name and value for query parameters on request. Ensure that the query parameters are unique and not defined in both input documents and properties. | |
Name | Specify the name of the query parameter for retrieving assets. Default Value: N/A Example: activityTypeIds | |
Value | Specify the value for the query parameter for retrieving assets. Default Value: N/A Example: 12 | |
Snap Execution | Select one of the three following modes in which the Snap executes:
Default Value: Validate & Execute |
Troubleshooting
None.
Example
Including and Retrieving a Lead
This example Pipeline demonstrates how we can include a lead to the Lead database and retrieve that lead from the Lead database. We use the Lead Write and Lead Read Snaps to accomplish this task.
Initially, we pass the following required lead values and account name in the Pipeline as key-value parameters.
Key | Value |
---|---|
MarketoAccountName | DG_Marketo_Account |
FirstName | Mary |
Gender | Female |
LastName | Smith |
Create a lead and insert them into the Leads database
We begin with mapping the lead information (defined in the Pipeline parameters) using the Mapper Snap. Upon validation, we see the lead information in the output preview of the Snap.
Mapper Configuration | Mapper Output |
---|---|
Next, we configure the Lead Write Snap to insert the lead information into the Lead database. Upon validation, we see a confirmation on the lead created into the Lead database.
Lead Write Configuration | Lead Write Output |
---|---|
Query and retrieve a lead from the Lead database
Here, we map the information to a Lead Read Snap, which is used to query and retrieve the lead from the Lead database.
To this end, we configure the Mapper Snap to set the target path to have the Lead ID. Upon validation, we see the output with lead ID information.
Mapper Configuration | Mapper Output |
---|---|
Next, we configure the Lead Read Snap, to retrieve the lead information by the Lead ID.
Lead Read Configuration | Lead Read Output |
---|---|
Release | Snap Pack Version | Date | Type | Updates |
---|---|---|---|---|
August 2024 | main27765 | Stable | Upgraded the | |
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 |
|
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 |
|
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:
|
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 |
|
| 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. |