Returns a list of records deleted within a specified timeframe for a given object.

Stored Procedure-Specific Information

This stored procedure retrieves a list of records that have been deleted from a specific Salesforce object within a given date range.

To get deleted Account records within a date range:

EXEC GetDeleted ObjectType = 'Account', StartDate = '2017-05-21', EndDate = '2017-06-06'

The date format should be YYYY-MM-DD.

Output columns include:

• Id - The ID of the deleted record
• DeletedDate - The timestamp when the record was deleted

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.