Connectors
Resolving the 'You can only get the first 2000 records without using page_token param' error for Notes in Zoho CRM
When backing up or importing Notes in Zoho CRM through Skyvia, you may encounter the following error: You can only get the first 2000 records without using page_token param. The Zoho CRM API imposes this limitation for Notes: A maximum of 200 records ...
Resolving the "Inactive User" Error in Skyvia Salesforce Connections
The "inactive user" error occurs at the Salesforce connection level in Skyvia. It means that the Salesforce user account used for the connection is inactive or no longer valid, so Salesforce blocks API authentication. As a result, Skyvia cannot run ...
Salesforce Error: “Query is requesting too many junction IDs; limit is 500”
What does it mean This Salesforce error occurs when a SOQL query attempts to retrieve more than 500 junction IDs in a single request. Salesforce enforces a hard API limit of 500 junction IDs per query, and once this limit is exceeded, the query ...
QuickBooks Desktop: "A modal dialog box is showing in the QuickBooks user interface. Your application cannot access QuickBooks until the user dismisses the dialog box."
Issue Description When attempting to connect a QuickBooks Desktop company file to Skyvia using Skyvia Agent, you may encounter the following error: Connection to the company could not be established. A modal dialog box is showing in the QuickBooks ...
FTP/SFTP: Troubleshooting "No such file" and "No such host is known" Errors
When using the FTP or SFTP connector, you may encounter these common errors: "No such file" and "No such host is known". Both typically occur due to access issues with your SFTP server, particularly related to IP whitelisting. 1. "No such file" - ...
Zoho CRM: Integration failed: inactive user cannot access the API error
This error message is returned by the Zoho CRM API. Skyvia connects to data sources through their APIs and therefore is subject to its features and limitations. Unfortunately, there are no additional details, as this is all the information received ...
Snowflake: Error while retrieving an access token occurred. Error type: invalid_grant. Error description: Bad Request
This error comes from your Snowflake connection because it has become invalid. By default, the refresh token is valid for 90 days. If you want to change this validity period, please ask your Snowflake account administrator to contact Snowflake ...
Salesforce: Expired access/refresh token
If you see an "expired access/refresh token" error, your Salesforce OAuth connection is invalid due to token expiration or revocation. Please open your Salesforce connection, sign in again to get a new token, and save it. Click the Test Connection ...
QuickBooks Online: Could not start QuickBooks
The "Could not start QuickBooks" error may occur if QuickBooks and the Skyvia Agent are running with different user permissions. To avoid this, make sure both applications are launched either as a regular user or as an administrator. If this does not ...
Zoho CRM: An error occurred during login operation. Error: invalid_code
If you encounter the login error An error occurred during login operation. Error: invalid_code while connecting to Zoho CRM, it means the wrong Domain is selected in your Zoho CRM connection. To resolve the issue, open your connection settings, ...
PostgreSQL: A call to SSPI failed, see internal exception
"A call to SSPI failed, see internal exception" indicates that the security protocol (SSL/TLS) used in your PostgreSQL connector does not match the version supported by your server. To resolve this, we recommend trying different SSL/TLS protocol ...
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 for 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 ...
NetSuite: SuiteTalk concurrent request limit exceeded. Request blocked.
SuiteTalk concurrent request limit exceeded. Request blocked This error occurs when the NetSuite concurrency limit (set by NetSuite) for your account is exceeded. It usually happens when too many NetSuite connection requests are running at the same ...
SQL Server: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding
The "Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding" error may occur when the command took too long to execute or the server stopped responding during the command. To resolve ...
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 ...
Marketo: Daily Quota Reached
In some cases you may encounter the "Daily Quota Reached" error. This error originates on the Marketo side and is typically caused by API limits being exceeded due to high data volume. When large objects such as Activities and Leads are processed, ...
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 ...
Connecting to Amazon RDS from Skyvia
Skyvia supports Amazon RDS databases. You can connect MySQL, PostgreSQL, or SQL Server hosted on Amazon RDS. To do so, click + Create New -> Connection -> Database, and then select the required database type. Below is useful information on how to ...
Working with Mailchimp Custom Merge Fields
In some scenarios, you can encounter difficulties with accessing custom Mailchimp fields. To access custom (merge) fields, please follow these steps: Open your Mailchimp connection and ensure that "Merge Fields Behavior" is set to "Join All Merge ...
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 ...
Salesforce API errors: TotalRequests Limit Exceeded/ApiBatchItems Limit Exceeded
The TotalRequests Limit Exceeded and ApiBatchItems Limit Exceeded errors are Salesforce-specific errors indicating that you have reached specific API limits on the Salesforce platform. Please find explanations of each error and relevant documentation ...
Brevo Attributes Field: Mapping Rules and Override Behavior
When working with Brevo contacts, the fields Attributes_FirstName, Attributes_LastName, and Attributes_Phone are provided as standalone fields for convenience, as they are universal to all users. However, for adding or updating custom fields, you ...
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: Go to the Connections page and select your MySQL connection. Click Edit. In the Connection Editor, go to Advanced, then increase or set to 0 the ...
Skyvia Backup Errors Caused by Salesforce API Requirements
Skyvia interacts with Salesforce via its API. During a backup operation, you may encounter errors due to certain limitations or behaviors specific to the Salesforce API. For example, when Skyvia performs a backup or replication, it queries all 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 ...
ActiveCampaign: Exporting Contact Data with Custom Field using ContactCustomFieldValues table
You can export contacts with a specific custom field value to a CSV file using the Advanced Task Editor Mode in a Skyvia Export integration. Steps Create a new Export integration. Open it and switch to Advanced Task Editor Mode. Add an Execute ...
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 ...
BigQuery: Does not have storage.buckets.get access to bucket default
This issue stems from limitations in Google BigQuery and occur because the default Cloud Storage Bucket is used in your BigQuery connection. Note, the default bucket is not suitable for operations conducted via the BigQuery API. Please try creating ...
HubSpot: hapikey Permission Error
This issue is common when working with HubSpot. It typically occurs for the following reasons: The customer does not have access to the Marketing or CRM portal due to HubSpot subscription limitations and is limited to the Developer portal. The ...