Queries and exports of data need to support access to the Salesforce archives. Some Salesforce objects have a "recency" component to their data and archive records older than X days. It would be useful to be able to access all the records in large objects ex: Tasks with an Export All (or similar) function.
Salesforce Export and Query of Archives
- Last Post 09 August 2020
- Topic Is Solved
Thank you for submitting a ticket with us.
This functionality is implemented with "Include Deleted" option. It can be enabled in Salesforce connection details.
After it is enabled, the query select id, Subject, Description, IsArchived from Task will return all records - archived and not.
Also, the filter select id, Subject, Description, IsArchived from Task WHERE IsArchived=true will return all archived records.
Should you have any questions, do not hesitate to contact us back.
Would you mind adding that crucial piece of information to your documentation on the connectors please?
It would be very helpful to highlight this consideration for future users of Skyvia.
aka System Admin (M&S)