Recent Topics
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?
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
File mask date/time zone mismatched in scheduled import
I am scheduling a file import to run on a daily basis. I have selected UTC/PST as the time zone. The task is executing at the correct time locally, but it is using some other time zone to judge what date to use for the file mask. Is there a setting I
Sorting by Ascending Problem
This issue was brought up a couple weeks ago, and we've troubleshooted with Salesforce to the point of determining this must be something to do with Skyvia connection to our database. On any Contact page in Salesforce, we display several related lists:
Connection Issues - URGENT
Affecting the entire customer service team of over 100 users trying to help our customers. ui.services.connection.api.PartnerConnectionException: EXTERNAL_OBJECT_EXCEPTION: An error occurred while connecting to the external system. Please try again, or
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?
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
Agent error
i'm facing the following error while agent trying to connect. Please advise
Critical 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'.
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
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.
Skyvia integrations + terraform
Is there a way to terraform the integrations in the skyvia?
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
Connector for Banking and Financial Transactions
Have you considered adding a connection to Skyvia so we could sync Credit Card, Checking Account, and other banking transactions? The Plaid API (plaid.com) is pretty simple, and works quite well--standardizing feeds from thousands of financial institutions.
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
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
Pinterest - UserAccountDailyAnalytics
Can't retrieve any records from "UserAccountDailyAnalytics". getting error "You can only get data from the last 90 days."
Facebook Ads DailyAccountInsights not working
This used to work, stopped working 2 days ago. Now getting error "(#3018) The start date of the time range cannot be beyond 37 months from the current date" SELECT t.* FROM DailyAccountInsights AS t
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
WooCommerce Unable to Connect to Remote Server
The WooCommerce integration seems to be broken. I have tried changing out the API key, but still no luck.
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?
JournalEntry Permission Violation: The accountingbook restrictions on your role prevent you from seeing this record.
Hello Team, I've logged in as an administrator, but I'm encountering a Journal Entry Permission Violation error. I've attached a screenshot for your reference. Your prompt attention to this matter would be greatly appreciated. Thanks Bhushan
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
Next Page