Alert for long running replications
Hi There, We need to check if an alert can be configured when replication runs for more than 2 hours.
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?
Get-token and Refresh-token in REST request
Hello, I would like to call an endpoint (url with a head like X-Token: XXXXX) But before we need to get a token To get the token we need to call an endpoint with key/secret params and that returns a token Then we should use the token in the REST request
Agent not connecting
We started getting errors that Skyvia can't connect to on premise agent we use to connect to MS-SQL. We checked the agent and see this error: What can we check on the agent? thank you chad
Integration failed: The ticket parameter is invalid.
We have an integration between Airtable and Quickbooks Desktop Enterprise. This is the error we are getting when trying to initialize the integration. It seems like it is not even starting. it runs for 5-seconds and then stops.
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?
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
PagingStrategy syntax for Laravel-style or length-aware style pagination
We are creating a rest connection to consume an API that uses Laravel-style (length-aware) pagination. The request URL should be formatted as follows: GET /fooObject?page=2&count=200 The response will include metadata about other pages { "data": [ /*
Any issues with the Pipedrive Conection?
I recently encountered a boolean error detected by Skyvia. Has anyone else experienced the same issue? Regards
Isit possible to use Skyvia to import a set (about 2500) of survey results into Survey Monkey?
To clarify, we have a survey set up in SurveyMonkey, but originally the survey was administered live by a research firm. The results have been tabulated and formatted into an excel (CSV) format but we're hoping there's a better way to get them into Surveymonkey
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
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.
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
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
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
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!
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
Incremental Replication Always Syncs 0 Rows After Initial Sync
I am using Skyvia to replicate my shipstation database into an Azure MSSQL database. This integration used to work perfectly for me, very reliably copying my new sales data every day. Recently, this integration broke and now always shows 0 rows copied
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
Next Page