tMarketoInput Standard properties

Marketo

author
Talend Documentation Team
EnrichVersion
6.4
EnrichProdName
Talend Data Management Platform
Talend Open Studio for MDM
Talend Big Data
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Data Integration
Talend Open Studio for ESB
Talend Open Studio for Data Integration
Talend Real-Time Big Data Platform
Talend Data Services Platform
Talend Data Fabric
Talend Big Data Platform
task
Data Quality and Preparation > Third-party systems > Business applications > Marketo components
Data Governance > Third-party systems > Business applications > Marketo components
Design and Development > Third-party systems > Business applications > Marketo components
EnrichPlatform
Talend Studio

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

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

The component in this framework is generally available.

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 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 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. The schema is either Built-In or stored remotely in the Repository.

  • Built-In: You create and store the schema locally for this component only. Related topic: see Talend Studio User Guide.

  • Repository: You have already created the schema and stored it in the Repository. You can reuse it in various projects and Job designs. Related topic: see Talend Studio User Guide.

The schema of this component is predefined and it will be different according to the API mode selected, the operation chosen or the custom object specified.

Note that when the API mode is changed, you need to refresh the schema columns manually by switching back and forth the components in the Connection Component drop-down list (only when reusing the connection created by a tMarketoConnection component) and changing the operation to be performed in the Operation drop-down list.

Click Edit schema to make changes to the schema. If the current schema is of the Repository type, three options are available:

  • View schema: choose this option to view the schema only.

  • Change to built-in property: choose this option to change the schema to Built-in for local changes.

  • Update repository connection: choose this option to change the schema stored in the repository and decide whether to propagate the changes to all the Jobs upon completion. If you just want to propagate the changes to the current Job, you can select No upon completion and choose this schema metadata again in the [Repository Content] window.

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 one of the following operations to be performed from the drop-down list.

  • getLead: This operation retrieves a single lead record.

  • getMultipleLeads: This operation retrieves a batch of lead records that match the specified lead selector search condition.

  • getLeadActivity: This operation retrieves the activity history that matches the specified search condition.

  • getLeadChanges: This operation retrieves data value changes and new lead activities after a given time.

  • CustomObject: Select this item to perform specific action on a custom object. This item is available only in the REST API mode.

Mappings

Complete this table to map the column names of the component schema with the column names in Marketo. By default, the column names in Column name fields are the same as what they are in the schema.

Note that because some column names in Marketo may contain blank space, which is not allowed in the component schema, you need to specify the corresponding column fields in the Marketo column name column. If the defined column names in schema are the same as column names in Marketo, it is not necessary to set the columns mapping.

This table is not available when CustomObject is selected from the Operation list in the REST API mode.

Lead selector

Select one of the following lead selector types from the drop-down list.

  • LeadKeySelector: Select this type to retrieve lead records that are identified by the specified lead key.

  • StaticListSelector: Select this type to retrieve lead records that are members of the given static list. With this option selected, you need to specify the static list by its name or id. To do this, select STATIC_LIST_NAME or STATIC_LIST_ID from the List param drop-down list and then enter the key value of the name or id in the List param value field.

  • LastUpdateAtSelector: Select this type to retrieve lead records that were updated on specific dates. This item is available only in the SOAP API mode.

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

Lead key type

Select a field by which you want to query the lead from the drop-down list. This list is available when:

  • getLead is selected from the Operation list, or

  • getMultipleLeads is selected from the Operation list and LeadKeySelector is selected from the Lead selector list, or

  • getLeadActivity is selected from the Operation list in the SOAP API mode.

Lead key value

Specify the value of the field by which you want to query the lead. This field is available when:

  • getLead is selected from the Operation list, or

  • getLeadActivity is selected from the Operation list in the SOAP API mode.

Lead key values

Specify the list of key values.

This field is available 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 and in the Activity table displayed, specify the types of activity you want to retrieve by clicking the [+] button to add as many rows as needed, each row for an activity type, then clicking the right side of each cell and selecting an activity type from the drop-down list. This check box is available when:

  • getLeadActivity is selected from the Operation list, or

  • getLeadChanges is selected from the Operation list in the SOAP API mode.

Set Exclude Types

Select this check box and in the Activity table displayed, specify the types of activity you do not want to retrieve by clicking the [+] button to add as many rows as needed, each row for an activity type, then clicking the right side of each cell and selecting an activity type from the drop-down list. This check box is available when:

  • getLeadActivity is selected from the Operation list, or

  • getLeadChanges is selected from the Operation list in the SOAP API mode.

Oldest update date

Specify 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 is available only in the SOAP API mode when getMultipleLeads is selected from the Operation list and LastUpdateAtSelector is selected from the Lead selector list.

Latest update date

Specify 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 is available only in the SOAP API mode 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. It supports the time format that Marketo supports.

This field is available only in the SOAP API mode when getLeadChanges is selected from the Operation list.

Latest creation date

Type in the time of the latest creation to retrieve only the data before the specified time. It supports the time format that Marketo supports.

This field is available only in the SOAP API mode when getLeadChanges is selected from the Operation list.

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

Field list

Enter the comma separated list of field names.

This field is available when getLeadChanges is selected from the Operation list in the REST API mode.

Since DateTime

Specify the timestamp used to filter results to only include leads with activity since then.

This field is available when getLeadActivity or getLeadChanges is selected from the Operation list in the REST API mode.

Action

Select the operation to be performed on the specified custom object.

  • describe: Returns the metadata regarding a given custom object.

  • list: Returns a list of custom object types available in the target instance, along with id and deduplication information for each type. With this option selected, you need to specify a comma-separated list of names to filter types in the CustomObject names field.

  • get: Retrieves a list of custom objects records based on filter and set of values.

This list is available only when CustomOjbect is selected from the Operation drop-down list.

CustomObject name

Specify the name of the custom object.

This field is available only when CustomOjbect is selected from the Operation list and describe or get is selected from the Action list.

Fetch schema

Click this button to retrieve the schema of the specified custom object.

This button is available only when CustomOjbect is selected from the Operation list and get is selected from the Action list.

Filter type

Specify the field to filter on. Searchable fields can be retrieved by performing a describe action with the custom object.

This field is available only when CustomOjbect is selected from the Operation list and get is selected from the Action list.

Filter values

Specify a comma-separated list of field values to match against.

This field is available only when CustomOjbect is selected from the Operation list and get is selected from the Action list.

Batch size

Specify the number of records to be processed in each batch.

This field is available when:

  • getMultipleLeads is selected from the Operation list and StaticListSelector or LastUpdateAtSelector is selected from the Lead Selector list.

  • getLeadActivity or getLeadChanges is selected from the Operation list.

  • CustomObject is selected from the Operation list and get is selected from the Action list.

Die on error

Select this check box to stop the execution of the Job when an 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 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 attempts

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 a start component of a Job or Subjob and it always needs an output link.