GetDeleted
Returns a list of records deleted within a specified timeframe for a given object.
Stored Procedure-Specific Information
To execute this procedure, enter:EXEC GetDeleted ObjectType='Account', StartDate='2017-05-21', EndDate='2017-06-06'
Note: Salesforce retains deleted record information for a limited time (typically 15 days for most editions). Records older than this retention period will not be returned.
Input
| Name | Type | Description |
| ObjectType | String | API name of the Salesforce object to query for deleted records, such as Account, Contact, or Opportunity. Must be a valid object in your organization. |
| StartDate | String | Start of the time window (in UTC) for retrieving deleted records. The seconds portion is ignored by the API. |
| EndDate | String | End of the time window (in UTC) for retrieving deleted records. The seconds portion is ignored by the API. |
Result Set Columns
| Name | Type | Description |
| Id | String | ID of each record that was deleted within the specified time range. |
| DeletedDate | String | Timestamp (in UTC) of when each corresponding record was deleted. |