tMarketoInput – Docs for ESB 5.x

Component family

Business/Cloud

Function

The tMarketoInput component
retrieves data from a Marketo Web server.

Purpose

The tMarketoInput component
allows you to retrieve data from a Marketo DB on a Web
server.

Basic settings

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 <support@marketo.com> to
get this information.

Client Access ID

A user ID for the access to Marketo web service.

Contact Marketo Support via <support@marketo.com> to
get this information.

Operation

Options in this list allow you to retrieve lead data from Marketo
to external systems.

getLead: This operation retrieves
basic information of leads and lead activities in Marketo DB.

getMultipleLeads: This operation
retrieves lead records in batch.

getLeadActivity: This operation
retrieves the history of activity records for a single lead
identified by the provided key.

getLeadChanges: This operation
checks the changes on Lead data in Marketo DB.

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 Edit schema to make changes to the schema. If the
current schema is of the Repository type, three options are
available:

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

Built-in: No property data is
stored centrally.

Repository: Select the Repository
file where Properties are stored.

Columns Mapping

You can set the mapping conditions by making changes in Edit Schema. By default, column names in
Column fields are the same as
what they are in the schema.

Lead Selector

Select one of the following lead selector types from the
list:

This list appears only when getMultipleLeads is selected from the Operation list.

LeadKey type

The data types of LeadKey
supported by Marketo DB.

This list appears when:

LeadKey value

The value of LeadKey.

This field appears when getLead
or getLeadActivity is selected from
the Operation list.

LeadKey values

Specify the values of the LeadKey by selecting a column from the
input flow that holds the LeadKey values.

This list appears only when getMultipleLeads is selected from the Operation list and LeadKeySelector is selected from the Lead Selector list.

Set Include Types

Select this check box to include the types of LeadActivity content
to be retrieved. Click the plus button under the Include Types area to select in the list
types to add.

This field is displayed only when you select getLeadActivity or getLeadChanges from the Operation list.

Set Exclude Types

Select this check box to exclude the types of LeadActivity content
to be retrieved. Click the plus button under the Exclude Types area to select in the list
types to add.

This field is displayed only when you select getLeadActivity or getLeadChanges from the Operation list.

Oldest Updated At

Type in the time of the earliest update to retrieve only the leads
updated since the specified time.

It supports the time format that Marketo supports. For the
supported time format, see http://developers.marketo.com/documentation/soap/getmultipleleads/.

This field appears only when getMultipleLeads is selected from the Operation list and LastUpdateAtSelector is selected from the Lead Selector list.

Last Updated At

Type in the time of the latest update to retrieve only the leads
updated before the specified time.

It supports the time format that Marketo supports. For the
supported time format, see http://developers.marketo.com/documentation/soap/getmultipleleads/.

This field appears only when getMultipleLeads is selected from the Operation list and LastUpdateAtSelector is selected from the Lead Selector list.

Oldest create date

Type in the time of the earliest creation to retrieve only the
data since the specified time. The time format is YYYY-MM-DD
HH:MM:SS Z.

This field is displayed only when you select getLeadChanges from the Operation list.

Latest create date

Type in the time of the latest creation to retrieve only the data
before the specified time. The time format is YYYY-MM-DD HH:MM:SS Z.

This field is displayed only when you select getLeadChanges from the Operation list.

Oldest create date and Latest create date can be specified
together or separately.

Batch Size

The maximum batch size in retrieving lead data in batch.

This field is available when:

Timeout (milliseconds)

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

The Job will stop when Timeout exception error occurs.

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.

Advanced settings

Max number of reconnection attempts

Specify the maximum number of times to reconnect to the Marketo
Web server in case of loss of connection.

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 input component, it requires an
output component.

Limitation

n/a