tMarketoListOperation - 6.1

Talend Components Reference Guide

EnrichVersion
6.1
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for Data Quality
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

tMarketoListOperation Properties

Component family

Business/Cloud

 

Function

The tMarketoListOperation component adds/removes one or more leads to/from a list in the Marketo DB; It also verifies if one or more leads exist in a list in Marketo DB.

Purpose

The tMarketoListOperation component allows you to add/remove one or more leads to/from a list in the Marketo DB on a Web server. Also, you can verify the existence of one or more leads in a list in the Marketo DB.

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.

 

API Mode

Select the Marketo API mode, either SOAP API or REST API.

For more information about Marketo SOAP API, see http://developers.marketo.com/documentation/soap/.

For more information about Marketo REST API, see http://developers.marketo.com/documentation/rest/.

 

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.

Note

Contact Marketo Support via for further information.

 

Client Access ID

A user ID for the access to Marketo web service.

Note

Contact Marketo Support via for further information.

 

Operation

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.

Note

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.

Note

The Job will stop when Timeout exception error occurs.

Advanced settings

tStatCatcher Statistics

Select this check box to gather the Job processing metadata at a 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.

Usage

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

Limitation

n/a

Scenario: Adding a lead record to a list in the Marketo DB

The following scenario describes a three-component Job that adds a lead record into a list in the Marketo database.

Setting up the Job

  1. Drop tMarketoListOperation, tFixedFlowInput and tLogRow onto the design workspace.

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

  3. Connect tMarketoListOperation to tLogRow using a Row > Main connection.

Configuring the input component

  1. Double-click tFixedFlowInput to define the component properties in its Basic settings view.

  2. Click the [...] button next to Edit schema to view its schema.

  3. In the Mode area, select Use Inline Table.

  4. Click the plus button to add a new line and fill the line with respective values. In this example, these values are: MKTOLISTNAME for ListKeyType, bchenTestList for ListKeyValue, IDNUM for LeadKeyType and 308408 for LeadKeyValue.

Configuring tMarketoListOperation

  1. Double-click tMarketoListOperation to define the component properties in its Basic settings view.

  2. Click the Sync columns button to retrieve the schema defined in tFixedFlowInput.

  3. Type in 1 in the Number of rows field.

  4. Fill the Endpoint address field with the URL of the Marketo Web server. In this example, it is https://na-c.marketo.com/soap/mktows/1_5.

    Note that the URL used in this scenario is for demonstration purposes only.

  5. Fill the Secret key field with encrypted authentication code assigned by Marketo. In this example, it is 464407637703554044DD11AA2211998.

  6. Fill the Client Access ID field with the user ID. In this example, it is mktodemo41_785133934D1A219.

  7. From the Operation list, select addTo.

  8. Type in the limit of query timeout in the Timeout field. In this example, use the default number: 60000.

Job Execution

  1. Double-click tLogRow to define the component properties in its Basic settings view.

  2. Click the Sync columns button to retrieve the schema defined in tMarketoListOperation.

  3. In the Mode area, select Table.

  4. Save your Job and press F6 to execute it.

The result of adding a lead record to a list in Marketo DB is displayed on the Run console.