Recent Topics
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
facing some problems since 1 of november.
I am facing some problems since 1 of November. some processes start to take more time. some they don't finished, i have to force stop. I am talking process spent 30 or 40 hours and now, passed 90, 120 hours the process is not done. Some process i have
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
Incorrectly receiving message You have reached a limit of CSV records.
I experience this error all of a sudden: You have reached a limit of CSV records.. Counting all the records in the runs of this month (which has just started), it doesn't add up at all to the number of CSV records I am credited for (200k). Previous months
Integration failed: Invalid number of output records.
When attempting to replicate from saleforce we receive the following error message after it "runs". For context, everything was functioning fine before yesterday. Integration failed: Invalid number of output records. Appreciate it.
How to use REST Connector?
I'm trying to use the REST Connector, and I'm having some trouble. There are no examples in the Gallery and it's the only connector that doesn't have a page in the docs: https://docs.skyvia.com/connectors/ I have a URL that I would like to POST data to,
Facing issue in opening task of integration package
Facing issue in opening task or creating new task for integration package it is saying please provide a valid connection (and showing time out) while in edit and test connection every thing is fine and says connection is valid. not sure what is the issue
Contacts Job is running more than usual time
Hello Team, Anybody facing an issue with Jobs on Skyvia portal. Our jobs are executed properly until 30th October. We added a few extra properties to the file and did a schema refresh to map it properly, later on job is not working as expected and no
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
Next Page