August 17, 2023

tMarketoListOperation – Docs for ESB 5.x

  2. Talend for ESB Docs
  3. Docs 5.x
  4. tMarketoListOperation – Docs for ESB 5.x

tMarketoListOperation

tMarketoListOperation_icon32_white.png

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

Note

Contact Marketo Support via <support@marketo.com>
for further information.

 

Client Access ID

A user ID for the access to Marketo web service.

Note

Contact Marketo Support via <support@marketo.com>
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.

Use_Case_tMarketoListOperation1.png

Setting up the Job

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

  2. Connect tFixedFlowInput to tMarketoListOperation using a Row > Main
    connection.

  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.

    Use_Case_tMarketoListOperation2.png

  2. Click the three-dot button next to Edit
    schema     to set the schema manually.

    Use_Case_tMarketoListOperation3.png

  3. Click the plus button to add four columns:
    ListKeyType, ListKeyValue,
    LeadKeyType and LeadKeyValue.
    Keep the settings as default. Then click OK
    to save the settings.

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

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

    Use_Case_tMarketoListOperation4.png

  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.

    Use_Case_tMarketoListOperation5.png

  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.

    Use_Case_tMarketoListOperation6.png

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

Document get from Talend https://help.talend.com
Thank you for watching.
Docs 5.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x