Questions
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: ....
Category: Questions
Freshsales fields
Hi, I am using the freshsales connector. While the ownerid field contains the owner for Accounts, it is always "null" for Leads, Deals & Contacts (these fields are mandatory in ....
Category: Questions
Hard-coding value in Replication
I am syncing multiple tenants in Pipedrive into a single set of tables in my SQL database. I am not sure that the primary keys are unique across tenants. As ....
Category: Questions
Changing name of target table in a Replication Package
Is there a way to modify the target table name when setting up a replication? I am replicating multiple tenants in Pipedrive to a single database and because the primary ....
Category: Questions
Mapping error when importing from Google Sheets to Salesforce
We are trying to import data from a Google Sheet into Salesforce using Skyvia. We managed to make it work but some fields are giving us an "Invalid Type" error ....
Category: Questions
Timestamp option while creating a package
Hello Team, While creating a package we, We have this option to append the timestamp to the file name. However even after checking this option I was not able to ....
Category: Questions
SFTP Connector
Once I add an SFTP Conection how do I query the data? When I go to select a conector the SFTP doesn't show in the avaliable options. I am trying ....
Category: Questions
Update to Task
Hi, We have package https://app.skyvia.com/#/79779/packages/125185 that does a daily export. As this package's query needs to have specific headings, we had to get Skyvia support to enable that as part of ....
Category: Questions
Query Skyvia Logs - Like Run History
Not sure if it is possible but it would be AMAZING to be able to set a CONNECTOR to the Skyvia Logs and be able to Copy the "Package Success" ....
Category: Questions
Importing Files from Salesforce to Dynamics
I am trying to import Quote Documents from Salesforce to Dynamics.File from SF is DT_IMAGE - trying to import as an attachment but cannot figure out how to bring them ....