Skyvia interacts with Salesforce via its API. During a backup or replication operation, you may encounter errors caused by certain limitations or behaviors specific to the Salesforce API.
When Skyvia performs a backup or replication, it queries all data from Salesforce using a SELECT query. However, some Salesforce objects require a WHERE condition in the query. A simple SELECT * FROM Table is not valid for these objects.
These objects require specific filter conditions. The error message typically includes details about the required filters. Common examples:
| Object | Required Filter |
|---|---|
FlowVariableView | Filter on a reified column is required: [FlowVersionViewId, DurableId] |
ContentFolderItem | Filter by Id or ParentContentFolderId using equals or IN operator |
| Access-level objects | Can select only RecordId, a Has*Access field, and MaxAccessLevel |
FlexQueueItem | WHERE clause must contain a JobType field expression |
For additional context, see How to query FieldDefinition records on Salesforce StackExchange.
Objects with such restrictions are generally system tables that contain metadata about other objects, columns, or service information, not user data. Each object has its own specific filter requirements, and most filters are based on specific ID values. For this reason, Skyvia cannot add these filters automatically.
Note: These tables are typically read-only and cannot be used in a restore operation.