tMarketoInput Standard properties

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.

Select the component whose connection details will be used to set up the connection to Marketo from the drop-down list.

Enter the API Endpoint URL of the Marketo Web Service. The API Endpoint URL can be found on the Marketo Admin > Web Services panel.

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.

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.

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.

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

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.

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.
• Company: This operation retrieves the company. also referred to as an account, that a person belongs to.
• Opportunity: This operation retrieves the opportunity that is associated with a lead or contact and a company.
• OpportunityRole: This operation retrieves the specific role within an opportunity.

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.

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.

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.

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, or
• getMultipleLeads is selected from the Operation list and LeadKeySelector is selected from the Lead Selector list.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

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

This field is available only when CustomObject, Company, Opportunity or OpportunityRole is selected from the Operation drop-down list.

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

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

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 CustomObject is selected from the Operation list and get is selected from the Action list.

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

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

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 the check box to stop the execution of the Job when an error occurs.

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

Enter the timeout value (in milliseconds) for the connection to the Marketo Web Service before terminating the attempt.

Enter the maximum number of reconnect attempts to the Marketo Web Service before giving up.

Enter the time period (in milliseconds) between subsequent reconnection attempts.

Select this check box to gather the Job processing metadata at the Job level as well as at each component level.

The number of calls. This is an After variable and it returns an integer.

The error message generated by the component when an error occurs. This is an After variable and it returns a string.

Usage rule

This component is usually used as a start component of a Job or subJob and it always needs an output link.