SOQL ALL ROWS

  • 40Views
  • Last Post 07 July 2022
  • Topic Is Solved
0
votes
noh stv posted this 07 July 2022

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.

all-rows soql
1
votes
Yevheniia Bilotserkovska posted this 07 July 2022

Hello,

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.

Best regards,

Yevheniia Bilotserkovska.

  • Supported by
  • noh stv
New Ticket
Categories
Popular Tags
Close