Simply connect to any source
Discussion forums for open issues and questions regarding Skyvia Connectors
How to use REST Connector?
I'm trying to use the REST Connector, and I'm having some trouble. There are no examples in the Gallery and it's the only connector that doesn't have a page in the docs: https://docs.skyvia.com/connectors/ I have a URL that I would like to POST data to,
Is there a way to move or clone an object from one Workspace to another?
We have a production and a sandbox workspace. I would like to be able to copy an object from one to the other. Is this possible?
Queue Times Inceasing?
I've noticed job time in queue increasingly lately. Is this something the Skyvia team is aware of? Has anything changed in capacity or prioritization?
How do I populate a custom field with a column from a database?
I have connections to Jira and the database but can't seem to find the documentation on how to do this. Any help is much appreciated!
SFTP file masking capabilities
I recently had the requirement of processing a csv file from an SFTP source with Skyvia and when I attempted to grab the file using a file mask, I was unable to create a mask that could grab the file by date and ignore the irrelevant part of the filename.
Skyvia integrations + terraform
Is there a way to terraform the integrations in the skyvia?
Can't sign in with Salesforce
My main account uses Salesforce to sign in however, every time I try I keep receiving an error like this one: Authorization Error - Skyvia User with same name exist Request Id: 462455d9-3d3d-40c9-bb79-707040a8e00a I also tried signing in on a different
Integration failed: Invalid number of output records.
When attempting to replicate from saleforce we receive the following error message after it "runs". For context, everything was functioning fine before yesterday. Integration failed: Invalid number of output records. Appreciate it.
Skyvia Agent for QuickBooks Desktop Connector
We have QuickBooks Desktop installed on a hosted server accessible with Remote Desktop. We want to use Skyvia to connect QuickBooks with Google BigQuery. We installed the Skyvia Agent on the server, but it only connects to the Skyvia Dashboard when someone
Zoho Desk Automation Rerun
Hi, i'm new with automation. I would like to know if it is possible to restart an execution if it fails. best regards marco
Adding Date to Export Task File Name
Is there anyway to add the date that an export is run on an export task with a custom filename? For example: TLMHouseFile{DDmmYYYY}.csv Would produce TLMHouseFile05032024 if I ran it today?
Assistance with Downloading Devart ODBC Driver for Skyvia
Hello, I am attempting to connect to my Skyvia SQL endpoint via ODBC, and I have been advised to use the Devart ODBC Driver for Skyvia for optimal compatibility. However, I am unable to locate a download link for this specific driver. Could you please
How to Auto-Generate a SQL Schema from QuickBooks Online Data Using Skyvia?
I'm looking for a way to automatically create a SQL database schema based on my QuickBooks Online (QBO) data. I plan to use Skyvia to load the data into my SQL database. The goal is to have a schema that includes all fields from the QBO data, organized
Capsule CRM Custom Field Values in Query Builder?
I'm attempting to use Skyvia to create a report from Capsule CRM based on Capsule Party (Contact) Custom fields. Is it possible to access Capsules Custom fields in Skyvia's Query Builder? In Capsule I have a DataTag on Parties (People) called "Course"
Import Hubspot associated object
Hi, In Hubspot, we created a custom object that has a 1-Many relationship back to Contact. (1 custom object record ties to 1 Contact. 1 Contact can tie to many custom object records) I am trying to setup an import in Skyvia but I do not see where I can
Multiple Agents instances need on same Database Server
I am trying to replicate Quickbooks Online from three (3) company files to a single MySQL database. Each of the QB connections is in its own Workspace so I have three (3) Agent Keys for the same MySQL machine. Is there a way to pass the Key for each of
Google Analytics with Yellowfin BI application integration
Hello There, i want to integrate Google Analytics with the Yellowfin Bi application through Skyvia, can you please send a detailed document?
How to Incrementally Update SQL Database from QuickBooks Online via Skyvia?
I'm using Skyvia to load data from QuickBooks Online (QBO) into a SQL database. However, I want to avoid reloading all the data each time. Instead, I want to incrementally update my SQL database by only bringing in new records and updating existing ones,
Technical feasibility of bi-directional sync JIRA(JSM and JWM) <-> ASANA
The goal of this question is: To validate whether this is possible with Skyvia If it is possible, has anyone here tried to do something like this or do you have any recommendations to point me in the right direction in terms o the approach? Im new to
Add Views to ODATA End Point Model
Hi All, I am able to see the SQL Views in my ODATA ENd point Model but when I try to sync this to salesforce I get an error since view doesnot have a primary key. Is there any solution out there that will help us sync views into salesforce using Skyvia
Support for writing to Parquet file in Azure
Is this provided as a native connector or easy to accomplish? Appreciate the guidance.
Amplitude query running for long periods of time with no output
Hi, I have written a query to pull data from Amplitude, but the task runs for a long time and produces no output - here is the url of the export task: https://app.skyvia.com/#/151008/packages/228237 Does the query in the task look okay in your opinion?
Moving an Integration to a different workspace
We are trying to organize our integrations. How do we move existing Integrations to a new Workspace?
HubSpot backup issue with URI length
Hello Support. We received an email notifying us of an error in a backup job. Looking at the control panel, it is a HubSpot backup job of all our records inside HubSpot. The actual error, as reported by your program, for "Contacts", is: (414) URI Too
Syncing Issue, Need argent help.
I'm connecting hubspot and airtable. I have a dropdown multiple select field in hubspot and trying to sync that in airtables multiple select column. It's not syncing, maybe it's issue with data type, Airtable is aspecting Array but HS giving text in "Val1;
Converting Date 14/12/2023 00:00:00 to YYYY-MM-DD format
Hi Team, I am getting the date as 14/12/2023 00:00:00, but my target system expects the date in YYYY-MM-DD format. is there a way/function in which we can convert the date in required format. I tries using date_format function but it is not giving me
Airtable Repliaction Set Up Error: Cannot access child value on Newtonsoft.Json.Linq.JValue
Hi there, I am trying to create a replication using an Airtable connector as my source, but am getting the below error when trying to add the Airtable connector: Cannot access child value on Newtonsoft.Json.Linq.JValue https://gyazo.com/40b64b7b4ab0cb6ca96571499d5df398
Hubspot: Update by custom primary key
Hi, Is it possible to update a record in a Hubspot custom object without using the Hubspot Id? I have a unique key in my source system and would like to save that field in Hubspot and have my UPSERTs use that key? Does anyone know if that is possible?
External Id not visible in drop down
I'm able to see the External Ids in my target salesforce org but when I'm using upsert operation in data flow I'm not able to see those External Ids in the drop down. So, why is this happening can you please help and make sure that all the external ids
Query HubSpot by date
Hi, How can I query HubSpot by date? I would like to do the equivalent of the SQL below but I don't know how to do the date comparison. SELECT t.Id FROM Contacts AS t WHERE t.UpdatedAt > getdate()-1
facing some problems since 1 of november.
I am facing some problems since 1 of November. some processes start to take more time. some they don't finished, i have to force stop. I am talking process spent 30 or 40 hours and now, passed 90, 120 hours the process is not done. Some process i have
Jotform Connection - Error
Hi, I'm trying to connect to Jotform and have followed the instructions of gathering the API key. When I test the connection, I get this error: Can I get insight into what changes need to be made to clear this error? I don't see additional options in
Hubspot Matching import (Deal-Contact) with Tags
Hello, we want to import further Deal Information into Hubspot, such as Main User an Co User. At the moment we can only do a simple Mapping of the Deal to Contact table but it would be great if we could do a second integration where we can import the
error connecting to datasource using odbc
hi, I'm trying to connect looker datastudio to a database called ocient using the ODBC driver but I'm getting this error, any idea what this meant? An invalid connection string attribute was specified (failed to decrypt cipher text)
Possible to retrieve attachments stored in Quickbooks Online?
Hi. I'm assuming the answer is no, but thought I would double check. While we retrieve information on attached files in QBO during replication, is there any way for Skyvia to retrieve the actual files that go with the attachment data? I thought I saw
Passing a URL parameter while using Rest connector - or modifiying URL dynamicly
Hi everyone, We need to make a rest connection with while using date dynamic range on the URL: It looks like this : https:/.../GetLoansByTimestamp/01-20-2025/01-23-2025. This part is static "https:/.../GetLoansByTimestamp/" so we can manage with the "Metadata":
Skyvia backup instance
Hi, We use skyvia ODATA connection with salesforce and thats core part of our 24 hour operating business. We are worried about a "what if skyvia goes down" scenario, since it would halt our operations completely. Does Skyvia have different server instances,
SFTP - rename or move file after import or export
With the SFTP connector, Is it possible to rename a file or move files to an archive folder after an import or export?
Loading a new CSV Daily
Hi, I'm trying to create a job to take a CSV from my Google Drive and drop it into Salesforce. This file is replaced every day as we get fresh data. Is there any way to setup a job that checks for a file by name instead unique file ID? Every time the
Next Page