Asked by:
Use RestApi in SSIS package to consume and send data

Question
-
All replies
-
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.
- Proposed as answer by Albert_ Zhang Thursday, April 6, 2017 2:13 AM
-
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 MSDNFSF@microsoft.com. -
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