Connectors
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 ...
A Quick Guide to Importing and Updating Audience Members in Mailchimp
If your integration involves importing data into Mailchimp Audiences, this information might be helpful. To start, let’s take a quick look at how the UPSERT operation works: If the Id is specified, the integration attempts an Update operation even if ...
Mapping the RowNo Column for UPDATE/UPSERT Operations in Google Sheets
When implementing UPDATE/UPSERT operations in Google Sheets, you may need to set up mapping for the RowNo mandatory field. RowNo is a unique auto-generated row number in the Sheet. It is essential for performing UPSERT/UPDATE operations, as it ...
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 ...
NetSuite: 2FA required
Skyvia connects to NetSuite via the NetSuite API. Basic Authentication does not support accounts configured with 2FA (two-factor authentication). If your NetSuite user account has 2FA enabled, please use Token-Based Authentication to connect to ...
Freshdesk: The Limit of Freshdesk API Calls Per Hour Has Been Reached
This error occurs on the Freshdesk side, indicating that the API call limit for the hour has been exceeded. For more details on Freshdesk's API limits, refer to their API documentation. Freshdesk enforces a limit on the number of API calls that can ...
MySQL: Resolving "Lost connection to MySQL server during query" Error
To resolve the "Lost connection to MySQL server during query" error, please follow the steps below: Increase the "Command Timeout" value for your MySQL connection: Go to the Connections page and select your MySQL connection. Click Edit. In the ...
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 ...
HubSpot: 414 Request-URI Too Large & 400 Request Header or Cookie Too Large
This error occurs when the object you are querying contains too many custom fields. To resolve this issue for ContactListContacts, Contacts, and Deals objects, enable the Column-wise chunking option in the HubSpot connection editor (located under ...
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 ...