Skip to end of banner
Go to start of banner

Asset Read

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 58 Current »

In this Article

Overview

You can use the Asset Read Snap to query the Asset database. Marketo assets include:

  • Folders

  • Programs

  • Emails

  • Email Templates

  • Landing Pages

  • Landing Page Templates

  • Snippets

  • Forms

  • Tokens

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

  • If the API rate limit of 100 calls per 20 seconds exceed, the API responds with a 606 error code and the Snap fails.

  • The Asset Read Snap does not fetch existing data in Marketo database with special characters and displays warning as “No assets found for the given search criteria”

  • 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 

Document


  • Min: 0

  • Max: 2

  • Mapper Snap

  • Copy Snap

Command to query the Asset database.

  • To enable pagination for the asset operations with the maxReturn input query parameter, provide any integer value for the maxReturn input query parameter.

  • To fetch all the records, we recommend you set the maxReturn value to 0 or to a very large integer.

Output

Document


  • Min: 0

  • Max: 1

  • Mapper Snap

  • Copy Snap

A document containing the record on the basis of the input command.

Snap Settings

  • Asterisk ( * ): Indicates a mandatory field.

  • Suggestion icon ( (blue star) ): Indicates a list that is dynamically populated based on the configuration.

  • Expression icon ( (blue star) ): Indicates the value is an expression (if enabled) or a static value (if disabled). Learn more about Using Expressions in SnapLogic.

  • Add icon ( (blue star) ): Indicates that you can add fields in the fieldset.

  • Remove icon ( (blue star) ): Indicates that you can remove fields from the fieldset.

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 ValueAsset Read
ExampleGet data

Command*N/A

Specify the command to query the Asset database to retrieve the desired recordsAlternatively, click the Suggestion icon to fetch a list of commands and select a command.

Some commands require specific data in the input view. In such cases, place the Mapper Snap as an upstream Snap
Asset Read Snap, validate the pipeline, and note the Target Schema in Mapper Snap. 
Refer to the Marketo Assets document for details of each command

Default ValueN/A.
Example: Get Email by Name

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 the input document and query properties.

Name

Specify the name of the query parameter for retrieving assets.

Default Value: N/A.

Example: folder

Value


Specify the value for the query parameter for retrieving assets.

  • To enable pagination for the asset operations with the maxReturn input query parameter, provide any integer value for the maxReturn input query parameter.

  • To fetch all the records, we recommend you set the maxReturn value to 0 or to a very large integer.

Default Value: N/A.

Example: 7888888

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 ValueValidate & Execute
ExampleExecute

Troubleshooting

None.

Examples

Retrieve Folders

This example Pipeline demonstrates how we can retrieve a form from the Asset database using the Asset Read Snap. 

Initially, we configure the Asset Read Snap to retrieve data using the Get Folders Command field and validate the Snap.

Input

We have a set of commands which we can see as list when we click on the Suggestion icon.

Suggestion for Commands

Upon validation, we see the following data (folders from Asset database) in the output preview of the Snap.

Output

Download this Pipeline.

Getting Emails without Offset value

This example Pipeline demonstrates how to retrieve emails from the Asset database using the Asset Read Snap without specifying the offset value in the Query Parameters fieldset.

Initially, configure the Asset Read Snap to fetch emails using the Get Emails in the Command field.

On validation, you can see the following data (emails from the Asset database) in the output preview of the Snap. The output displays the results from the first record.

Download this Pipeline.

Getting emails with an Offset value

This example Pipeline demonstrates how to get emails by specifying an offset value.

Configure the Asset Read Snap to retrieve emails using the Get Emails Command field and validate the Snap. Specify the offset value in the Query Parameters field as 10.

On validation, you can see the following data (emails from the Asset database) in the output preview of the Snap. Observe that the output displays the results from the 11th record.

Download this Pipeline.

Getting Emails with Offset And Maximum Return values

This example Pipeline demonstrates how to get emails by specifying an offset and maxReturn values.

Configure the Asset Read Snap to retrieve emails using the Get Emails Command field and validate the Snap. Specify the offset value in the Query Parameters field as 10 and the maxReturn value as 10.

On validation, you can see the following data (emails from the Asset database) in the output preview of the Snap. Observe that the output displays the results from the 11th record to the 20th record.

Download this Pipeline.

Downloads

Important Steps to Successfully Reuse Pipelines

  1. Download and import the Pipeline into SnapLogic.

  2. Configure Snap accounts as applicable.

  3. Provide Pipeline parameters as applicable.

  File Modified
You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.
No files shared here yet.
  • Drag and drop to upload or browse for files
  • Snap Pack History

     Click here to expand...

    Release

    Snap Pack Version 

    Date

    Type

    Updates

    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

    • 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

    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

    • 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

     

    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:

    • Timeout (seconds)

    • Number of Retries

    • Retry Interval (seconds)

    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

     

    • 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.



    • No labels