Skip to main content Skip to complementary content

Deleting Salesforce Account records based on external ID

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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!