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

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.
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 Marketo Lead Read Snap has the checkbox Read All Pages, which does not apply to all the commands. A few commands (such as Get Paging Token, Member of List) do not support pagination due to the API limitation.

Snap Input and Output

Input/Output

Type of View

Number of Views

Examples of Upstream and Downstream Snaps

Description

Input

Document

Min: 0
Max: 2

Mapper
Copy

Command to query the Lead database.

Output

Document

Min: 0
Max: 1

Mapper
Copy

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 Example: Get Activity Types
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
Read All Pages		Select this checkbox to read all pages from Marketo for the specific input. This checkbox is not available for Get Pagination Token command. Default Value: Deselected.
Snap Execution		Select one of the three following modes in which the Snap executes: Validate & Execute. Performs limited execution of the Snap and generates a data preview during Pipeline validation, then 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 downstream from it. Default Value: Validate & Execute Example: Disabled

Troubleshooting

Error	Reason	Resolution
MAX RATE LIMIT '100' EXCEEDED WITHIN '20' SECS’.	When a number of Pipelines run in parallel, the number of calls in the past 20 seconds was greater than 100.	Refer to the Marketo documentation for best practices.
Concurrency Limit: Maximum of 10 concurrent API calls.	The concurrent API calls must have exceeded 10 calls.	Ensure to avoid more than 10 concurrent API calls.
TOTAL MEMBERSHIP SIZE: 3841393 EXCEEDS THE LIMIT ALLOWED(100000) FOR THE FILTER.	The number of program members exceeds 100,000.	Set the filter such that the Snap can fetch only less than 1,00,000 records. Refer to Program Members in the Marketo documentation for more details
Daily quota limit of API calls exceeded.	Most subscriptions are allocated 50,000 API calls per day (which resets daily at 12:00 AM CST).	Daily Quota: The maximum number of allocated API calls per day for most subscriptions are 50,000. Refer to Marketo documentation for best practices.
1003, Too many results match the filter in case the Get Leads by Filter Type data is greater than 1000.	Marketo Get Leads by Filter Type command will fail if the lead filter is greater than 1000.	The Lead filter value must be lower than 1000. Learn more about Leads, refer to Leads documentation.
Learn more from Error Code page for all Marketo-related errors and exceptions.

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

Download this Pipeline.

	File	Modified

No files shared here yet.

Release	Snap Pack Version	Date	Type	Updates
August 2024	main27765	21 Aug 2024	Stable	Upgraded the `org.json.json` library from v20090211 to v20240303, which is fully backward compatible.
May 2024	main26341	08 May 2024	Stable	Updated and certified against the current SnapLogic Platform release.
February 2024	436patches25142	22 Feb 2024	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	14 Feb 2024	Stable	Updated and certified against the current SnapLogic Platform release.
November 2023	435patches24804	06 Feb 2024	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	21 Dec 2023	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	19 Dec 2023	Latest	Enhanced the Marketo Bulk Extract Snap by adding the Include export ID checkbox. When you select this option, the Snap displays the export ID in the output. Added support to Marketo Bulk Lead Extract to display the Export ID in the output.
November 2023	main23721	08 Nov 2023	Stable	Updated and certified against the current SnapLogic Platform release.
August 2023	434patches22837	11 Sep 2023	Latest	Updated the input and output schema for the Marketo Snaps.
August 2023	main22460	16 Aug 2023	Stable	Updated and certified against the current SnapLogic Platform release.
May 2023	433patches21541	15 Jun 2023	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	05 Jun 2023	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	10 May 2023	Stable	Upgraded with the latest SnapLogic Platform release.
February 2023	432patches20585	24 Apr 2023	Latest	The Marketo Bulk Extract Snap works successfully in the non-lineage path within an Ultra task.
February 2023	main19844	09 Feb 2023	Stable	Upgraded with the latest SnapLogic Platform release.
November 2022	431patches19248	14 Dec 2022	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	06 Dec 2022	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	10 Nov 2022	Stable	The Asset Write Snap now supports special characters. The Asset Read, Asset Write, Lead Read, and Lead Write Snaps now have a new field set, Query Parameters, which enables you to define additional parameters for retrieving the asset details. Ensure that the query parameters are unique and not defined in both input documents and properties.
October 2022	430patches18810	01 Nov 2022	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	21 Oct 2022	Latest	Introduced Bulk Extract and Bulk Import Snaps that enable you to perform Bulk operations on specific entities. The Asset Read, Asset Write, Lead Read, and Lead Write Snaps now have a new field set, Query Parameters that enables you to define additional parameters for retrieving the asset details. Fixed support for special characters in the Asset Write Snap.
August 2022	main17386	11 Aug 2022	Stable	Upgraded with the latest SnapLogic Platform release.
4.29 Patch	429patches16430	09 Jun 2022	Latest	Fixed an issue with Marketo OAuth2 Account where the Snaps failed with `ACCESS TOKEN EXPIRED` error. Now the Snaps that use Marketo OAuth2 Account work as expected and does not display an expired token error. Fixed an issue with Marketo Bulk Lead Upsert Snap where the Snap processed only successfully submitted batch jobs. Now, the Snap processes the failed batch jobs and logs the response message for each status. Fixed an issue with Marketo Bulk Lead Upsert Snap where the Snap hung when parsing large data. Fixed an issue with Marketo Bulk Lead Upsert and Bulk Lead Extract Snaps where the Snaps did not display valid error messages for Timeout and Number of Retries property when the input is large, empty, or Null. Fixed an issue with Marketo Bulk Lead Upsert and Bulk Lead Extract Snaps where the Snaps failed without any reason when the Timeout value was less than 10 seconds.
4.29	main15993	14 May 2022	Stable	Upgraded with the latest SnapLogic Platform release.
4.28	main14627	12 Feb 2022	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: Timeout (seconds) Number of Retries Retry Interval (seconds)
4.27 Patch	427patches13147	04 Feb 2022	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	02 Feb 2022	Latest	Fixed an issue where the Bulk Lead Extract and Bulk Lead Upsert Snaps failed when the Snaplexes were proxy-enabled.
4.27	main12833	13 Nov 2021	Stable	Upgraded with the latest SnapLogic Platform release.
4.26 Patch	426patches11555	23 Sep 2021	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	14 Aug 2021	Stable	Upgraded with the latest SnapLogic Platform release.
4.25	main9554	08 May 2021	Stable	No updates made.
4.24	main8556	13 Feb 2021	Stable	No updates made.
4.23-Patches	423patches7812	18 Dec 2020	Stable Latest	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.