Guide to REST API Connections in CozyRoc SSIS+: Table of Contents
Table of Contents
I. Introduction
II. Installing CozyRoc SSIS+
A) Installing Visual Studio and SSDT
B) How to Download and Install the CozyRoc SSIS+ Components Suite
C) Check Software Versions
D) Licensing CozyRoc SSIS+
III. The Basics of SSIS+
IV. Getting Started with REST API Connections
A) Configuring a REST Connection Manager
B) Reading Data from an API (GET Requests)
C) Creating Records through an API (POST Requests)
D) Updating Data through an API (PUT, PATCH Requests)
E) Deleting Data from an API (DELETE Requests)
V. Service-Specific REST API Connections
See the CozyRoc products page showing the SSIS+ Components Suite.
VI. JSON Transformations
VII. Troubleshooting
A) How to trace HTTP(S) and REST API using Fiddler
VIII. Other Topics
A) How to use a Database to Store REST Tokens
B) How to Deploy an RCM File
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+.
Related Articles
Guide to REST API Connections in CozyRoc SSIS+: Introduction
Guide to REST API Connections in CozyRoc SSIS+ This guide will show you how to use CozyRoc SSIS+ to make connections to third-party integrations, web services with REST APIs that enable you to extract, transform, and load data across the internet. ...Guide to REST API Connections in CozyRoc SSIS+: Introduction
Guide to REST API Connections in CozyRoc SSIS+ This guide will show you how to use CozyRoc SSIS+ to make connections to third-party integrations, web services with REST APIs that enable you to extract, transform, and load data across the internet. ...Getting Started with REST API Connections in CozyRoc SSIS+: Section Table of Contents
Guide table of contents: Guide to REST API Connections in CozyRoc SSIS+ Get acquainted with REST API connectors in CozyRoc SSIS+ so that you can integrate data sets and databases across web services and platforms. CozyRoc SSIS+ Components Suite is a ...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 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 ...