Questions
Category: Questions
Cannot get started
I want to used Skyvia Querey to add Jira data to Google Sheets. I created a Skyvia account and installed the add-on from Google Store but now I'm stuck. If I go ....
Created by
Latest by
Category: Questions
Zoho CRM synchronization
Hello, My Zoho account is located in an Australian DC. So when I try to connect my Zoho account to skyvia an "Invalid client" error is returned. For this to ....
Created by
Latest by
Category: Questions
What about date format to upload records to salesforce from CSV.
p ....
Created by
Latest by
Category: Questions
No expression editor and how to add todays date in an integration
Hi, it says in the documentation that when creating an integration I can use expression, and then click to get up an expression editor. That does not work as I ....
Created by
Latest by
Category: Questions
Replicating from Salesforce to MS Azure MS SQL Database
I am trying to replicate Salesforce data to a Microsoft Azure SQL Database. I have set up connection and target correctly as both when tested connection succeeds. However when I ....
Created by
Latest by
Category: Questions
SalesForce Query
Hi, I'm getting "You have reached a limit of queries." after I ran around 5 queries, can you please advice on what would be the issue? Regards, Sameh ....
Created by
Latest by
Category: Questions
Skyvia can help to import CSV files from Azure blob (file) storage to salesforce ?
Skyvia can help to import CSV files from Azure blob (file) storage to salesforce ? ....
Created by
Latest by
Category: Questions
Backup Files not creating -
Hi, Our invoice has suddenly stopped working since your upgrade. We have also stopped getting our data exported every night. I left a message few days ago in your ....
Created by
Latest by
Category: Questions
Update Target Values ONLY if Blank
Hi, In an update mapping, is it possible to specify to update the target value with the source value ONLY if the target value is blank? I don't want to ....
Created by
Latest by
Category: Questions
HubSpot Contacts to Microsoft Dynamics Leads Synchronization
I was able to successfully sync HubSpot contacts to Dynamics 365 contacts, but when I attempt the same synch with HubSpot contacts to Dynamics LEADS, I am returning an error ....
Created by
Latest by
Category: Questions
multiple users refreshing Google Sheets
We have a few users who all share a Google Sheet. I've just built some queries in Skyvia to pull in data from a PgAdmin database and am able to ....
Created by
Latest by
Category: Questions
Scheduling
Hi, I am creating a schedule where a) Occurs once a day at 80 AM (central time). b) Starting on 10th April 2020 at 80AM. the scheduler did not run. ....
Created by
Latest by
Category: Questions
Do you have a real time event
Hello Dear Skavia Support, My name is Iryna. We want to suggest to our client to use Skyvia. But we have one question. Do you have a real time event ....
Created by
Latest by
Category: Questions
unable to connect to the zoho people
unable to connect to the zoho people ....
Created by
Latest by
Category: Questions
Need to concatanate data types "DT_WSTR" and "DT_NTEXT"
Trying to concatanate "DT_WSTR" and "DT_NTEXT" in to a single DT_NTEXT field via an expression. but get the following error. The data types "DT_WSTR" and "DT_NTEXT" are incompatible for binary operator "+". ....
Created by
Latest by
Category: Questions
Import job with sql server as source, to get incremental (delta) data changes using LAST_RUN
After initial data sync with SQL Server as source, we are trying to use an import job to pick up delta (new/changed) data. We are comparing the dateUpdated column (datetime datatype ....
Created by
Latest by
Category: Questions
SQL source login failed for user
Hello, We had to restore our SQL database and since the restore we cannot connect to the source. Error 'Login failed for user 'xxx'. Can you explain what permissions ....
Created by
Latest by
Category: Questions
Support for Salesforce JWT Bearer Flow Connection
Do you support Salesforce connection using JWT Bearer (cert), see below connection option? https://help.salesforce.com/articleView?id=remoteaccess_oauth_jwt_flow.htm&type=5 ....
Created by
Latest by
Category: Questions
Salesforce Odata error when 'Validate External Object: DW_Customers
I am new to Odata setup within Skyvia, and need to know what this error means: EXTERNAL_OBJECT_EXCEPTION: We encountered an error while querying the external data. Contact your administrator. ....
Created by
Latest by
Category: Questions
Schedule an SQL query
Hello, We would like to schedule daily extracts from Salesforce have a couple of questions please: 1- Can we relabel the fields on the export package e.g. Field Location__c to ....
Created by
Latest by
