In this video you will learn how to call REST API Web Service in SSIS. br br For more info: ... 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 keyvalue 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.