Calling a Web API page from SSIS?

Question

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?

Have you tried using `WebClient` from a script task? Which version of SSIS? — Christian Phillips, Jul 29 '14 at 20:04

score 4 · Accepted Answer · edited May 23 '17 at 11:51

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?

score 1 · Answer 2 · answered Jul 29 '14 at 20:27

1

Another stab in the dark here, since I haven't tried this either...

Use ChristianDev's method to retrieve the XML and store it in a variable to use with the XML source.

answered Jul 29 '14 at 20:27

Metaphor

6,157
10
54
77

Calling a Web API page from SSIS?

2 Answers2