Add Go High Level to Skyvia integrations
With more and more people leaving Active Campaign because of their pricing shenanigans, it would be great to have GHL as an integration option in Skyvia.
Integrations with Salesforce in Queued very long time
All of our Salesforce integations appear to be taking a very long time today. They are in "Queued" for up to an hour before running. Once running they seem to complete as expected. Are there system-wide issues today? Anyone else experiencing these i
Salesforce - Mailchimp integration - "requested resource could not be found"
I am importing from Salesforce and connecting to Mailchimp. All the fields that were mapped showed up correctly in the log. However, the import was unsuccessful because of the following error: "The requested resource could not be found." What is the requested
Monday.com time outs
Hi, we regularly have the problem that individual objects in our Monday.com integration are not exported to the database due to time outs. Would it be possible to automatically restart the replication for the objects with time out? Best Dominic
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
Dataflow Errors
I have over 100+ errors when I open the dataflow because expressions like isnull("Record ID") give an error. When I open/edit the expression, the error goes away. Again on refreshing the page, the errors show up. The data flow is not working. It takes
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
View Quickbooks Desktop custom fields in Skyvia
Hello: I have a Custom field in the Customers table of my Quickbooks Desktop file, but I cannot see this field when querying this table from Skyvia. What could be the problem? Regards
Unintended bidirectional sync between MSSQL and Shopify using constant mapping
I can't achieve a one-way synchronization using the constant mapping. Any help or suggestion is greatly appreciated. Setup: Source: MSSQL products table Target: Shopify products Sync Field: A field named Sync in the MSSQL table, set to True for all rows.
Email Notification when throwing error in control flow
Hi, I have a control flow that doesn't send an email when I force an error to throw. I have a master control flow that calls two sub control flows. The sub control flows are each wrapped in Try/Catch. At the end of my master control flow, I check for
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!
Slow Data Flow
Why did the package below take longer than 2 hours? it's a simple update. https://app.skyvia.com/#/76069/packages/219228 Run Id: 138180829 Duration: 2 h 9 min 30 sec
Hubspot Associations
How do I get the Hubspot Associations tables for Custom Objects to show in the list of available tables?
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,
Session expired or invalid
We are once again running into the below error on a regular basis. I had a ticket about this a while back which turned out to be an issue with the sftp Time to Live (TTL) settings on your end. After my last ticket, it worked a little better but we've
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
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?
Large Salesforce data flows hitting bulk api limits
I've recently been working on some rather large Salesforce imports and have been running into bulk api limits that I'm not sure what to do about. Aside from a few lookups and lot of data, it's a pretty typical import but after multiple hours of processing
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
Monday.com Integration broken
Since yesterday all our monday.com integrations do not work anymore. We are getting error "An item with the same key has already been added." In the connection section, the connection test is successful. However, in the integration section I cannot make
Integration time
Good evening. Currently I have the integration 258381 which replicates information from a table that only has 3 fields; currently I'm using an integer ID to load the data, which is too much, however is taking a lot of time every time I execute the process.
Not able to use External Id of an Account on Contact Upsert through Data Flow
Hi I am not able to use External Id of an Account on Contact Upsert through Data Flow Object 'Contact' does not have field 'Account.Legacy_Record_ID__c'. Can you please share the right configuration for external Id mapping with related objects upsert
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
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
Email Notifications for when Control Flow fails
Is it possible to setup an email notification for when a Control Flow fails? I have a scheduled Control Flow and would like to be notified if it fails. thank you
Package imported same data multiple times
Run ID: 184418611 We ran an import from a csv file into D365, the execution took a very long time to run but then gave us the below error. However we then noticed that the data actually went into D365 and repeated for 6 times. Can you please provide us
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
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?
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,
Skyvia for Salesforce
Hello, I have 2 tables I'm pulling data from to push to Salesforce using Skyvia Datasource method. I am having extreme difficulty getting data from the second table as the required fields in Salesforce do not have a correlation to the table I need 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
Unable to Parse range
I am getting the following error which I cannot seem to fix Integration failed: Invalid data[2010]: Unable to parse range: ComplaintsData!C0:C0 Error code: 400
Next Page