Recent Topics
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
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
Hubspot Matching import (Deal-Contact) with Tags
Hello, we want to import further Deal Information into Hubspot, such as Main User an Co User. At the moment we can only do a simple Mapping of the Deal to Contact table but it would be great if we could do a second integration where we can import the
FTP Path
Good Morning, I am testing out the FTP connection but I am unable to specify the path of the file. I am only given a dropdown.
Import CSV File from Onedrive
Hello, I would like to access an Excel file in an Import which is saved in my Onedrive. I have created a connection to Onedrive, but once editing in the Task Editor I can't see the file. Should be in marketing but it is not in there, see below. Thank
Multiple Agents instances need on same Database Server
I am trying to replicate Quickbooks Online from three (3) company files to a single MySQL database. Each of the QB connections is in its own Workspace so I have three (3) Agent Keys for the same MySQL machine. Is there a way to pass the Key for each of
ODATA Connect with AZURE SQL
We are getting the following error using ODATA connection. This was working till few hours ago and suddenly stopped working. Nothing changed from firewall side. SKYVIA IP Addresses are whitelisted A network-related or instance-specific error occurred
Monday.com API Update
Hello, Monday.com recently announced that there will be a major update of their API in January. Is there any impact on our exisitng integrations or will it be a smooth transition? Regards, Dominic
Syncing Issue, Need argent help.
I'm connecting hubspot and airtable. I have a dropdown multiple select field in hubspot and trying to sync that in airtables multiple select column. It's not syncing, maybe it's issue with data type, Airtable is aspecting Array but HS giving text in "Val1;
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?
Is there a way to get a record count for each table in a connection;
Without writing x queries. Trying to determine how much data volume I have so I can select the right integration product
AWS RDS integration
Hey everyone ! How's it going ? Does Skyvia works with AWS RDS ? I'm trying to set it up but I'm getting connection errors. So far I opened port 1433 on the security group attached to the db and tested while being publicly available. Has anyone dealt
Paid backup plans no 'unlimited'. Purging everything after 30 days
Hello, I've opened a separate support ticket email for this ( #40169 ), but would like to see this addressed in the community forum for transparency. We are on a paid Backup plan have been since May of this year. One of the "cornerstone" features that
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?
Error message : " TypeError : Cannot read property "
I am trying to import datas from Hubspot but Skyvia doesn't run and this message appears : " TypeError : Cannot read property "contentType" from null. " Do you know how to fix that problem ?
Next Page