Questions
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
Category: Questions
See sync logs
Hey, how do we see a log of modified rows / changes in prior syncs? Thanks! ....
Created by
Latest by
Category: Questions
How to Split FIRST NAME from LAST NAME
Hi, I am setting up a syncronization between zoho and mysql, and it has been challenging finding an expression to split first name from last name that the system can ....
Created by
Latest by
Category: Questions
Duplicate insert error
Hello, I want to ask about our run 34278256 We have a joint table of ContactLeads, that doesn't have a primarykey or a unique identifier, but a combined one of ContactID ....
Created by
Latest by
Category: Questions
REST Metadata
Trying to setup a source connection via REST Api using a GET request from Callrail's /calls.json endpoint and unsure what needs to be included in the Metadata field. I know ....
Created by
Latest by
Category: Questions
Target Lookup Issue
I have tried setting up this target lookup and read all of the documentation but it is not working as expected. Every way I have setup it just creates a ....
Created by
Latest by
Category: Questions
URI for Nav OData web service
Hello Skyvia and community, I am trying to setup an import integration from a MS Navision instance based on an OData web service. I am able to see the metadata ....
Created by
Latest by
Category: Questions
Expression to combine incompatible data types
I need to concatenate name and Date of Birth for one of my fields. I am getting this error: How can I format this to work? The data types ....
Created by
Latest by
Category: Questions
Payment Made - Still on trial
Hi We have made payment, but are still on the trial version for integration. ....
Created by
Category: Questions
Error: Push Order Shipments to BigCommerce
We are facing an error to map our DB table field with BigCommerce Create Shipment integration. Because, BigCommerce API request parameter "items" type is array. API reference: https://developer.bigcommerce.com/api-reference/orders/orders-api/order-shipments/createordershipments How we can ....
Created by
Latest by
Category: Questions
No data replicated Zoho CRM - MySQL DB
Good afternoon, we have tried several attempts to make a replication between Zoho CRM and our MySQL db, however the query didn't return any results. Could you please provide some ....
Created by
Latest by
Category: Questions
AWS S3 File Location not working
Hi Team, We are testing a free account to test imports from AWS S3 into our SQL Server. But when creating a connection for AWS S3 it come succesfull when ....
Created by
Latest by
