Recent Articles
Understanding Records in Skyvia Data Integration
1.1 Understanding Records in Skyvia Data Integration A record in Data Integration represents a single row in a database table. Every integration process—Import, Replication, Export, Synchronization, etc —handles individual records. Records also serve ...
Replication creates extra tables in the database
In some cases, as a result of Replication, in addition to the main tables (for example, dbo.Account ), empty additional tables are created in the database with names of the following types: dbo.Account_2ade4447_5e11_4308_9e81_5eab62d9ed52 ...
Mapping Multi-Select Fields
When working with Import, Synchronization, or Data Flow integrations and needing to map multi-select fields with different values between the source and target, you can use Expression Mapping. Expression mapping allows using simple and complex ...
Dynamics 365: Principal user is missing prvReadAccount privilege
The error message Principal user is missing prvReadAccount privilege is returned by the Dynamics 365 API. The main cause of this error is that the owner is assigned a security role other than System Administrator and lacks the necessary read-write ...
📊 Skyvia Data Flow Logs Explained: The Reason Errors and Successes Aren't Shown by Default
In Data Flow, tracking execution success or failure can be challenging due to the nature of row processing. Rows that fail in one component may succeed in another, complicating error detection. By default, Skyvia logs do not provide detailed error or ...
Popular Articles
🔒Skyvia IPs for Whitelist
Skyvia will access your server from one of the following IP addresses: 40.118.246.204 13.86.253.112 52.190.252.0 To ensure proper functionality of your connections, all of these IP addresses must be whitelisted.
BigCommerce: "The value of the column Categories has incorrect JSON format" error
When working with the Categories field in the Product object within the BigCommerce API, it's important to understand how to format and import data correctly to ensure a successful import. In the BigCommerce API, the Categories field in the Product ...
Salesforce Audit Fields: Quick Insertion Guide
To use audit fields for the INSERT operation in Skyvia, please enable the 'Create Audit Fields' permission in your Salesforce instance. More details can be found here. Below are the steps to enable the permission: Go to Setup → User Interface. Enable ...
What is a record?
The record is an element of the database. It is composed of fields and contains all the data about one particular person, company, or item in a database. Records appear as rows in database tables.
Salesforce Report exports only 2000 records
Skyvia integrates with Salesforce via its API, inheriting both its features and limitations. One key limitation is the Run Report restriction, which limits data extraction to the first 2,000 rows of a report. For more details on this limitation, we ...