Questions
Category: Questions
Replace Function
Hi Team, I would like to replace the values as per the below format If the replace value = 'New Sales' then it should be replaced by 'NB' or if ....
Category: Questions
Odata connector error - Invalid service root document
Hi there, I'm having issue getting anything out of the odata connector. When I test the connection, skyvia says it works but as soon as I try to use ....
Category: Questions
Files masks date on day before
Hey, I'm struggling with set up of the import from SFTP as i have files with delay on the server, using this {yyyyMMdd} i have today's date but i need day ....
Category: Questions
Dropbox getting logout in target connection
Hello I have used my dropbox as a target connection to import the data into salesforce through a CSV file in dropbox. And i have put this package on schedule run ....
Category: Questions
Connect Activecampaign to Google Data Studio
I'm getting this error when trying to set up a connection between activecampiagn and data studio. The underlying connection was closed: Could not establish trust relationship for the SSL/TLS ....
Category: Questions
Snowflake connection
To load data to Snowflake is it mandatory to use external storage? How to add in Snowflake connection a folder inside a bucket? (attached image) ....
Category: Questions
User does not have storage.buckets.get access to the Google Cloud Storage bucket.
Hi, We want to use Skyvia to extract data from a mysql database and insert it on Bigquery. We did the connectors and the mapping and it is working OK so ....
Category: Questions
Pipedrive to Power BI - OData connection
Hello! I'm having difficulties connecting the OData Endpoint to Power BI. It seems that some of the tables do not upload. I have tried the connection from other ways as ....
Category: Questions
Integrating JIRA Service management cloud base with SQL DB on premise
Hello, I am trying to use Skyvia to Integrate JIRA Service management (Service Desk before) cloud base with SQL DB on premise, but i have noticed that JIRA connecter that ....
Category: Questions
Source returns no records on Run
I created my first data flow, from Harvest to SQL. When I preview the source object, I get data, but when I run it, it doesn't process any rows. What's ....
Category: Questions
REST API connector for Microsoft dynamics business central
Hello, I am trying to connect Microsoft dynamics business central as data source to skyvia. But i'm not sure what should be provided in the metadata field. It is urgerntly ....
Category: Questions
REST Connection Metadata
Hi, we are trying to create a new REST connection for a synchronisation in Skyvia for the following example: curl -d -X "https://portalbeta.tracker.com/api/trk/tracking/device/detail/list" -H "Content-Type: application/json" -H "Accept: application/json" -u "assword">[email protected]" ....
Category: Questions
How Can I Do to group a lot of sourcers and export it to sheets?
Hi, I have a lot of Facebook ADS account, I created 1 source for each account I want to connect (group) all sources and send it to one sheets ....
Category: Questions
Skyvia Agent - TLS 1.2 and 1.3 support
I got a message from our clients server manager telling me they will update their servers. They will disable SSL 2.0, SSL 3.0, TLS 1.0 and TLS 1.1 Instead ....
Category: Questions
Will Salesforce MFA requirement affect my SQL replication connection?
https://help.salesforce.com/s/articleView?id=000352937&type=1 Salesforce will require multi-factor authentication. How does this affect my Salesforce to SQL Server replication OAuth 2.0 connection. I use the web service not the installed agent. ....
Category: Questions
Skyvia Agent service stopping directly after starting
I have installed the Skyvia Agents on different servers for customers were we need to connect to their database. However, I am currently running into an issue where the Skyvia ....
Category: Questions
Usability of Backup Files
Hi there, we currently use Skyvia for running both Packages and Backups. We've had a couple of incidents with data loss/changes recently where we expected to be able to pull ....
Category: Questions
How we can run SOQL inner query in Skyvia?
Hi Team , I have below query to run SELECT Name,ccrz__SKU__c,ccrz__ShortDescRT__c,(select Id,ccrz__Price__c from ccrz__E_PriceListItems__r where ccrz__Pricelist__r.ccrz__PricelistId__c ='UP_Price_Main' LIMIT 1),(select ccrz__URI__c from ccrz__E_ProductMedias__r where ccrz__URI__c != null LIMIT 1) FROM ccrz__E_Product__c ....
Category: Questions
SERVICE DOWN
EXTERNAL_OBJECT_EXCEPTION: An error occurred while connecting to the external system. Please try again, or contact your administrator. Attempted to reach this URL: https://connect.skyvia.com/x7ygrq78/Products?%24top=2001&%24filter=ProductID%20eq%20%27256-59-L%27&%24count=true&%24select=DepthDimension%2CDescription%2CDescription2%2CHeightDimension%2CPrice%2CProductBenefits%2CProductID%2CReplacementCost%2CVendorID%2CVendorModelNbr%2CWidthDimension%2C_Status. Error received from the external system: 503: ....