Latest Tickets
Category: Questions
File mask syntax
Hi, I'm trying to link to an SFTP file with the following syntax - Lead_20190907114506.csv. I have used Lead_{yyyyMMddhhmmss}.csv as a file mask but it says it cannot open the file. ....
Created by
Latest by
Category: Feature Requests
Relative State Filter
Hi everybody, I habe an update Package where I want to update all records which have a CreatedDate within the last six month. Is it possible to configure this with a ....
Created by
Latest by
Category: Questions
REST Metadata for simple read-only API?
I am using the ECB's free exchange rate API. It is read-only. What metadata configuration should I supply if the data looks like this? https://api.exchangeratesapi.io/history?start_at=2016-01-01&end_at=2020-01-01&symbols=USD,GBP,CHF&base=EUR Thanks! ....
Created by
Latest by
Category: Bug Reports
External ID Column drop-down list is blank
Hi- I'm trying to import records from a CSV file to a "junction" object in Salesforce. This junction object has 2 parents. I'm trying to use the External ID Column ....
Created by
Latest by
Category: Bug Reports
Address not reliably transmitting in Shopify --> Salesforce integration
Often the address (Billing and Shipping Address 1 and Address 2) is not transmitted from Shopify to Salesforce. I do see it correctly in Shopify and even via the Query ....
Created by
Latest by
Category: Bug Reports
Beta Agent Connection not available in package after saving
Hi I am testing the agent in beta and it seems that if i try to run a package the newly created agent connection is blank after creating it, (but ....
Created by
Latest by
Category: Questions
What is it?
Please give couple of real life examples so that I can understand what it is. I have an azure free account. After first month of my account ends, i ....
Created by
Latest by
Category: Questions
Need to upsert CSV file into Postgres database
Hello, I have a CSV file with one of the column that is a unique ID. I would like to upsert the records into a postgres database that has the ....
Created by
Latest by
Category: Questions
Passing unix time stamp to REST service
We have a REST API that we need to connect to and pull inventory from as a source. The authentication for the API is token based however it also requires ....
Created by
Latest by
Category: Questions
Field syncing
Hi, I am integrating freshbooks and salesforce using skyvia, I am using two fields vatname and vat number of freshbook to link with two fields of freshbook. skyvia is ....
Raj Kumar
Category: Questions
PDF import
Hi, Is it possible to import some pdf document like quotation, billing... ? For now we use ftp and salesforce The idea it's to add copy on emails with quotation ....
Created by
Latest by
Category: Questions
Trying to replace text but getting an error.
Trying to manipulate datae grabbed from salesforce and insert it in the correct formatting into a MySQL database. I am getting an error thrown while trying this. "" ....
Created by
Latest by
Category: Questions
adding Netsuite as a connector using authtoken
Hello I'm trying to connect NetSuite to SkyVia and having a lot of issues. Can you assist at all? I've followed all the steps but keep getting "Invaldid Login Attempt" ....
Created by
Latest by
Category: Bug Reports
Skyvia error on BigCommerce import with unmodified BC export csv
Hi, When I try to import a csv from sftp to BigCommerce I get errors. The log says "The value of the column CustomFields has incorrect JSON format". The csv ....
Created by
Latest by
Category: Questions
Need direction on how to use Rest API to pull data from phone.com
Hello I'm trying to set up a connection to phone.com restful api to pull the list-call logs Here is their documentation My issue is with defining the meta data and ....
Created by
Latest by
Category: Questions
Unable to obtain Exclusive Access to this record
Hi, When doing a synch from our SQL Datawarehouse to Salesforce we get thousands of errors that look like this. "Unable to obtain exclusive access to this record...." ....
Created by
Latest by
Category: Questions
SFTP - CSV Import - Need Most Recent File
I am trying to grab a CSV from an SFTP and import it into Salesforce. I need it to grab the most recent file currently the CSV is being ....
Created by
Latest by
Category: Questions
Expression Mapping to delete TM and escape apostrophes
Hi, I'm trying to map an import from a google drive csv to a postgres table. Currently, I clean up the data during the skyvia process by using expression mapping ....
Created by
Latest by
Category: Questions
limit api calls
We're testing out the backup of our Salesforce database. When we previously attempted a full backup, we exceeded the daily API call usage. Is there a way to limit the ....
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
