• The Salesforce API Does Not Routinely Return Archived and Delete Records
• How to Include Archived and Deleted Records

The Salesforce API Does Not Routinely Return Archived and Delete Records

Normally, the Salesforce API does not return archived and deleted records as part of the result of a query.

How to Include Archived and Deleted Records

If you want to include archived and deleted records, add the _QueryAll suffix to the table name. For example, the following query retrieves only the task records that have been archived:

SELECT * FROM SALESFORCE_LS.CData.Salesforce.Task_QueryAll  
where IsArchived = 'true'

You can also replicate all records including archived and task records to a local table by using the SF_ReplicateIAD stored procedure.