Salesforce Export and Query of Archives

  • 179Views
  • Last Post 09 August 2020
  • Topic Is Solved
0
votes
System Admin posted this 16 July 2020

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.

https://help.salesforce.com/articleView?id=000325075&language=en_US&type=1&mode=1

salesforce export query archives
Order By: Standard | Newest | Votes
1
votes
Dmitriy Muzurov posted this 17 July 2020

Hello,

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.

  • Supported by
  • System Admin
0
votes
System Admin posted this 08 August 2020

Thanks Dmitriy!

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.

Best Regards,
Matthew Reive
aka System Admin (M&S)

0
votes
Mariia Zaharova posted this 09 August 2020

 Hello Matthew,

 

Thank you for your reply.

 

The information about the "Include Deleted" option is available here.

 

Best regards,

Mariia

 

New Ticket
Categories
Popular Tags
Close