Using REST API in SSIS for Data integration | COZYROC SSIS+ Suite

✔️ Connectivity and REST resource utilization is implemented thru specially crafted XML-based configuration file with support of JavaScript code.
✔️ Intuitive support for composite objects.
✔️ Support for SQL Server 2005, 2008, 2012, 2014, 2016, 2017, 2019
✔️ Optional access to any .NET class for additional functionality.

The REST integration package consists of four parts:

✔️ REST Connection Manager
- Stores the credentials and functionality for connecting to REST service.
✔️ REST Source component
- Retrieves data from a REST resource
✔️ REST Destination component
- Inserts or updates data in REST resource

[solomong.gebrhana]

Hello, I am trying to get data from an external source(HME cloud), when I try to follow your steps, I don't have that REST option in the connection manager type. any advice?

[ShivamSharma-kmrc]

Can you share link/video to post data to rest API from the SQL table?

[Wolfsfang]

Is it possible to pass a variable from SSIS for the user parameters (Email & APIKey)?

[deepaanand]

Please let me know if COZYROC REST SOURCE can be used to invoke a web api? If yes can you please share some example

[jeffersonmoseton]

I followed all the steps in the video and everything works as expected except the "preview" in the REST source, I am not getting any error messages to describe if I am doing something wrong, also the preview table shows empty ... . Any clue?

[udayanrisingsun]

Also can you explain if we have to use GET method instead of POST, do we need to follow any other steps ?

[nagelfamily]

want come back to cozyroc - zappysys hasn't answered my questions re: basic auth