SSIS Components for Salesforce

Build 26.0.9770

GetDeleted

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

ストアドプロシージャ固有の情報

このプロシージャを実行するには、次のように入力します。
    EXEC GetDeleted ObjectType='Account', StartDate='2017-05-21', EndDate='2017-06-06'

Note: Salesforce は削除されたレコードの情報を限られた期間のみ保持します(ほとんどのエディションで通常 15 日間)。この保持期間より古いレコードは返されません。

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.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770