filmov
tv
How to call Salesforce REST API in SSIS (JSON API)

Показать описание
Features
Support for calling any Salesforce REST API (RESTful API)
Support for calling any Salesforce SOAP API (XML API)
Call REST Style HTTP Web Service from SSIS (e.g. Perform HTTP GET, POST, LIST )
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}} )
Support for SQL Server 2005, 2008, 2012, 2014, 2016 and 2017 (32 bit / 64 bit)