Recent Topics
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
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
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
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
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 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
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.
Skyvia link to Salesforce - errors connecting.
Affecting 140 customer service users. Please fix ASAP.
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?
HubSpot Replication not deleted rows from LineItems
We are using the Skyvia replication from HubSpot to a MySQL data warehouse. The replication is set up as for Incremental Updates. We are noticing on the LineItems of a deal, after they have been replicated to the database this behavior. 1) If new line
Google Big Query Doesn't Support JSON, ARRAY or STRUCT types
When working with Array or Struct types in BigQuery you cannot select any columns using these types for mapping. Having JSON type columns crashes the task creation wizard stopping you form being able to create a mapping.
Woocommerce / impossible to get product VARIATIONS sales
Hi, Everything's fine with my Skyvia / woocommerce connection, except the fact that it looks impossible to get product variations sales. I can get product total sales, I can get some product variation informations, but I can't get product variations sales,
No support for Affinity API field that is an array of objects
We are trying to export data from the affinity organizations API, docs here: https://api-docs.affinity.co/#the-organization-resource The list_entreies field is an array of objects according to the documentation, skyvia shows this as TEXT field in the
Completed integration / import shows as running and fails after 30 minutes after data successfully imported
Seeing odd behavior in UI and import / upsert from MySQL to SQL server: Initiated manual run to upsert 25K rows from MySQL to SQL. I see correct data being pulled into SQL and all rows transfered within few minutes, During this time no activity visible
Handling of Null or blanks during import
It appears that Skyvia is replacing content when a null or blank field is imported. Is there a setting that will allow us to ignore null values during imports, leaving any existing values in the destination unchanged?
'Trusted Devices' IPs listing Cloudflare instead of actual source
Hello, Theres something wrong with how 'Trusted Devices' are being logged here: https://app.skyvia.com/#/profile/two-factor-authentication Since at least June 1st, 2023, 100% of the IP address access logs against my account are listing Cloudflare proxy
Append timestamp not working as expected
I have created an export integration and checked the "Append timestamp" checkbox. The resulting file does not have either a date or timestamp added. Here is the integration package I am using https://app.skyvia.com/#/138012/packages/232230 Here is a screenshot
Lookup
Hi, We have a integration , wherein we are doing lookup on target which has 717188 rows. The data flow goes in hung state for hours and we cancel it after few hours. Is there any other alternative?Run id 155117268.
i want to have imported data direct references
Good Afternoon, I want to be able to import data from NetSuite into my Jira Service Management environment and make said imported data referenceable via a custom field within JSM for the end user. If i could get some assistance with accomplishing this
Next Page