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

Stored Procedure-Specific Information

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

To get updated Account records within a date range:

EXEC GetUpdated 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 updated record

Note: This procedure returns IDs of records that were created or modified during the specified time period. Use a SELECT query with these IDs to retrieve the full record details.

Input

Name	Type	Description
ObjectType	String	API name of the Salesforce object to retrieve updated records for, such as Account, Contact, or Opportunity. Must be valid in your Salesforce org.
StartDate	String	Start of the time window (in UTC) for retrieving updated records. The API ignores seconds in the timestamp.
EndDate	String	End of the time window (in UTC) for retrieving updated records. The API ignores seconds in the timestamp.

Result Set Columns

Name	Type	Description
Id	String	ID of each record that was updated within the specified time range.