How To
How to use Postman Collections in COZYROC SSIS+ REST framework?
To use a Postman Collection, you will need first to convert it to an OpenAPI specification and then import it, as shown here: https://www.cozyroc.com/ssis/rest-custom-openapi-import There are various methods for this transformation, e.g. check out ...How to upload an Excel file to Google Drive as a Google Spreadsheet
In order to upload an Excel file to Google Drive as Google Spreadsheet you need to: Create a project in Visual Studio. To establish a Connection Manager to Google Drive, you need to use a Google Drive Connection (see Quick Start >> Establish ...How to use a Database storage for new REST tokens
Make sure you have launched Visual Studio as "Run as Administrator". 1 : In Rest Connection Manager choose the configuration from the dropdown list you want to generate token for. 2: For the Token storage parameter in the grid below select Database ...How to deploy an .rcm file provided by COZYROC.
You extract and copy to the following folder: C:\Program files (x86)\CozyRoc\SSIS\REST This location is the default when doing a default installation of COZYROC SSIS+. If you have trouble saving the file to the directory, you may want to be sure you ...How to manually generate a Google Services Token?
A token-based authentication system allows users to enter their username and password in order to obtain a token, which allows them to fetch a specific resource, without using their username and password. Once their token has been obtained, the user ...How to dynamically set a user parameter in a REST Connection.
Create a REST Connection with a custom configuration to use for our example. Let’s start by creating a REST Connection configuration that has authentication with two user parameters. We will set their values dynamically from variables using an ...How to set up authentication for a REST application using COZYROC's REST Wizard UI
If you want to use COZYROC's REST wizard UI to define the authentication required to connect to a custom REST application, please use the Custom REST Starter Series on this page. It goes through 101 steps to set up and test authentication using the ...How to set up Fiddler for testing a REST configuration
This article (<-- Click the link) describes how to install Fiddler to trace traffic as well as decrypt https traffic and how to set up filters if you know what to filter on. Since the REST authentication will use https, it can be helpful to close any ...How to use an XML configuration in a REST Connection Manager
Follow these steps to use the configuration Right Click Connection Managers. Choose New Connection. Select Connection manager for REST connections. In the Configuration drop down choose {Custom}. A wrench appears to the right of the Configuration ...How to get a new REST Token
Make sure you have launched Visual Studio as "Run as Administrator". The token setup process is organized as a wizard consisting of three steps: Step 1: Specify the REST service parameters required to initiate the authorization. If there are no ...
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Popular Articles
How To verify Microsoft Integration Services is installed on SQL Server
SQL Server Integration Services (SSIS) is a component of SQL Server and can be installed with or without SQL Server. The same SQL Server setup can be used to install Integration Services on the server that SQL Server is installed on. SSIS is a ...FLEE Expressions for filtering
FLEE expressions are used to define criteria for filter parameters in several COZYROC tasks and components. FLEE is a “Fast, Lightweight Expression Evaluator.” Finding documentation to help you configure a valid expression can be challenging. The ...I see a response returned from the web service, but the preview in REST Source does not show any data.
CozyRoc Rest Source Component allow you to Read data from REST API. Developer can quickly extract response data from desire endpoint using HTTP Method (GET, POST) and Output into column data. In this article we will walk through some examples that ...How long is the grace period after the subscription has expired?
We noticed that our license is going to expire soon and we are in the process of renewing the license and it might take couple of days. We are wondering if you can provide a solution to use your product in our production system temporarily without ...How to resolve File Transfer Task failing when no files exist.
This KB article is not relevant if you are using "Get Remote Files List" action on File Transfer Task. Instead, you can use this COZYROC prepared Javascript: https://www.cozyroc.com/ssis/script-ftp-file-exists-task If you are not sure there will be ...