Questions
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
Category: Questions
Mapping NetSuite Custom Fields
How do I map custom fields from NetSuite to SQL? For example we have many custom fields on the NetSuite Customer. When I map the NetSuite Customer to SQL, I only ....
Created by
Latest by
Category: Questions
DELETE ACCOUNT CANCEL SUBSCRIPTION
Hi! At this moment I want to delete my account because the backup service is no longer necessary. I await the opt-out confirmation. ACCOUNT: nina.s@germanonlineinstitute.com Thank you ....
Created by
Latest by
Category: Questions
Error query salesorder
Hello I am consulting a table of the connection "woOw" the table "sales order", but I am getting an error in the query could you help me, please Server ....
Created by
Latest by
Category: Questions
Pipedrive custom fields
We have several custom fields in our Pipedrive instance. One of which is "Distribution List" which is under People. However, I'm not able to find that field with data in ....
Created by
Latest by
