Questions
Category: Questions
IF Statements in Expression
Is it possible to use if statements in an Expression Mapping when doing a data import. For example: IF(Field1 = "X","AB",IF(Field2 ="Y","ABC",IF(Field3 = "Z","ABCD",A))) ....
Created by
Latest by
Category: Questions
Help With REST API Connection to QuickBooks Online
In Skyvia I'm setting up a new REST connection, choosing this as the URL: https://sandbox-quickbooks.api.intuit.com Here's the getting started for QBO for REST: https://developer.intuit.com/app/developer/qbo/docs/get-started Authentication, I'm choosing OAuth2 What do I ....
Created by
Latest by
Category: Questions
I can't import product category using csv source of Magento 2.
"ErrorDescription";"Id";"Sku";"Categories" "The value for property 'Categories' of table 'Products' is not valid. The value must have a valid JSON array format.";"3";"dot001";"2,1274,2005,2006" ....
Created by
Latest by
Category: Questions
Integration between Jira Service desk and Issue tracking tools and CRM tools
Hi this is Praveen, I like to Integrate my Jira Service desk and my partner Zen-desk, Bugzilla, Service now, etc., (Issue tracking tools and CRM Tools). where the tickets and metrics ....
Created by
Latest by
Category: Questions
Import CSV descriptions/template
Does anyone have a list of Skyvia's column/target descriptions.. I keep getting error messages but am not given (nor can I find) information on how to rectify the errors. I ....
Created by
Latest by
Category: Questions
Rest Connector Metadata Issue
Hi, I'm working on integration between SalesForce and Cloud App via REST connector. When I performed initial sync it was successful, according to history state column. Then I performed the Update operation on ....
Created by
Latest by
Category: Questions
Can I access my Skyvia Target Demo DB from Desktop SQL Client?
If so, is there documentation on how to connect? Thanks! ....
Created by
Latest by
Category: Questions
separate "last, first" values from csv
I'm trying to upsert a csv of Contacts from Cvent into Salesforce. The Contact names in the csv are formatted "last, first", and I need to separate them so they ....
Created by
Latest by
Category: Questions
Date fields query as '1-1-0001' even though data in source environment (ZOHO) displaying correctly
Hello, We are trying to integrate data from Zoho to an Azure Database. Several records keep failing due to the error 'SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and ....
Created by
Latest by
Category: Questions
Tab delimited CSV
I am trying to export to a CSV. It needs to be tab delimited. How do I change the delimiter to a tab? ....
Created by
Latest by
Category: Questions
Assembly Items not syncing
I am setting up a sync between NetSuite and MS SQL. We have several hundred assembly items in NetSuite. When I run the sync, only 19 are loaded in SQL. ....
Created by
Latest by
Category: Questions
Record Sync
this is what i get when I try to sync data from sql server to crm N:B i have granted create trigger permissions, please what do you advise ....
Created by
Latest by
Category: Questions
Data Integration
Hey, I am trying to connect Skyvia to the Tempo (Jira) Database but I can not see the tables available. Other question I have is: Why Can't I see all ....
Created by
Latest by
Category: Questions
Jira and MySQL Integration
Hi support, I created an integration to replicate data from jira to mysql. If I only select one of the Jira fields (i.e. issues), the job runs normally, but if ....
Created by
Latest by
Category: Questions
Trying to map invalid data type sql to dynamics 365
1. If I pull data from sql and exported to excel, upload it to skyvia and do upsert to dynamics 365, works fine. If I try to do it straight ....
Andy Le
Category: Questions
Import Expressions: If field = Yes, insert date
Trying to import a csv file where, if column 1 = Yes, I insert todays date into a SF date field. This isn't working: () == "Yes" ? (GETDATE) : ....
Created by
Latest by
Category: Questions
How can i filter rows before publishing using odata, with connect?
I want to publish using connect part of a table from salesforce... basically say to exclude records with a certian status. how con i do that? ....
Created by
Latest by
Category: Questions
delete
how to set query Delete ; ....
Created by
Latest by
Category: Questions
Insert failed
Error message when doing insert Account: id value of incorrect type: OIOI01;"CAD";"OIOI0101";"OIOI01";"479.52";"OIOI0101OIOI01" ....
Created by
Latest by
Category: Questions
Synchronization Integration won't allow Target to Source "Id" column synchronization
Hello there. I have successfully synced a SFDC object/table to a table in a PostgreSQL database. I added a new primary-key column (named "_id") and am able to sync records back ....
Created by
Latest by
