This scenario describes a two-component Job that collects the deleted data over the past 5 days from the Salesforce server.
Drop tSalesforceGetDeleted and tLogRow from the Palette onto the design workspace.
Connect the two components together using a Row > Main connection.
Double-click tSalesforceGetDeleted to display its Basic settings view and define the component properties.
In the Salesforce WebService URL filed, use the by-default URL of the Salesforce Web service or enter the URL you want to access.
In the Username and Password fields, enter your login and password for the Web service.
From the Module list, select the object you want to access, Account in this example.
From the Schema list, select Repository and then click the three-dot button to open a dialog box where you can select the repository schema you want to use for this component. If you have not defined your schema locally in the metadata, select Built-in from the Schema list and then click the three-dot button next to the Edit schema field to open the dialog box where you can set the schema manually.
In the Start Date and End Date fields, enter respectively the start and end dates for collecting the deleted data using the following date format: "yyyy-MM-dd HH:mm:ss". You can collect deleted data over the past 30 days. In this example, we want to recover deleted data over the past 5 days.
Double-click tLogRow to display its Basic settings view and define the component properties.
Click Sync columns to retrieve the schema from the preceding component.
In the Mode area, select Vertical to display the results in a tabular form on the console.
Press Ctrl+S to save your Job and press F6 to execute it.
Deleted data collected by the tSalesforceGetDeleted component is displayed in a tabular form on the console.