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 ?
how to use the function DATE_DIFF
The doc says date_diff datepart - string*, startDate - datetime, endDate - datetime I have a start time 2023-11-18T00:25:45.323315+01:00 and a stop time 2023-11-18T00:34:28.675407+01:00 and want to know the difference in seconds
Loading a new CSV Daily
Hi, I'm trying to create a job to take a CSV from my Google Drive and drop it into Salesforce. This file is replaced every day as we get fresh data. Is there any way to setup a job that checks for a file by name instead unique file ID? Every time the
OneDrive file "Resouce could not be found"
All of my source files are saved on OneDrive in the same folder. One of the source files repeatidly fails during a scheduled Upsert with the error message "The resource could not be found" None of the other source files in the same OneDrive folder have
Integration failed: After parsing a value an unexpected character was encountered:
I am using Skyvia to transfer data from Airtable to Google sheets. When I use the import function to update information in Google Sheets I get the following error. Integration failed: After parsing a value an unexpected character was encountered: ". Path
Monday.com replication to MySQL fails
Hi, I try to replicate a Monday.com Board with 1000+ entries to a MySQL database and get the following error: "Integration failed: upstream request timeout" With smaller boards it works fine. Are there any limitations with regard to Monday.com integreations?
Google Analytics with Yellowfin BI application integration
Hello There, i want to integrate Google Analytics with the Yellowfin Bi application through Skyvia, can you please send a detailed document?
Link an indirect generated object to anther object - Import MySQL to Salesforce
Hello, I'm new to Skyvia and I recently encountered a need to import MySQL data into a Salesforce organization. Currently, I have the following situation and relationships established: Opportunity Object/Table A with a foreign key, OpportunityID, to connect
Next Page