Questions
Category: Questions
Adding first name and last name together
Name data source has two fields ship_first_name and ship_last_name. I need to pass ShipName to my target. How can I join these two together with an expression to make this ....
Created by
Latest by
Category: Questions
Month and Date only
Is there a way through expressions to only retrieve only the month and date? Currently mailchimp on the birthday field only takes month and day, while the field I'm importing ....
Created by
Latest by
Category: Questions
JSON format for Mailchimp address import (csv file)
Running into this problem with mailchimp: CSV file has invalid content or its structure does not correspond to the mapping defined in the package. What is the correct format for ....
Created by
Latest by
Category: Questions
How to schedule a query to run
I have written a SQL query and it works well for me. Can I schedule the query to run daily? and export the data automatically to a Google Sheet? Thank ....
Created by
Latest by
Category: Questions
Problems importing to Postgresql using auto-generated id
Hi, I would like to import new rows into a Postgresql table where the primary key uses uuid_generate_v4() to generate unique Id's. The problem is that Skyvia requires me to map ....
Created by
Latest by
Category: Questions
SkyVia Connect and guid
I'm new to SkyVIA, and i am experimenting with publishing an Azure SQL database using a connect endpoint. I have a very simple table, named Menu that has 3 fields. ....
Created by
Latest by
Category: Questions
email invitation for new user is not getting through
Hi Support, I am trying to add another user (finance department) into the skyvia portal so they can view and download invoices. when I create a new user and send the ....
Created by
Latest by
Category: Questions
Magento Tables sync with Salesforce
Hi Team, Kindly can you what all Magento tables can be synced with Salesforce. Thanks ....
Created by
Latest by
Category: Questions
Syncing New Fields
Hi Team, I have added a New field in Salesforce and I am trying to sync with Skyvia but the field is not visible in Skyvia. Could you let me ....
Created by
Latest by
Category: Questions
SFTP to Salesforce Integration Failed
Hi, I set up an integration to upsert data from a CSV via SFTP to Salesforce contact fields, scheduled it to run daily. It worked fine for 4 days then ....
Created by
Latest by
Category: Questions
Zoho Inventory - Sales Order Export - Addresses Missing
Hi, I've been running some queries to extract Sales Order data from my Zoho Inventory Org. The queries run normally and return the data I'd expect from my test Sales ....
Created by
Latest by
Category: Questions
Real Time Sync
Hi Team, I need clarification whether there is real time sync happens in Skyvia when connection between Magento and Salesforce is done. Kindly let me know. Thanks. ....
Created by
Latest by
Category: Questions
Skyvia Sales/Support Contact
This is my 5th Day to find or get in touch with Sales or Customer Care to calrify some details. Is there any place where person can dial in and ....
Created by
Latest by
Category: Questions
Replicating data from MySQL to Redshift?
I have a MySQL database sitting in Amazon that I want to create an exact replica of in Redshift. The data will never change on Redshift, so a one way ....
Created by
Latest by
Category: Questions
Import and Delete problem due to Primary key
Hi there, I have a csv file that I would like to import into Dynamics 365. I would like to set a task to delete previous data and upload new data ....
Created by
Latest by
Category: Questions
How I can connect to a SQL Server that It's running behind a firewall or ina a AWS VPC
Hello, We want use Skyvia for Marketing CCloud and Salesforce integrations, but we have a little issue. We need to acces to a SQL Server that it's running in on-premise ....
Created by
Latest by
Category: Questions
Connecting to Unleashed REST API
Hi Folks I'm trying to get my head around setting up the REST component of Skyvia to pull date from the Unleashed API (https://apidocs.unleashedsoftware.com). I have my ID and Key ....
Created by
Latest by
Category: Questions
Connect to Big Commerce
Hello, see below credentials which is the credentials I get when setting up an API in Big Commerce. However whatever combination of results I add into Skyvia I seem to always ....
Created by
Latest by
Category: Questions
Can Skyvia import xls file?
Hello there, we need to be able to import data from .xlsx (excel) to salesforce - BI team cannot create cvs file easily. Does Skyvia support it? Thanks much for ....
Created by
Latest by
Category: Questions
Scheduling google sheets refresh via query?
Is it possible to shedule a google sheet to refresh daily using the query? I know we can create schedule action/events in the google api but don't know if it ....
Created by
Latest by
