Hi,

I am using SSIS script task to call a REST Service with oAuth token. But it fails with 401 error.

Can anyone please suggest what is missing?

Regards,

Babadu

Hi Babadu,

Check the similar thread for solution

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d4492111-4f43-4b35-bb29-cfb076ebbfc7/calling-a-restful-web-service-from-a-script-task?forum=sqlintegrationservices

404 means not authorized, why not is because of the Firewall rules prohibiting certain communications.

Thanks Milan. I am doing exactly the same. But, at 

using (HttpWebResponse response = request.GetResponse() as HttpWebResponse)
{

this line, it fails with error 401 unathorized. I am passing oAuth token as well in the request header. 

Any help please?

Hi Arthur,

How do i check this ? As i am calling REST api from SSIS Script task? Do i need any permissions?

Thanks,

Babadu