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

The schema of this component is predefined and it will be slightly different according to the type of the data (Leads or CustomObjects) to be imported. You can click next to Edit schema to view its schema.

• batchId: the id of the batch.

• importId (for Leads only): the id of the import.

• importTime (for CustomObjects only): the time spent on the batch.

• message: the status message of the batch.

• numOfLeadsProcessed/numOfObjectsProcessed: the number of rows processed so far.

• numOfRowsFailed: the number of rows failed so far.

• numOfRowsWithWarning: the number of rows with a warning so far.

• objectApiName (for CustomObjects only): the API name of the custom object.

• operation (for CustomObjects only): the bulk operation type.

• status: the status of the batch.

• failuresLogFile: the log for the failures.

• warningsLogFile: the log for the warnings.

Select the type of the data to be imported, either Leads or CustomObjects.

Select the type of the file containing the data to be imported, csv, tsv or ssv.

Select the lookup field that will be used for deduplication.

This property is available only when Leads is selected from the Import to drop-down list.

Specify the ID of the static list to import to.

This property is available only when Leads is selected from the Import to drop-down list.

Specify the name of the lead partition to import to.

This property is available only when Leads is selected from the Import to drop-down list.

Specify the API name of the custom object.

This property is available only when CustomObjects is selected from the Import to drop-down list.

Specify the path to the file containing the data to be imported.

Specify the amount of time (in seconds) for polling for the data.

Specify the path to the batch log file(s) to be downloaded, including the failures log file and the warnings log file.

When importing leads, the failures log file will be named bulk_leads_<batchId>_failures.csv and the warnings log file will be named bulk_leads_<batchId>_warnings.csv.

When importing custom objects, the failures log file will be named bulk_customobjects_<customObjectName>_ <batchId>_failures.csv and the warnings log file will be named bulk_customobjects_<customObjectName>_ <batchId>_warnings.csv .

Select the check box to stop the execution of the Job when an error occurs.

Specify the Marketo API mode. Note that only the REST API mode is available to use for this component.

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

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 can be used as a standalone component or as a start component of a Job or subJob.