Questions
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: 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: 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: 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
Category: Questions
Magento encoding violation using UpdateInventory
I'm receiving a SOAP violation of encoding error when trying to use UpdateInventory for Magento v1. I've tried with constants as well however it looks like it's expecting a different type ....
Created by
Latest by
Category: Questions
Associate HubSpot company to HubSpot deal
Hi, inserting HubSpot deals we cannot match Company Id fetched with target lookup from HubSpot company with property associatedCompanyIds as the datatypes don't match. The returned Company Id is dt_i8 ....
Created by
Latest by
Category: Questions
Error token invalid on URL connection with marketing cloud Salesforce
Error token invalid on URL connection with marketing cloud Salesforce I am Trying to connect marketing cloud with skyvia but After than release of Marketing I get this error ....
Created by
Latest by
Category: Questions
Is there a workaround to upsert CreatedDate and CreatedById fields in Salesforce in 1 single task?
Hello, I'm trying to import CreatedDate and CreatedById from SQL server to Salesforce for an object. According to Salesforce, we can only Insert, not Update/Upsert these two fields. In Salesforce, ....
Created by
Latest by
Category: Questions
Product Query
Hi, We would like to push info from an ERP system (IFS) to Salesforce via an FTP site. We require information to be pushed bi-directionallly from the ERP to Salesforce ....
Created by
Latest by
