{"id":195,"date":"2015-11-26T00:02:02","date_gmt":"2015-11-26T00:02:02","guid":{"rendered":"http:\/\/zappysys.com\/blog\/?p=195"},"modified":"2026-06-19T12:32:12","modified_gmt":"2026-06-19T12:32:12","slug":"http-post-in-ssis-send-data-to-web-api-url-json-xml","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/http-post-in-ssis-send-data-to-web-api-url-json-xml\/","title":{"rendered":"HTTP POST in SSIS – Send data to Web API url"},"content":{"rendered":"

Introduction<\/h2>\n

In our previous article, we saw\u00a0how to call a REST API or a SOAP Web Service in SSIS<\/a>. In this article, we will focus only on how to perform an HTTP POST in SSIS<\/strong> using a RESTful approach.<\/p>\n

HTTP Protocol supports many methods, also referred to as verbs (e.g. GET, PUT, POST, HEAD, DELETE). Based on this verb, the target server (API server) can perform the desired action. For example, GET is usually used for read-only data fetch (similar to a select query in SQL). POST is usually used to create a new record or update existing data.<\/p>\n

For any HTTP operation, you can submit parameters\/data in 3 ways.<\/p>\n

via URL query string
\nvia HTTP Headers
\nvia Body (Only valid for operations such as POST, PUT)<\/p>\n

HTTP POST in SSIS<\/h2>\n

Traditionally, when SSIS developers wanted to perform an HTTP POST operation, they had to write C# Code using a Script Task<\/strong>. This is no longer the case after ZappySys developed easy-to-use drag-and-drop REST API Tasks and Connectors. As of now, 4 main connectors\/tasks support HTTP POST.<\/p>\n

    \n
  1. SSIS Web API Destination<\/a><\/li>\n
  2. SSIS REST API Task<\/a><\/li>\n
  3. SSIS JSON Source<\/a><\/li>\n
  4. SSIS\u00a0XML Source<\/a><\/li>\n<\/ol>\n

    SSIS PowerPack offers two methods to POST data from your database to the target API URL (e.g., SQL Server to API POST in JSON format).<\/p>\n

    Method-1: HTTP POST using Web API destination (In Data Flow)<\/h3>\n

    This method allows you to read data from any source, generate POST data, and then submit to an API endpoint using the\u00a0SSIS Web API Destination<\/a>. Using this destination, you can configure URL and API Body (e.g. JSON\/XML document you want to submit) for each request. Check the following screenshot to get an idea of how API POST works<\/p>\n

    Step-By-Step: Video Tutorial<\/strong><\/p>\n

    <\/div><\/div>
    <\/div>
    <\/div>
    <\/div><\/div><\/div>