SSIS post data to web service API

Question

Hi,

I'm just curious at a very high level if it's possible to send data to a web service API by using SSIS.  For example I will have post data using this type of request with JSON formatted file (along with OAuth2 credentialing)

POST https://api.destination.com/integration/batch_load.json

This appears to be possible using C# code with the "httpWebRequest" class.   Can I use a script task within SSIS to accomplish this?

Thanks

Answer 1

Hi twenger26,

You can use a script task provided the communications of this sort are allowed in your prod environment.

---

Arthur

MyBlog

Twitter

Answer 2

Hi Twenger,

According to your description, you need to know if we can add values ro web services in SSIS script task, right?

It's possible to achieve this requirement in a acript task. Here are some useful links for you reference.
http://stackoverflow.com/questions/25878958/how-to-pass-values-to-a-web-service-from-ssis-script-task
http://social.technet.microsoft.com/wiki/contents/articles/22587.consume-webservice-via-ssis-script-component.aspx

Regards,

---

Charlie Liao
TechNet Community Support

Answer 3

There are 3rd party tools that are free in Visual Studio:

https://zappysys.com/blog/http-post-in-ssis-send-data-to-web-api-url-json-xml/

You can create in the connection manager an Oauth2 connection with your URL and use a REST API task to invoke it.

---

MVP MCT MCTS Daniel Calbimonte

http://elpaladintecnologico.blogspot.com