tMarketoListOperation
verify the existence of one or more leads in a list in Marketo.
tMarketoListOperation Standard properties
These properties are used to configure tMarketoListOperation running in the Standard Job framework.
The Standard
tMarketoListOperation 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
This property is not available when other connection component is selected |
Connection component |
Select the component whose connection details will be used |
Endpoint address |
Enter the API Endpoint URL of the Marketo Web Service. The API |
Client access ID |
Enter the client Id for the access to the Marketo Web The client Id and client secret can be found on the Marketo Admin > LaunchPoint panel, by clicking View Details for the service to be |
Secret key |
Enter the client secret for the access to the Marketo Web To enter the secret key, click the […] button next to |
Schema and Edit schema |
A schema is a row description. It defines the number of fields (columns) to
Click Sync columns to retrieve the schema from This component offers the This dynamic schema Note that the dynamic schema feature for this |
Operation |
Select an operation to be performed from the drop-down
|
Add or remove many prospects |
Select this check box to add multiple leads to or remove This check box is available only when |
Die on error |
Select the check box to stop the execution of the Job when an error Clear the check box to skip any rows on error and complete the When errors are skipped, you can collect the |
Advanced settings
API |
Select the Marketo API mode, either REST 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 |
Max reconnection attemps |
Enter the maximum number of reconnect attempts to the |
Attempt interval time |
Enter the time period (in milliseconds) between subsequent |
tStatCatcher |
Select this check box to gather the Job processing metadata at the Job level |
Global Variables
NUMBER_CALL |
The number of calls. This is an After variable and it returns an |
ERROR_MESSAGE |
The error message generated by the component when an error occurs. This |
Usage
Usage rule |
This component is usually used as an intermediate component, and it requires an |
Adding a lead record to a Marketo list using SOAP API
The following scenario describes a three-component Job that adds a lead
record into a specified list in Marketo using SOAP API.
Setting up the Job for adding a lead record to a Marketo list
-
Create a new Job and add a tFixedFlowInput component, a tMarketoListOperation component, and a tLogRow component by typing their names in the
design workspace or dropping them from Palette. -
Double-click the tMarketoListOperation component and on the
Component tab click Advanced settings to open its advanced settings view, then
select SOAP from the API Mode
drop-down list. -
Connect tFixedFlowInput to
tMarketoListOperation using a
Row > Main connection. In the pop-up dialog box, click Yes to get the schema from the target
component. -
Connect tMarketoListOperation to tLogRow using a Row >
Main connection.
Configuring the Job for adding a lead record to a Marketo list
-
Double-click the tFixedFlowInput component to open its Basic settings view.
-
Click the […] button
next to Edit schema to view its
schema. -
In the Mode area, select
Use Inline Table, and then click the
[+] button to add one row and fill
the row with respective values. In this example, these values are: MKTOLISTNAME for ListKeyType, Test_Comp_QA for ListKeyValue, IDNUM for
LeadKeyType and 9300203 for LeadKeyValue. -
Double-click the tMarketoListOperation component to open its Basic settings view.
-
In the Endpoint address
field, enter the Marketo SOAP API endpoint URL that can be found on the Marketo Admin > Web Services panel. -
In the Client Access ID and Secret key fields, enter the user ID and
encryption key required to access Marketo. -
From the Operation list,
select addTo to add the lead with the ID
9300203 into the list
Test_Comp_QA. -
Double-click the tLogRow
component to open its Basic settings
view. -
Click the Sync columns
button to synchronize the schema with the input schema. -
In the Mode area, select
Table (print values in cells of a
table) for better readability of the result.
Executing the Job to add a lead record to a Marketo list
-
Press Ctrl + S to save
the Job. -
Press F6 or click
Run on the Run tab to run the Job.As shown above, the result of the operation is displayed on the Run console.
-
Double-check the result in Marketo.
The lead with the ID 9300203 in
Marketo is added into the list Test_Comp_QA.