Connectors
HubSpot: value was not recognized as a valid DataType errors in Skyvia
Overview Type conversion errors occur when a value stored in a field does not match the current data type definition. Typical error format: '<value>' was not recognized as a valid <DataType> These errors are generated when the source system returns ...
AADSTS650052 Error When Connecting to Dynamics 365 Business Central
Overview When connecting to Microsoft Dynamics 365 Business Central in Skyvia, you may encounter the following error: AADSTS650052: The app is trying to access a service '00000015-0000-0000-c000-000000000000' (Microsoft Dynamics ERP) that your ...
QuickBooks Online: The name supplied already exists error
Overview The error "The name supplied already exists. Another customer, vendor, or employee is already using this name" is a limitation returned directly from QuickBooks. It occurs when the Display Name you are trying to create already exists in ...
SFTP/FTP: Common Errors and Troubleshooting
Overview When using the FTP or SFTP connector in Skyvia, you may encounter various errors due to connection misconfiguration or server access issues. Below are the most common errors, their likely causes, and steps to resolve them. 1. Invalid Private ...
Google Sheets: Internal error encountered. Error code: 500
Overview The error "Internal error encountered. Error code: 500" is returned by the Google Sheets API and is typically caused by processing a large volume of data in a single request. Resolution To resolve this issue, reduce the Batch Size value in ...
Zoho CRM: You can only get the first 2000 records error for Notes
Overview When backing up or exporting Notes from Zoho CRM through Skyvia, you may encounter the following error: You can only get the first 2000 records without using page_token param. Why This Happens The Zoho CRM API imposes the following ...
Salesforce: Inactive User Error
Overview 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 ...
Salesforce Error: "Query is requesting too many junction IDs; limit is 500"
What Does This Error 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 ...
QuickBooks Desktop: Modal Dialog Box Error
Overview 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 user ...
Zoho CRM: Inactive User Cannot Access the API Error
Overview This error is returned by the Zoho CRM API. Skyvia connects to data sources through their APIs and is therefore subject to their features and limitations. Unfortunately, there are no additional details available beyond what the Zoho CRM API ...
Snowflake: invalid_grant Access Token Error
Overview This error comes from your Snowflake connection because it has become invalid. By default, the Snowflake OAuth refresh token is valid for 90 days. Once it expires, the connection can no longer authenticate and returns the invalid_grant ...
UPDATED: Salesforce: Expired access/refresh token
Overview If you see an "expired access/refresh token" error, your Salesforce OAuth connection is invalid. This happens when the token has expired, been revoked, or invalidated by a Salesforce security policy change. Possible Causes The OAuth token ...
QuickBooks Online: Could not start QuickBooks
Overview The "Could not start QuickBooks" error may occur when using QuickBooks Online via Skyvia Agent if QuickBooks and the Skyvia Agent are running with different user permission levels. Resolution Ensure that both QuickBooks and Skyvia Agent are ...
Zoho CRM: invalid_code Login Error
Overview If you encounter the error "An error occurred during login operation. Error: invalid_code" while connecting to Zoho CRM in Skyvia, it means the wrong Domain is selected in your Zoho CRM connection settings. Resolution Open your Zoho CRM ...
PostgreSQL: A call to SSPI failed, see internal exception
Overview The error "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. Resolution Try different SSL/TLS protocol ...
Dynamics 365: Principal user is missing prvReadAccount privilege
Overview The error Principal user is missing prvReadAccount privilege is returned by the Dynamics 365 API. It indicates that the user account used for the Skyvia connection lacks the required read-write privileges for one or more entities. Root ...
A Quick Guide to Importing and Updating Audience Members in Mailchimp
Overview This article explains how to configure an UPSERT operation for the Mailchimp ListMembers object in Skyvia. This is the recommended approach for importing and updating Audience members without creating duplicates. How UPSERT Works for ...
Mapping the RowNo Column for UPDATE/UPSERT Operations in Google Sheets
Overview When performing UPDATE or UPSERT operations on Google Sheets data in Skyvia, the RowNo field is mandatory. RowNo is a unique auto-generated row number assigned to each row in the sheet. Skyvia uses it to identify which row to update. Without ...
NetSuite: SuiteTalk concurrent request limit exceeded. Request blocked.
Overview SuiteTalk concurrent request limit exceeded. Request blocked. This error occurs when the NetSuite concurrency limit for your account is exceeded. It usually happens when too many NetSuite connection requests are running at the same time. For ...
SQL Server: Execution Timeout Expired
Overview The error Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding occurs when a SQL Server command takes longer to execute than the configured timeout limit allows. This is ...
Salesforce Report exports only 2000 records
Overview When using Salesforce Reports as a data source in Skyvia, the export is limited to the first 2,000 rows. This is not a Skyvia limitation — it is a hard restriction imposed by the Salesforce Run Report API, which Skyvia uses to retrieve ...
Marketo: Daily Quota Reached
Overview 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 ...
NetSuite: 2FA required
Overview 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, you must use Token-Based Authentication (TBA) to ...
Connecting to Amazon RDS from Skyvia
Overview Skyvia supports Amazon RDS databases. You can connect MySQL, PostgreSQL, or SQL Server hosted on Amazon RDS to Skyvia. To create a connection, go to + Create New → Connection → Database and select the required database type. Before ...
Working with Mailchimp Custom Merge Fields
Overview In some scenarios, you may encounter difficulties accessing custom Mailchimp fields in Skyvia. This article explains how to configure the Merge Fields Behavior setting to make custom (merge) fields available in your integration. Steps to ...
Freshdesk: The Limit of Freshdesk API Calls Per Hour Has Been Reached
Overview This error occurs on the Freshdesk side and indicates that the hourly API call limit has been exceeded. Skyvia interacts with Freshdesk via its API, and depending on the API version and object type, a large number of API calls may be ...
Salesforce API errors: TotalRequests Limit Exceeded / ApiBatchItems Limit Exceeded
Overview The TotalRequests Limit Exceeded and ApiBatchItems Limit Exceeded errors are Salesforce-side governor limits. They are not related to Skyvia's own limits. When these limits are reached, Salesforce rejects all further API calls until the ...
Brevo Attributes Field: Mapping Rules and Override Behavior
Overview 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 ...
MySQL: Lost connection to MySQL server during query
Overview The error Lost connection to MySQL server during query occurs when the connection between Skyvia and the MySQL server is dropped while a command is being executed. This typically happens when processing large datasets or when server-side ...
Salesforce Audit Fields: Quick Insertion Guide
Overview Audit fields in Salesforce (such as CreatedDate, CreatedById, LastModifiedDate, LastModifiedById) are system fields that track when and by whom a record was created or modified. By default, these fields are read-only and cannot be set during ...
ActiveCampaign: Exporting Contact Custom Field Values
Overview You can export ActiveCampaign 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 ...
HubSpot: 414 Request-URI Too Large / 400 Request Header or Cookie Too Large
Overview The errors 414 Request-URI Too Large and 400 Request Header or Cookie Too Large are returned by the HubSpot API when a single API request exceeds the maximum allowed size. This typically occurs when querying HubSpot objects that have a large ...
BigCommerce: The value of the column Categories has incorrect JSON format
Overview When working with the Categories field in the Product object within the BigCommerce API, it is important to format the data correctly to ensure a successful import. In the BigCommerce API, the Categories field is an array. For more ...
BigQuery: Does not have storage.buckets.get access to bucket default
Overview This error occurs because the default Cloud Storage bucket is used in your BigQuery connection. The default bucket is not suitable for operations conducted via the BigQuery API. Resolution Create a dedicated Cloud Storage bucket and ...
HubSpot: hapikey Permission Error
Overview This error is common when working with HubSpot and indicates that the API key (hapikey) used for authentication does not have sufficient permissions to access one or more HubSpot objects. Root Causes The error typically occurs for one of the ...