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"
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
Salesforce query takes forever
Hi everyone, I have a very simple query from SF (20 objects, about 20 fields, all exported to the .csv file on FTP). When this query is run in the background, it takes a fraction of a second to complete. However, when I run the same query from the Skyvia
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
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
Hubspot query subscription preferences
Hi, I would like to download subscription preferences from HubSpot. I believe this is the API https://developers.hubspot.com/docs/api/marketing-api/subscriptions-preferences I don't see this object in the list when I create a query. Is it possible to
When I run a simple query count(*) - why does it take so long to return a value
When I run a simple sql query - why does it take so long?
No rows are returned
I am trying to execute this query from Skyvia connected to Salesforce. It should return rows (when I execute it inside Salesforce , there are relevant records), but when I execute it inside Skyvia, no rows are returned. The issue seems to be with the
Data Extract from Dynamics
Hi Team, I’ve been trying to extract the email data from Dynamics using export module on Skyvia but getting the below error. I do get the same error even when I try to extract the data for last 6 months as well. Package link: https://app.skyvia.com/#/150481/packages/226010
Slow query
Slow query. Why is the query below taking so long? This slows down the Data Flow. When looking at the package you will see that the speed is faster select sim.opportunityid,sim.csh_origem,sim.csh_mktcanal,sim.csh_term,sim.csh_mktcampanha,sim.csh_urlcampanha
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?
In-Browser SQL Client with Visual Query Builder
Discussion forums for open issues and questions regarding Skyvia Query Builder