In this video you will learn how to call REST API Web Service in SSIS. <br /> <br />For more info: http://zappysys.com/Products/SSIS-Pow... <br /> <br />Features <br />◾Call REST Style HTTP Web Service from SSIS (e.g. Perform HTTP GET, POST, LIST ) <br />◾Support for windows or basic authentication <br />◾Save response to variable or file <br />◾Filter JSON response using JSONPath to extract specific value inside response text <br />◾Filter XML response using XPath to extract specific value inside response text <br />◾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 <br />◾Support for Testing UI <br />◾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}} ) <br />◾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 <br />◾Support for SQL Server 2005, 2008, 2012, 2014 (32 bit and 64 bit)
