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
Two-Way Sync for WooCommerce Products and Form Submissions with HubSpot
Hello Dears, I have a question regarding the WooCommerce-HubSpot integration. Is there any way I can manage WooCommerce product data from HubSpot CRM? Are there any plugins or custom code options available for this? Additionally, I need to store all form
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
Handling of Null or blanks during import
It appears that Skyvia is replacing content when a null or blank field is imported. Is there a setting that will allow us to ignore null values during imports, leaving any existing values in the destination unchanged?
Skyvia integrations + terraform
Is there a way to terraform the integrations in the skyvia?
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.
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":
Support for writing to Parquet file in Azure
Is this provided as a native connector or easy to accomplish? Appreciate the guidance.
Problem with data storage in REST connector: metadata
Dear Community Team, I want to report an issue related to the REST connector in Skyvia. We have followed the instructions provided in the official documentation and research sources available on the internet, however, we have identified that the data
Integration failed: A task was canceled. [Code: RC_03]
Hi, We have had an increase in the number of jobs that fail with error: Integration failed: A task was canceled. [Code: RC_03] This integration pulls data from our on premise MS-SQL server and updates the contact table in Hubspot. Are you able to see
Support for Geography Datatypes
Are there any plans to support geography datatypes and the related functions such as stdistance?
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"
Default changes entity set name
We have several data source tables from our SQL Server database that Skyvia, by default, is renaming the entity set name by adding an 's' at the end (which I found out recently in the documentation). Some of our source table names are long, so I didn't
version control for endpoints
Is there any way to do version control for endpoints? It would be helpful to see when changes were made to an endpoint other than the last modified date (and even more helpful if we could rollback to a previous version!).
Setting a variable in a control flow to a newly created ID
I have a Control Flow that starts with an Action which inserts a row into a SQL Server table, which then returns the ID of the newly created row. The output of the Action is as follows. action_8 { #ImportID } I simply want to store that ID into a variable
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
Time Tracking table not shown
Hi, i am fetching QuickBooks data through Skyvia and moved it Azure layer. around 53 tables have been moved. i want to see employee working hours and rates but in all these tables no such data is available. on investigation, it is observed that this data
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
Update Asana Custom Task fields using SkyVia
I've created a simple customization to create and update Netsuite Support cases from Asana Tasks. It also closes Asana tasks when an associated case is closed in Netsuite. I need to update a custom task field in Asana but TaskCustomFields and CustomFields
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?
Moving an Integration to a different workspace
We are trying to organize our integrations. How do we move existing Integrations to a new Workspace?
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
No records after import
Hi all, new to Skyvia and have just set up my first integration and got a success message however, the import did hit my 10k record limit, but the target table has no records within it. So can't actually test if it has actually worked to see if it is
Issue with SalesForce Upsert
We continuously are getting the below error message. Do you have a solution? Automation failed: action_2: To be able to 'UPSERT' records one of the columns should be marked as 'ExternalId'.
Uploading attachments in Saleforce
Hi, Can Skyvia upload attachment files into Salesforce? I have a few thousand PDF files. Each file is named with the ID of a Contact record. I would like to upload the PDFs as attachments to these records. Does Skyvia support this type of upload? thank
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
Monday connection issue
Hello, I was just trying to modify our monday.com integrations, but I am getting the following error. Could you please check. Can you please analyse and solve the problem. Thanks!
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 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,
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
HubSpot EmailEvents API where clause
Thank you. I can work with that. One other question. I changed my Query to this and it comes back quickly: SELECT t.* FROM EmailEvents AS t where (t.CreatedAt > '2024-06-10 12:13:00' and t.type = 'SENT' ) But, if I add one more filter condition below,
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?
Integration failed: GetResults failed: There is an error in XML document (2, 18127)
Skyvi I am receiving an error that I do not understand. Can someone help? This integration imports MySQL data to Salesforce and I have countless similar working integrations.
Chain control flows?
Hi, Is it possible to chain control flows? I have two control flows, Control Flow A and Control Flow B. When Control Flow A finishes, I would like it to start Control Flow B? Is that possible? I know I could just combine them into one large control flow,
Quickbooks Integrations Fails
Hello, We are getting this error: "Integration failed: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached." Please
Clone a Task in an Import Integration
is there any way to Clone a Task in an Import Integration? It would be great to be able to do that if mappings are the same and you need to run a Task more than once based on criteria.
Oracle data intergrate to Airtable
Hi, I'm planning to update Oracle data to Airtable, but it appears that SKYVIA captures InternalId as a key variable. However, we can't find InternalId in Airtable; we only have the record ID. Is there a way we can change the key variable from InternalId
Bootstrap Responsive Grid System Issue: Seeking Solutions
I'm experimenting with Bootstrap to create a responsive grid system on my webpage, but it seems like something is amiss. The columns are not behaving as expected, and I can't quite put my finger on the issue. This is my code <!DOCTYPE html> <html lang="en">
All scheduled integrations have become disabled
For some reason, I noticed that all of my scheduled integrations stopped running on April 24th, and are not set as disabled. What happened? How do I restore the scheduled runs?
import
When My CSV file goes into FileZilla and I have to automatically show that file in skyvia. How can I show those files in skyvia? and I have to create automation for that
Next Page