Calling a Web API page from SSIS?

asp.net ssis asp.net-apicontroller
John S picture John S · Jul 29, 2014 · Viewed 18.1k times · Source

I have a simple ASP.Net Web API set up that triggers a process. I would like to call this API from SSIS. I am able to call a web service but am not sure how to call an API link since there is no WSDL.

Is there a way to do this without having to use AxtiveX scripting?

Answer

christiandev picture christiandev · Jul 29, 2014

I haven't tried this before, but you could create a Script Task and use WebClient Class by referencing System.Web. If you take a look at Calling Web Api service from a .NET 2.0 client, you should be able to amend this to call your Web API.

This is a stab in the dark, and I might get downvoted, but it might be a starting point.

EDIT: I did some more digging around, and found a similar question here, it's not calling a Web API, but it is making a HTP Request etc How to make an HTTP request from SSIS?

Related questions

Failed to acquire connection. Connection may not be configured correctly or you may not have the right permissions on this connection

I am getting following error while attempting to execute the package. I can execute individual task successfully. But whenever attempt to execute whole package it gives me error. SSIS Data flow on distributed transaction - [Execute SQL Task] Error: Failed …

Read More
Change the selected value of a drop-down list with jQuery

I have a drop-down list with known values. What I'm trying to do is set the drop down list to a particular value that I know exists using jQuery. Using regular JavaScript, I would do something like: ddl = document.getElementById("…

Read More
How to get the URL of the current page in C#

Can anyone help out me in getting the URL of the current working page of ASP.NET in C#?

Read More