Retrieving inserted Salesforce Account records - 6.4

Salesforce

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

Procedure

  1. Double-click the second tSalesforceInput component to open its Basic settings view on the Component tab.
  2. Select the component that will create the Salesforce connection from the Connection Component drop-down list, tSalesforceConnection_1 in this example.
  3. Click the [...] button next to the Module Name field and in the pop-up dialog box, select the object from which data will be retrieved, Account in this example. The schema of the Account object will be automatically filled.
  4. Click the [...] button next to Edit schema and in the pop-up dialog box, remove all schema columns except the three columns Id, Name, and talendlena__Account_External_ID__c. When done, click OK to save the changes and in the pop-up dialog box, click Yes to propagate the schema to the next tLogRow component.
  5. Select Query from the Query Mode drop-down list and specify the condition used to filter data to be retrieved. In this example, it is Name like '%talend%'.

    All Salesforce Account records whose Name field contains talend will be retrieved.

  6. Double-click the third tLogRow component and on its Basic settings view, select Table in the Mode area to display the result in a table.