Deleting Salesforce Account records based on external ID - 7.0

Salesforce

author
Talend Documentation Team
EnrichVersion
7.0
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 first 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 whose data will be deleted, Account in this example. The schema of the Account object will be automatically filled.
  4. Click OK to save the changes and in the pop-up dialog box, click Yes to propagate the schema to the next tSalesforceOutput component.
  5. Select Query from the Query Mode drop-down list and specify the condition used to filter data to be deleted. In this example, it is talendlena__Account_External_ID__c like '%talend%'.

    All Salesforce Account records whose talendlena__Account_External_ID__c field contains talend will be deleted.

  6. Double-click the first tSalesforceOutput component to open its Basic settings view on the Component tab.
  7. Select the component that will create the Salesforce connection from the Connection Component drop-down list, tSalesforceConnection_1 in this example.
  8. Click the [...] button next to the Module Name field and in the pop-up dialog box, select the object whose data will be deleted, Account in this example.
  9. Select DELETE from the Output Action drop-down list to perform the delete operation on the Account objects filtered by the first tSalesforceInput component.