Use RestApi in SSIS package to consume and send data

Question

Hi,

Is that possible to use RestApi in SSIS package to send \ post data and get data . Please suggest if its possible. Also would like to understand the implications of doing this in SSIS package.

Thanks.

Answer 1

Hi there,

The REST API calls are possible.

I'd suggest a commercial component if you need to move fast as http://www.cozyroc.com/ssis/rest-connection (I am not affiliated with them). It is just less error prone as some REST API are hard to get working even not in SSIS.

Otherwise you need to code it up yourself in say a Script Task. The code examples can be found online.

Security would be a thing to thing about as you would need to open up some ports.

---

Arthur

MyBlog

Twitter

Answer 2

Hi Sir,

I agree with ArthurZ. If you want to consume the REST API in SSIS, you could have a look at this article to learn the detailed steps. You could also run the code in Script Task as suggested above.

Besides, if the REST API returns JSON, you could also have a look at this 3rd component. In the download file, it shows how to register the component into your machine.

Best Regards,

Albert Zhang

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 3

Yes, it is possible. Here you have a tutorial to POST data in SSIS:

https://www.youtube.com/watch?time_continue=3&v=zE6P5n744WU&feature=emb_logo

---

MVP MCT MCTS Daniel Calbimonte

http://elpaladintecnologico.blogspot.com