Is there a way to query soql on skyvia with the 'ALL ROWS' clause to retrieve deleted records as well? Currently this query [SELECT External_ID__c, Name, IsDeleted, Id FROM Account WHERE IsDeleted = True ALL ROWS] gives a syntax error.
SOQL ALL ROWS
- Last Post 07 July 2022
- Topic Is Solved
Thank you for contacting us.
Skyvia has a special option for connector "Include deleted". Could you please check if you have this option enabled: Connection - Advanced Settings - Include deleted.
Include Deleted determines whether to return deleted records from recycled bin. Please note that deleted records will be returned for all the requests to Salesforce via a connection with this checkbox selected. This includes using this connection as a source connection for import, in lookups, in the Query tool, in Backup, etc. Besides, it will increase API calls use.
If it is not selected in your connection, please enable it and execute the request without the 'ALL ROWS' clause.
If you encounter any issues, feel free to contact us.