SSIS REST Api Web Service Task

SSIS REST Api Web Service Task

SSIS REST API Web Service Task can be used to send/receive data using HTTP Web Request (e.g. GET, POST, PUT etc.). You can validate and save Web Response to file or variable. This task also supports Basic/OAuth 2.0 Authorization to connect with verity of services (e.g. Facebook, Twitter, Salesforce).

Features

  • Call REST Style HTTP Web Service from SSIS (e.g. GET, POST, LIST) (Read more…)
  • Support for windows / basic authentication, client certificate and OAuth (Read more…)
  • Support for advanced error handling (Save error flag, continue on specific error or any error)
  • Support for File upload, REST API POST using Multipart/form-data (Read more…)
  • Save response to variable or file
  • Support for Cookies  (Read more…)
  • Filter JSON/XML response using JSONPath or XPath expression (e.g extract Token property from response)
  • Validate response for Response Code, Content or Header
  • Support for easy Test UI (see request/response)
  • Support for advanced options (Gzip compression, timeout, Set SSL/TLS protocols. TLS 1.2 supported)
  • Support for dynamic variable replacement with format specifiers anywhere inside header or request data (e.g. {{User::MyVar}} {{User::MyDate,yyy-MM-dd}} )
  • Use of BASE64ENC format specifiers (e.g. {{User::Creds,BASE64ENC}} to encode Authorization header.
  • Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)
If you have need to pull REST API data in table format then use JSON Source Connector instead. It allows you to extract data from webservice and save to SQL Server or any other target (Oracle, FlatFile, Excel, MySQL). JSON Source component also supports reading local JSON files or direct JSON string.

Download Help File Buy
View All Tasks Like This
ScreenshotsArticles / Useful LinksSystem Requirements
SSIS REST Api Task - HTTP POST, SSIS Call Web Service

SSIS REST API Task – Calling Web Service using POST Method, Pass Request Data, Custom Headers

SSIS REST Api Task - HTTP GET, Test SSIS Web Service Call, Pass Custom Header

SSIS REST API Task – Testing HTTP Web Service using GET Method, Pass Custom Headers

SSIS REST Api Task - HTTP Response Save to File or Variable, Filte using XPATH or JSON PATH

SSIS REST Api Task – HTTP Response Save to File or Variable, Filte using XPATH or JSON PATH

SSIS REST Api Task - Validate Status Code, Content and Header

SSIS REST API Task – Testing HTTP Web Service using GET Method, Pass Custom Headers

SSIS REST Api Task - Advanced settings (SSL/TLS version, Compression, Timeout)

SSIS REST Api Task – Advanced settings (SSL/TLS version, Compression, Timeout)

SSIS REST Api Task - Call Web Service Execution Log

SSIS REST Api Task – Call Web Service Execution Log

See Also

Articles/Posts

Oracle Logo

Oracle CSV Export from Table or Query Data

Contents1 Introduction2 Download and Install ZappyShell Command Line Tools3 Download and Install Oracle Drivers3.1 Sample Oracle ODBC Connection String3.2 Sample Oracle OLEDB Connection String4 Oracle CSV Export – Single table5 Oracle CSV Export – Multiple tables6 Oracle CSV Export – Multiple tables (using pattern)7 Oracle CSV Export – SQL Query8 Oracle CSV Export – Split […]

0 comments
SQl Server Logo

SQL Server Excel Export from Table or Query data

Contents1 Introduction2 The problem3 Solution3.1 Export Tables to CSV Using – ZappyShell Command Line Tools3.2 Export Tables to CSV Using – SSIS Export CSV File Task4 Download and Install ZappyShell Command Line Tools5 SQL Server Excel Export – Single table6 SQL Server Excel Export – Multiple tables7 SQL Server Excel Export – Multiple tables (using […]

0 comments
SQl Server Logo

SQL Server JSON Export from Table or Query Data

Contents1 Introduction2 The problem3 Solution4 Export SQL Server data to JSON using SSIS PowerPack5 Export SQL Server data to JSON using ZappyShell Command line6 SQL Server JSON Export – Single table7 SQL Server JSON Export – Multiple tables8 SQL Server JSON Export – Multiple tables (using pattern)9 SQL Server JSON Export – SQL Query10 Using […]

0 comments
SQl Server Logo

SQL Server CSV Export from Table or Query Data

Contents1 Introduction2 Download and Install ZappyShell Command Line Tools3 Download and Install SQL Server Drivers3.1 Sample ADO.net Connection String (No driver needed)3.2 Sample ODBC Connection String (SQL Native Client Driver)3.3 Sample OLEDB Connection String (SQL Native Client Driver)4 SQL Server CSV Export – Single table5 SQL Server CSV Export – Multiple tables6 SQL Server CSV […]

0 comments
mysql-logo

MySQL CSV Export from Table or Query result

Contents1 Introduction2 Download and Install MySQL ODBC Driver3 Download and Install ZappyShell Command Line Tools4 MySQL CSV Export – Single table5 MySQL CSV Export – Multiple tables6 MySQL CSV Export – Multiple tables (using pattern)7 MySQL CSV Export – SQL Query8 MySQL CSV Export – Split Files8.1 MySQL CSV Export – Split By Row Count8.2 […]

0 comments
mysql-logo

MySQL Excel Export from Table or Query result

Contents1 Introduction2 The problem3 Solution4 Download and Install MySQL ODBC Driver5 Download and Install ZappyShell Command Line Tools6 MySQL Excel Export – Single table7 MySQL Excel Export – Multiple tables8 MySQL Excel Export – Multiple tables (using pattern)9 MySQL Excel Export – SQL Query10 MySQL Excel Export – Split Files and Tabs10.1 MySQL Excel Export […]

1 comment
mysql-logo

MySQL JSON Export from Table or Query result

Contents1 Introduction2 The problem3 Solution4 Download and Install MySQL ODBC Driver5 Download and Install ZappyShell Command Line Tools6 MySQL JSON Export – Single table7 MySQL JSON Export – Multiple tables8 MySQL JSON Export – Multiple tables (using pattern)9 MySQL JSON Export – SQL Query10 Using Map File for nested MySQL JSON Export11 MySQL JSON Export […]

0 comments

References

  • .net framework 3.5 or higher must be installed
  • SSIS Runtime: To execute SSIS package you will need one or more versions of SQL Server Integration Services 2005/2008/2008 R2/2012/2014 or 2016
  • To design SSIS 2012 package SSDT (VS 2010 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2014 package SSDT-BI (VS 2013 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2016 package SSDT-BI (VS 2015 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2005, 2008, 2008 R2 packages BIDS (VS 2005,2008 Shell – Business Intelligence Development Studio) must be installed.
  • Supported Client Operating Systems: Windows 7, Windows 8, Windows 8.1
  • Supported Server Operating Systems: Windows Server 2003/R2, Windows Server 2008/R2, Windows Server 2012/R2
Download View All Tasks Like This