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
Concatenate Expression Help Needed
We have an sync integration between Salesforce and Netsuite and need to combine a number of 2 fields and 3 items of text to place a script in a Netsuite field on the invoice. "Sample Text 1" [inserted field 1] "Sample Text 2" [inserted field 2] "Sample
Salesforce Reports Ran Through Skyvia Missing Data
When exporting and running a joined, 2000+ row Salesforce report through Skyvia, none of the columns from the joined objects are included in the exported CSV, and no rows past row 2000 are included. Is this a limitation of Skyvia? Of Salesforce? Is there
Skyvia to Hubspot - Inserting Contacts and associating them to an existing related Company
Hello team! We're trying to add contacts to an existing company via Skyvia via Hubspot's Compan We see the existing option to import to Company and associate contacts - but we want to do it the other way - associate new contacts to an existing company
Dynamics Consider adding missed privilege to one of the principal (user/team) roles.
How to solve this problem? https://app.skyvia.com/#/76069/packages/208651/debug Principal user (Id=a65d00e1-4d83-eb11-a812-002248367004, type=8, roleCount=7, privilegeCount=349, accessMode=0, MetadataCachePrivilegesCount=11773, businessUnitId=4eb55f42-9424-e911-a957-000d3ac1be86),
Restore backup to Zoho CRM : new lead type created
Hi, I'm currently testing the restore fonction to zoho CRM. In the lead module, when I restore a record, restaured record has a type "existing business" but as we can see, it's not even in the predefined choice. Where do this comes from? thanks
Can't sign in with Salesforce
My main account uses Salesforce to sign in however, every time I try I keep receiving an error like this one: Authorization Error - Skyvia User with same name exist Request Id: 462455d9-3d3d-40c9-bb79-707040a8e00a I also tried signing in on a different
Issues Importing Related Objects
I am attempting to load data from SQL Server to Salesforce. The SQL Server Data relates to 3 salesforce objects which is have a relationship to each other. The 3 tables are Timeentries (this is the parent table and links to the other 2 through the common
SFTP file masking capabilities
I recently had the requirement of processing a csv file from an SFTP source with Skyvia and when I attempted to grab the file using a file mask, I was unable to create a mask that could grab the file by date and ignore the irrelevant part of the filename.
Partial Shipment
Hello, We need assistance in partial shipment. Will you be available to connect with us.
Next Page