GetUpdated
Returns a list of records updated within a specified timeframe for a given object.
Stored Procedure-Specific Information
To execute this procedure, enter:EXEC GetUpdated ObjectType='Account', StartDate='2017-05-21', EndDate='2017-06-06'
Note: This procedure returns IDs of records that were created or modified during the specified time period. To retrieve the full record details, use a SELECT query with these IDs.
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. |