Scenario: Adding a lead record to a Marketo list using SOAP API - 6.3

Talend Open Studio for Big Data Components Reference Guide

EnrichVersion
6.3
EnrichProdName
Talend Open Studio for Big Data
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

The following scenario describes a three-component Job that adds a lead record into a specified list in the Marketo database using SOAP API.

Setting up the Job

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

  2. Double-click the tMarketoListOperation component to open its Basic settings view on the Component tab, and in the API Mode area make sure the SOAP API mode is selected.

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

  4. Connect tMarketoListOperation to tLogRow using a Row > Main connection.

Configuring the components

  1. Double-click the tFixedFlowInput component to open its Basic settings view.

  2. Click the [...] button next to Edit schema to view its schema.

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

  4. Double-click the tMarketoListOperation component to open its Basic settings view.

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

  6. From the Operation list, select addTo to add the lead with the ID 9300203 into the list Test_Comp_QA.

  7. Double-click the tLogRow component to open its Basic settings view.

  8. Click the Sync columns button to synchronize the schema with the input schema.

  9. In the Mode area, select Table (print values in cells of a table) for better readability of the result.

Saving and executing the Job

  1. Press Ctrl + S to save the Job.

  2. Press F6 or click Run on the Run tab to run the Job.