SSIS Web API Destination - POST data to URL and parse response (REST, SOAP, JSON, XML)

Learn how to POST data to API in few clicks. Integrate REST API in your SQL Server environment using SSIS drag and drop components.

SSIS Web API Destination can be used to POST data to any API end point such as JSON API (i.e. POST to REST API) or POST to XML API (i.e. SOAP Web Service). This task provides several advanced options which makes it possible to connect virtually any API Service.

Features
• POST data to any API endpoint without coding (Read more…)
• Support for windows / basic authentication, client certificate and OAuth (Read more…)
• Support for File upload, REST API POST using Multipart/form-data (Read more…)
• Support for Cookies (Read more…)
• Support for Response Output (includes ResponseText and StatusCode)
• Support for Error Output (Redirect failed request)
• Support for easy Test UI (see request/response)
• Support for Bulk Mode (Group multiple requests into single body)
• Support for advanced options (e.g. 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}} )
• Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)

[jclee]

Can you please confirm if SSIS REST API Web Service Task is free if I have subscription of Visual Studio 2019?

[oscarnaranjo]

esto es buen pero no es practico, en una empresa no te permiten la instalación de herramientas externas y debes solucionar por código