tMarketoListOperation

Adds/removes one or more leads to/from a list in Marketo. Also, it helps you
verify the existence of one or more leads in a list in Marketo.

tMarketoListOperation Standard properties

These properties are used to configure tMarketoListOperation running in the Standard Job framework.

The Standard
tMarketoListOperation component belongs to
two
families: Business and
Cloud.

The component in this framework is available in all Talend
products.

Basic settings

Property Type	Select the way the connection details will be set. Built-In: The connection details will be set locally for this component. You need to specify the values for all related connection properties manually. Repository: The connection details stored centrally in Repository > Metadata will be reused by this component. You need to click the […] button next to it and in the pop-up Repository Content dialog box, select the connection details to be reused, and all related connection properties will be automatically filled in. This property is not available when other connection component is selected from the Connection Component drop-down list.
Connection component	Select the component whose connection details will be used to set up the connection to Marketo from the drop-down list.
Endpoint address	Enter the API Endpoint URL of the Marketo Web Service. The API Endpoint URL can be found on the Marketo Admin > Web Services panel.
Client access ID	Enter the client ID for the access to the Marketo Web Service. The client ID and client secret key can be found on the Marketo Admin > LaunchPoint panel, by clicking View Details for the service to be accessed. You can also contact Marketo Support via support@marketo.com for further information.
Secret key	Enter the client secret key for the access to the Marketo Web Service. 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.
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. When you create a Spark Job, avoid the reserved word `line` when naming the fields. Built-In: You create and store the schema locally for this component only. Repository: You have already created the schema and stored it in the Repository. You can reuse it in various projects and Job designs. Click Sync columns to retrieve the schema from the previous component connected in the Job. This component offers the advantage of the dynamic schema feature. This allows you to retrieve unknown columns from source files or to copy batches of columns from a source without mapping each column individually. For further information about dynamic schemas, see Talend Studio User Guide. This dynamic schema feature is designed for the purpose of retrieving unknown columns of a table and is recommended to be used for this purpose only; it is not recommended for the use of creating tables. Note that the dynamic schema feature for this component is only supported in the REST API mode.
Operation	Select an operation to be performed from the drop-down list. addTo: This operation adds one or more leads to a list. isMemberOf: This operation verifies whether the specific leads exist in the list. removeFrom: This operation removes one or more leads from a list.
Add or remove many prospects	Select this check box to add multiple leads to or remove multiple leads from a list. This check box is available only when `addTo` or `removeFrom` is selected from the Operation list.
Die on error	Select the check box to stop the execution of the Job when an error occurs. Clear the check box to skip any rows on error and complete the process for error-free rows. When errors are skipped, you can collect the rows on error using a Row > Reject connection if the Add or remove many prospects check box is cleared.

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 http://developers.marketo.com/documentation/rest/. For more information about the Marketo SOAP API, see http://developers.marketo.com/documentation/soap/.
Timeout	Enter the timeout value (in milliseconds) for the connection to the Marketo Web Service before terminating the attempt.
Max reconnection attemps	Enter the maximum number of reconnect attempts to the Marketo Web Service before giving up.
Attempt interval time	Enter the time period (in milliseconds) between subsequent reconnection attempts.
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

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

Usage

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

Adding a lead record to a Marketo list using SOAP API

The following scenario describes a three-component Job that adds a lead
record into a specified list in Marketo using SOAP API.

Setting up the Job for adding a lead record to a Marketo list

Create a new Job and add a tFixedFlowInput component, a tMarketoListOperation component, and a tLogRow component by typing their names in the
design workspace or dropping them from Palette.
Double-click the tMarketoListOperation component and on the
Component tab click Advanced settings to open its advanced settings view, then
select SOAP from the API Mode
drop-down list.
Connect tFixedFlowInput to
tMarketoListOperation using a
Row > Main connection. In the pop-up dialog box, click Yes to get the schema from the target
component.
Connect tMarketoListOperation to tLogRow using a Row >
Main connection.

Configuring the Job for adding a lead record to a Marketo list

Double-click the tFixedFlowInput component to open its Basic settings view.
Click the […] button
next to Edit schema to view its
schema.
In the Mode area, select
Use Inline Table, and then click the
[+] button to add one row and fill
the row with respective values. In this example, these values are: MKTOLISTNAME for ListKeyType, Test_Comp_QA for ListKeyValue, IDNUM for
LeadKeyType and 9300203 for LeadKeyValue.
Double-click the tMarketoListOperation component to open its Basic settings view.
In the Endpoint address
field, enter the Marketo SOAP API endpoint URL that can be found on the Marketo Admin > Web Services panel.
In the Client Access ID and Secret key fields, enter the user ID and
encryption key required to access Marketo.
From the Operation list,
select addTo to add the lead with the ID
9300203 into the list
Test_Comp_QA.
Double-click the tLogRow
component to open its Basic settings
view.
Click the Sync columns
button to synchronize the schema with the input schema.
In the Mode area, select
Table (print values in cells of a
table) for better readability of the result.

Executing the Job to add a lead record to a Marketo list

Press Ctrl + S to save
the Job.
Press F6 or click
Run on the Run tab to run the Job.

As shown above, the result of the operation is displayed on the Run console.
Double-check the result in Marketo.

The lead with the ID 9300203 in
Marketo is added into the list Test_Comp_QA.

Document get from Talend https://help.talend.com

Thank you for watching.

Docs 7.x

0 Comments

Inline Feedbacks

View all comments

tMarketoListOperation – Docs for ESB Marketo 7.x

tMarketoListOperation