Salesforce Export and Query of Archives

  • 14Views
  • Last Post 5 days ago
  • Topic Is Solved
0
votes
System Admin posted this 5 weeks ago

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

Order By: Standard | Newest | Votes
1
votes
Dmitriy Muzurov posted this 4 weeks ago

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 6 days ago

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 5 days ago

 Hello Matthew,

 

Thank you for your reply.

 

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

 

Best regards,

Mariia

 

Close