tMarketoListOperation Properties - 6.3

Talend Open Studio for Big Data Components Reference Guide

Talend Open Studio for Big Data
Data Governance
Data Quality and Preparation
Design and Development
Talend Studio

Component family



Basic settings

Schema and Edit schema

A schema is a row description. It defines the number of fields (columns) to be processed and passed on to the next component. The schema is either Built-In or stored remotely in the Repository.

Since version 5.6, both the Built-In mode and the Repository mode are available in any of the Talend solutions.

Click Sync columns to retrieve the schema from the previous component connected in the Job.

The schema of this component is read-only. You can click Edit schema to view the schema.



Built-in: No property data is stored centrally.



Repository: Select the Repository file where Properties are stored.


Endpoint address

The URL of the Marketo Web server for the SOAP API calls to.


Secret key

Encrypted authentication code assigned by Marketo.

To enter the secret key, click the [...] button next to the secret key field, and then in the pop-up dialog box enter the password between double quotes and click OK to save the settings.


Contact Marketo Support via for further information.


Client Access ID

A user ID for the access to Marketo web service.


Contact Marketo Support via for further information.



Options in this list allow you carry out the adding/deletion one or more leads to/from a list in the Marketo DB; Also you can verify the existence of single or multiple leads in a list in the Marketo DB.

addTo: This operation adds one or more leads to a list in the Marketo DB.

isMemberOf: This operation checks the Marketo DB to judge whether the specific leads exist in the list.

removeFrom: This operation removes one or more leads from a list in the Marketo DB.


Add or remove multiple leads

Select this check box to add multiple leads to or remove multiple leads from a list in the Marketo DB.


This check box appears only when you select addTo or removeFrom from the Operation list.


Die on error

This check box is selected by default. Clear the check box to skip the row on error and complete the process for error-free rows. If needed, you can retrieve the rows on error via a Row > Reject connection.


Timeout (milliseconds)

Type in the query timeout (in milliseconds) on the Marketo Web service.


The Job will stop when Timeout exception error occurs.

Advanced settings

API Mode

Select the Marketo API mode, either REST API (default) or SOAP API.

For more information about the Marketo REST API, see

For more information about the Marketo SOAP API, see


tStatCatcher Statistics

Select this check box to gather the Job processing metadata at the Job level as well as at each component level.

Global Variables

NB_CALL: the number of calls. This is an After variable and it returns an integer.

ERROR_MESSAGE: the error message generated by the component when an error occurs. This is an After variable and it returns a string. This variable functions only if the Die on error check box is cleared, if the component has this check box.

A Flow variable functions during the execution of a component while an After variable functions after the execution of the component.

To fill up a field or expression with a variable, press Ctrl + Space to access the variable list and choose the variable to use from it.

For further information about variables, see Talend Studio User Guide.


This component is usually used as an intermediate component, and it requires an input component and an output component.