SSIS REST Api Web Service Task (Consume RESTful Service using HTTP GET, POST)

In this video you will learn how to call REST API Web Service in SSIS.

For more info: http://zappysys.com/Products/SSIS-Pow...

Features
◾Call REST Style HTTP Web Service from SSIS (e.g. Perform HTTP GET, POST, LIST )
◾Support for windows or basic authentication
◾Save response to variable or file
◾Filter JSON response using JSONPath to extract specific value inside response text
◾Filter XML response using XPath to extract specific value inside response text
◾Validate response using custom rules such as Response Code must be less than 300, Response Content must contain XYZ string, Response Header must contain certain key/value pair … etc
◾Support for Testing UI
◾Support for dynamic variable replacement with format specifiers anywhere inside header or request data (e.g. {{User::MyVar}} {{User::MyDate,yyy-MM-dd}} {{User::MyAmount,C}} )
◾Use of BASE64 format specifiers (e.g. {{User::Creds,BASE64ENC}} will replace value with Base64 Encoded string and {{User::Creds,BASE64DEC}} will decode Base64 string. This is very useful for sending Authorization Headers which is usually base64 encoded
◾Support for SQL Server 2005, 2008, 2012, 2014 (32 bit and 64 bit)