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?
Job remain in queued status and not run
Sorry, but from two hours job non running, stay only in queued for many time bat never run. Can you verify please? this is the url: https://app.skyvia.com/#/84089/packages/151002/debug
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
Reset Sync Time Problem
Hi team, we’ve encountered a critical issue regarding our recent connection update. Upon updating, the sync timestamps were reset without any prior notification or warning prompt. Consequently, the next trigger initiated a full replication across several
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 Import Duration for One record
Hello Team, Can you please clarify the duration time for one record when import using integration from Oracle to Skyvia. It will take around 5 to 7 min for one record from oracle to skyvia.
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.
Quickbooks
Good day, there is a profit and loss details and profit and loss tables in the QuickBooks desktop database, but the Skyvia connector does not see them. Can you help with fixing or pulling those tables
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?
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?
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": [ /*
Accessing Quickbook's ProfitAndLoss Report
I am just realizing that Skyvia can't directly access the ProfitAndLoss report from Quickbooks. I need to extract this from Quickbooks and drop it into a SQL server. Has anyone created a workaround for this?
Any issues with the Pipedrive Conection?
I recently encountered a boolean error detected by Skyvia. Has anyone else experienced the same issue? Regards
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":
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.
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
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
Next Page