{"id":195,"date":"2015-11-26T00:02:02","date_gmt":"2015-11-26T00:02:02","guid":{"rendered":"http:\/\/zappysys.com\/blog\/?p=195"},"modified":"2018-02-12T18:36:50","modified_gmt":"2018-02-12T18:36:50","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 &#8211; Send data to Web API url"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p>In our previous article we saw <a href=\"\/\/zappysys.com\/blog\/call-rest-api-using-ssis-web-service-task\/\" target=\"_blank\" rel=\"noopener\">how to call REST API or SOAP Web Service in SSIS<\/a>. In this article we will only focus how to perform <strong>HTTP POST in SSIS<\/strong> using RESTful approach.<\/p>\n<p>HTTP Protocol supports many methods also referred as verb (e.g. GET, PUT, POST, HEAD, DELETE). Based on this verb, target server (API server) can perform desired action. For example GET is usually used for read only data fetch (similar to select query in SQL). POST is usually used to create new record or update existing data.<\/p>\n<p>For any HTTP operation you can submit parameters\/data in 3 ways.<\/p>\n<p>via URL query string<br \/>\nvia HTTP Headers<br \/>\nvia Body (Only valid for operations such as POST, PUT)<\/p>\n<h2>HTTP POST in SSIS<\/h2>\n<p>Traditionally whenever SSIS developers wanted to perform HTTP POST operation in SSIS they had to write <strong>C# Code using Script Task<\/strong>. This is no more case after ZappySys developed easy to use drag and drop REST API Tasks and Connectors. As of now there 4 main connectors\/tasks which supports HTTP POST<\/p>\n<ol>\n<li><a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-web-api-destination-connector\/\" target=\"_blank\" rel=\"noopener\">SSIS Web API Destination<\/a><\/li>\n<li><a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-rest-api-web-service-task\/\" target=\"_blank\" rel=\"noopener\">SSIS REST API Task<\/a><\/li>\n<li><a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/ssis-json-file-source\/\" target=\"_blank\" rel=\"noopener\">SSIS JSON Source<\/a><\/li>\n<li><a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/ssis-xml-source\/\" target=\"_blank\" rel=\"noopener\">SSIS\u00a0XML Source<\/a><\/li>\n<\/ol>\n<p>SSIS PowerPack offers following two methods to POST data from your database to target API URL (e.g. SQL Server to API POST in JSON format).<\/p>\n<h3>Method-1 : HTTP POST using Web API destination (In Data Flow)<\/h3>\n<p>This method allows you to read data from any source and generate POST data and then submit to API endpoint using <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-web-api-destination-connector\/\" target=\"_blank\" rel=\"noopener\">SSIS 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 following screenshot to get idea how API POST works<\/p>\n<p><strong>Step-By-Step : Video Tutorial<\/strong><\/p>\n<div class=\"lyte-wrapper fourthree\" style=\"width:480px;max-width:100%;margin:5px auto;\"><div class=\"lyMe\" id=\"WYL_zE6P5n744WU\"><div id=\"lyte_zE6P5n744WU\" data-src=\"https:\/\/zappysys.com\/blog\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=%2F%2Fi.ytimg.com%2Fvi%2FzE6P5n744WU%2Fhqdefault.jpg\" class=\"pL\"><div class=\"tC\"><div class=\"tT\"><\/div><\/div><div class=\"play\"><\/div><div class=\"ctrl\"><div class=\"Lctrl\"><\/div><div class=\"Rctrl\"><\/div><\/div><\/div><noscript><a href=\"https:\/\/youtu.be\/zE6P5n744WU\" rel=\"nofollow\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FzE6P5n744WU%2F0.jpg\" alt=\"\" width=\"480\" height=\"340\" \/><br \/>Watch this video on YouTube<\/a><\/noscript><\/div><\/div><div class=\"lL\" style=\"max-width:100%;width:480px;margin:5px auto;\"><\/div><br \/>\n<img decoding=\"async\" class=\"figureimage\" title=\"SSIS Web API Destination - POST JSON to REST API Endpoint, Create \/ Update records\" src=\"\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/web-api-destination\/ssis-web-api-destination-post-json-to-rest-api-url.png\" alt=\"SSIS Web API Destination - POST JSON to REST API Endpoint, Create \/ Update records\" \/><\/p>\n<p>You can also extract http response (i.e. JSON or XML) from Web API Destination and parse it into Rows and Columns using <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-json-parser-transform\/\" target=\"_blank\" rel=\"noopener\">JSON Parser Transform<\/a>\u00a0like below. If you want to handle errors gracefully without stopping the execution then use error output (Drag red arrow from Web API destination and attach to downstream (Make sure you set Redirect for Error and Truncate both when prompted on attach)<\/p>\n<p><img decoding=\"async\" class=\"figureimage\" title=\"SSIS Web API Destination - Configure Response output and Error output (Parse JSON response into rows and columns and save to SQL Server)\" src=\"\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/web-api-destination\/ssis-web-api-response-output-error-handling.png\" alt=\"SSIS Web API Destination - Configure Response output and Error output (POST data to API, Parse JSON response into rows and columns and save to SQL Server)\" width=\"800\" \/><\/p>\n<h3>Method-2 : HTTP POST using SSIS REST API Task (In Control Flow)<\/h3>\n<p>REST API Task support many advanced options too incase you want to tweak certain aspects of your POST request.<\/p>\n<p>Here is the screenshot of HTTP POST in JSON format using <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-rest-api-web-service-task\/\" target=\"_blank\" rel=\"noopener\">ZappySys REST API Task<\/a><\/p>\n<div id=\"attachment_1020\" style=\"width: 784px\" class=\"wp-caption alignnone\"><a href=\"\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/11\/ssis-http-post-data-to-api-url-restful-json-web-request.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1020\" class=\"size-full wp-image-1020\" src=\"\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/11\/ssis-http-post-data-to-api-url-restful-json-web-request.png\" alt=\"Perform HTTP POST operation using SSIS REST API Task - Send data in JSON content type\" width=\"774\" height=\"580\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/11\/ssis-http-post-data-to-api-url-restful-json-web-request.png 774w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/11\/ssis-http-post-data-to-api-url-restful-json-web-request-300x225.png 300w\" sizes=\"(max-width: 774px) 100vw, 774px\" \/><\/a><p id=\"caption-attachment-1020\" class=\"wp-caption-text\">Perform HTTP POST operation using SSIS REST API Task &#8211; Send data in JSON content type<\/p><\/div>\n<h2>Parse response into rows\/columns using SSIS JSON Source<\/h2>\n<p>If you wish to POST data and parse JSON response into rows\/columns then you can use <a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/ssis-json-file-source\/\" target=\"_blank\" rel=\"noopener\">SSIS JSON Source<\/a> for this purpose. JSON Source has great JSON Parser which supports parsing very large JSON \u00a0(stored in File or API URL or Direct string) into Rows and Columns. This is useful if you wish to save response into target such as SQL Server or CSV file.<\/p>\n<div id=\"attachment_1022\" style=\"width: 733px\" class=\"wp-caption alignnone\"><a href=\"\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/11\/ssis-post-data-to-url-parse-json-response-using-json-source.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1022\" class=\"size-full wp-image-1022\" src=\"\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/11\/ssis-post-data-to-url-parse-json-response-using-json-source.png\" alt=\"Post JSON data to HTTP URL and parse response into columns and rows\" width=\"723\" height=\"679\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/11\/ssis-post-data-to-url-parse-json-response-using-json-source.png 723w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/11\/ssis-post-data-to-url-parse-json-response-using-json-source-300x282.png 300w\" sizes=\"(max-width: 723px) 100vw, 723px\" \/><\/a><p id=\"caption-attachment-1022\" class=\"wp-caption-text\">Post JSON data to HTTP URL and parse response into columns and rows<\/p><\/div>\n<h2>Parse response into rows\/columns using SSIS XML Source<\/h2>\n<p>If you wish to POST data and parse XML response into rows\/columns then you can use <a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/ssis-xml-source\/\" target=\"_blank\" rel=\"noopener\">SSIS\u00a0XML Source<\/a> for this purpose. XML Source supports parsing XML data (stored in File or API URL or Direct string) into Rows and Columns. This is useful if you wish to save response into target such as SQL Server or CSV file.<\/p>\n<h2>Passing credentials for Web Request for HTTP POST<\/h2>\n<p>Unfortunately there is no one standard for passing credentials to server but good thing is\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-rest-api-web-service-task\/\" target=\"_blank\" rel=\"noopener\">ZappySys REST API Task<\/a> comes with many options to secure your request and pass credentials (Userid\/Password or API Key or OAuth Token).<\/p>\n<h3>Basic Authentication<\/h3>\n<p>Most common approach of passing credentials is userid\/password. <a href=\"https:\/\/zappysys.com\/blog\/how-to-set-base64-encoded-authorization-header-for-http-web-request\/#Passing_Credentials_along_with_HTTP_Web_Request\">Check this article how to use Url from connection<\/a> if you wish to pass credentials using Basic authentication (i.e. Userid\/password).<\/p>\n<h3>OAuth Authentication (1.0 or 2.0)<\/h3>\n<p>If your API support OAuth protocol then check these articles <a href=\"https:\/\/zappysys.com\/blog\/tag\/oauth\/\" target=\"_blank\" rel=\"noopener\">how to use OAuth<\/a> with ZappySys REST connectors<\/p>\n<h2>Passing Parameters in POST Body (Make it dynamic)<\/h2>\n<p>SSIS PowerPack support variable placeholders for many editable text fields (usually indicated by variable icon or pencil icon).<\/p>\n<p>If you wish to pass parameters in your data used in Body then use variable placeholder (e.g. {{User::varMyDate}}. When you edit POST Body you will see &lt;&lt;Insert Variable&gt;&gt; option.<\/p>\n<p>Here is <a href=\"\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/ssis-format-specifiers.htm\" target=\"_blank\" rel=\"noopener\">the complete list of available placeholder functions<\/a><\/p>\n<h2>Upload file using Multi-Part POST<\/h2>\n<p>If you have need to submit data to server from file then <a href=\"https:\/\/zappysys.com\/blog\/rest-api-file-upload-using-ssis-multi-part-post\/\" target=\"_blank\" rel=\"noopener\">check this link<\/a> (its shows few ways to upload file using HTTP POST)<\/p>\n<h2>Most common Content-Type for POST operation<\/h2>\n<p>There are many data formats which you can submit to server using HTTP POST but below is the most common data formats you will ever use for most of scenarios.<\/p>\n<p>Data format is usually determined by server based on Content-Type header you include along with your request.<\/p>\n<h3>HTTP POST Form data &#8211; submit key\/value pairs (application\/x-www-form-urlencoded)<\/h3>\n<p>This is the most common data format for HTTP POST. Its also famous because any type you submit form on any website, most likely it will use below method for submitting your data to server. As you see its key\/value pairs separated by ampersand [&amp;]. Also if some special character found then it needs to be URL encoded (e.g. @ is replaced by %40)<\/p>\n<pre class=\"\">POST https:\/\/myserver.com\/submit\r\nContent-Type: application\/x-www-form-urlencoded\r\n\r\nfirstname=bob&amp;lastname=smith&amp;email=bob%40mycompany.com\r\n<\/pre>\n<h3>HTTP POST JSON data (application\/json content-type)<\/h3>\n<p>JSON is becoming very popular data format so if you are dealing with newer API then most likely you will have to submit your POST request using this content type like below. Assume that you creating new customer record then your request may look like below.<\/p>\n<pre class=\"\">POST https:\/\/myserver.com\/api\/customer\r\nContent-Type: application\/json\r\n\r\n{\r\n \"firstname\" : \"bob\",\r\n \"lastname\" : \"smith\",\r\n \"email\" : \"bob@mycompany.com\"\r\n}\r\n<\/pre>\n<h3>HTTP POST CSV data (text\/plain content-type)<\/h3>\n<p>When API POST required data in CSV format then you have to specify this content type. Below is the example of HTTP POST with CSV data.<\/p>\n<pre class=\"\">POST https:\/\/myserver.com\/api\/customer\r\nContent-Type: text\/plain\r\n\r\nfirstname,lastname,email\r\nbob,smith,bob@mycompany.com\r\n<\/pre>\n<h3>HTTP POST XML data (application\/xml content-type)<\/h3>\n<p>When API POST required data in XML format then you have to specify (application\/xml) content type. Below is the example of HTTP POST with XML data.<\/p>\n<pre class=\"lang:xhtml decode:true\">POST https:\/\/myserver.com\/api\/customer\r\nContent-Type: application\/xml\r\n\r\n&lt;?xml version=\"1.0\"?&gt;\r\n&lt;data&gt;\r\n &lt;firstname&gt;bob&lt;\/firstname&gt;\r\n &lt;lastname&gt;smith&lt;\/lastname&gt;\r\n &lt;email&gt;bob@mycompany.com&lt;\/email&gt;\r\n&lt;\/data&gt;\r\n<\/pre>\n<h3>HTTP POST Binary data (Upload file)<\/h3>\n<p>If you are POSTing large amount of data from file (i.e. uploading file) to your API endpoint then <a href=\"https:\/\/zappysys.com\/blog\/rest-api-file-upload-using-ssis-multi-part-post\/\" target=\"_blank\" rel=\"noopener\">check this article about How to Upload file using Multi-Part Upload<\/a><\/p>\n<h3>HTTP POST Raw data (no content type)<\/h3>\n<p>Do not pass any content-type header to send raw request<\/p>\n<h2>Advanced Read \/ Write Scenarios \/ API Error Handling<\/h2>\n<p>Now let&#8217;s look at some advanced scenario where \u00fdou first have to call one API (GET or POST) using <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-json-file-source\/\" target=\"_blank\" rel=\"noopener\">JSON Source<\/a> or <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-xml-source\/\" target=\"_blank\" rel=\"noopener\">XML Source<\/a> and then POST data to some other URL using <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-web-api-destination-connector\/\" target=\"_blank\" rel=\"noopener\">Web API Destination<\/a>.<\/p>\n<p>Once you get response after POST\/GET parse those records for further processing along with error handling. Such API calls can be achieved using following pattern.<\/p>\n<div class=\"lyte-wrapper fourthree\" style=\"width:480px;max-width:100%;margin:5px auto;\"><div class=\"lyMe qsa_\\&amp;showinfo\\=0\" id=\"WYL_iNhHZH5WLNk\"><div id=\"lyte_iNhHZH5WLNk\" data-src=\"https:\/\/zappysys.com\/blog\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=%2F%2Fi.ytimg.com%2Fvi%2FiNhHZH5WLNk%2Fhqdefault.jpg\" class=\"pL\"><div class=\"tC hidden\"><div class=\"tT\"><\/div><\/div><div class=\"play\"><\/div><div class=\"ctrl\"><div class=\"Lctrl\"><\/div><div class=\"Rctrl\"><\/div><\/div><\/div><noscript><a href=\"https:\/\/youtu.be\/iNhHZH5WLNk\" rel=\"nofollow\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FiNhHZH5WLNk%2F0.jpg\" alt=\"\" width=\"480\" height=\"340\" \/><br \/>Watch this video on YouTube<\/a><\/noscript><\/div><\/div><div class=\"lL\" style=\"max-width:100%;width:480px;margin:5px auto;\"><\/div><\/p>\n<h2>Using Template Transform to build JSON or XML for POST Body<\/h2>\n<p><a href=\"https:\/\/zappysys.com\/blog\/load-sql-server-data-workday-using-ssis-soap-api\/\" target=\"_blank\" rel=\"noopener\">Check this article<\/a> to learn more about some techniques to build JSON or XML for API POST Call (e.g. SOAP )<\/p>\n<h2>Encoding for POST Body<\/h2>\n<p>When using application\/x-www-form-urlencoded content type (POST Form data) your server may require you to encode certain characters in property name or value using URL Encoding technique. As you see below key\/value pairs separated by ampersand [&amp;]. Also if some special character found then it needs to be URL encoded (e.g. @ is replaced by %40). There are many online tools found to encode or decode data using <a href=\"http:\/\/www.bing.com\/search?q=URL+encoding&amp;src=IE-TopResult&amp;FORM=IE11TR&amp;conversationid=\" target=\"_blank\" rel=\"noopener\">URL encoding<\/a> technique.<\/p>\n<pre class=\"lang:default highlight:0 decode:true \">firstname=bob&amp;lastname=smith&amp;email=bob%40mycompany.com<\/pre>\n<pre class=\"\"><\/pre>\n<h2>Troubleshooting \/ Debugging HTTP POST issues using Fiddler<\/h2>\n<p>If you wish to see what&#8217;s being passed to server via any client tool or when you perform POST request ? Use tool called fiddler. Check this article to learn <a href=\"https:\/\/zappysys.com\/blog\/how-to-use-fiddler-to-analyze-http-web-requests\/\" target=\"_blank\" rel=\"noopener\">how to use Fiddler<\/a> for debugging purpose.<\/p>\n<h2>Conclusion<\/h2>\n<p>As we enter into cloud first world you will face more and more need to integrate various RESTful API into your ETL workflows. <a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/\" target=\"_blank\" rel=\"noopener\">SSIS PowerPack<\/a> comes with complete toolset to automate any API calls (Read, Write or Parse). <a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/\" target=\"_blank\" rel=\"noopener\">Try it for free here<\/a> to discover many hidden features not discussed in this article.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction In our previous article we saw how to call REST API or SOAP Web Service in SSIS. In this article we will only focus how to perform HTTP POST in SSIS using RESTful approach. HTTP Protocol supports many methods also referred as verb (e.g. GET, PUT, POST, HEAD, DELETE). Based on this verb, target [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1020,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,200],"tags":[157,15,6,178,12,148,4,144,7],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>HTTP POST in SSIS - Send data to Web API url | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Learn how to do HTTP POST in SSIS. Use SSIS REST API Task or JSON Source connector to POST data to REST API \/ SOAP Web Service without code (e.g C#, JAVA)\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/http-post-in-ssis-send-data-to-web-api-url-json-xml\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"HTTP POST in SSIS - Send data to Web API url | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Learn how to do HTTP POST in SSIS. Use SSIS REST API Task or JSON Source connector to POST data to REST API \/ SOAP Web Service without code (e.g C#, JAVA)\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/http-post-in-ssis-send-data-to-web-api-url-json-xml\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ZappySys\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2015-11-26T00:02:02+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2018-02-12T18:36:50+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/11\/ssis-http-post-data-to-api-url-restful-json-web-request.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"774\" \/>\r\n\t<meta property=\"og:image:height\" content=\"580\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/zappysys\/\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/http-post-in-ssis-send-data-to-web-api-url-json-xml\/\",\"url\":\"https:\/\/zappysys.com\/blog\/http-post-in-ssis-send-data-to-web-api-url-json-xml\/\",\"name\":\"HTTP POST in SSIS - Send data to Web API url | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/http-post-in-ssis-send-data-to-web-api-url-json-xml\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/http-post-in-ssis-send-data-to-web-api-url-json-xml\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/11\/ssis-http-post-data-to-api-url-restful-json-web-request.png\",\"datePublished\":\"2015-11-26T00:02:02+00:00\",\"dateModified\":\"2018-02-12T18:36:50+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"Learn how to do HTTP POST in SSIS. Use SSIS REST API Task or JSON Source connector to POST data to REST API \/ SOAP Web Service without code (e.g C#, JAVA)\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/http-post-in-ssis-send-data-to-web-api-url-json-xml\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/http-post-in-ssis-send-data-to-web-api-url-json-xml\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/http-post-in-ssis-send-data-to-web-api-url-json-xml\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/11\/ssis-http-post-data-to-api-url-restful-json-web-request.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/11\/ssis-http-post-data-to-api-url-restful-json-web-request.png\",\"width\":774,\"height\":580,\"caption\":\"Perform HTTP POST operation using SSIS REST API Task - Send data in JSON content type\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/http-post-in-ssis-send-data-to-web-api-url-json-xml\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"HTTP POST in SSIS &#8211; Send data to Web API url\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"sameAs\":[\"http:\/\/www.zappysys.com\/\",\"https:\/\/www.facebook.com\/ZappySys\/\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/admin\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"HTTP POST in SSIS - Send data to Web API url | ZappySys Blog","description":"Learn how to do HTTP POST in SSIS. Use SSIS REST API Task or JSON Source connector to POST data to REST API \/ SOAP Web Service without code (e.g C#, JAVA)","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/http-post-in-ssis-send-data-to-web-api-url-json-xml\/","og_locale":"en_US","og_type":"article","og_title":"HTTP POST in SSIS - Send data to Web API url | ZappySys Blog","og_description":"Learn how to do HTTP POST in SSIS. Use SSIS REST API Task or JSON Source connector to POST data to REST API \/ SOAP Web Service without code (e.g C#, JAVA)","og_url":"https:\/\/zappysys.com\/blog\/http-post-in-ssis-send-data-to-web-api-url-json-xml\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2015-11-26T00:02:02+00:00","article_modified_time":"2018-02-12T18:36:50+00:00","og_image":[{"width":774,"height":580,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/11\/ssis-http-post-data-to-api-url-restful-json-web-request.png","type":"image\/png"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/zappysys\/","twitter_misc":{"Written by":"ZappySys","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/http-post-in-ssis-send-data-to-web-api-url-json-xml\/","url":"https:\/\/zappysys.com\/blog\/http-post-in-ssis-send-data-to-web-api-url-json-xml\/","name":"HTTP POST in SSIS - Send data to Web API url | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/http-post-in-ssis-send-data-to-web-api-url-json-xml\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/http-post-in-ssis-send-data-to-web-api-url-json-xml\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/11\/ssis-http-post-data-to-api-url-restful-json-web-request.png","datePublished":"2015-11-26T00:02:02+00:00","dateModified":"2018-02-12T18:36:50+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"Learn how to do HTTP POST in SSIS. Use SSIS REST API Task or JSON Source connector to POST data to REST API \/ SOAP Web Service without code (e.g C#, JAVA)","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/http-post-in-ssis-send-data-to-web-api-url-json-xml\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/http-post-in-ssis-send-data-to-web-api-url-json-xml\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/http-post-in-ssis-send-data-to-web-api-url-json-xml\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/11\/ssis-http-post-data-to-api-url-restful-json-web-request.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/11\/ssis-http-post-data-to-api-url-restful-json-web-request.png","width":774,"height":580,"caption":"Perform HTTP POST operation using SSIS REST API Task - Send data in JSON content type"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/http-post-in-ssis-send-data-to-web-api-url-json-xml\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"HTTP POST in SSIS &#8211; Send data to Web API url"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","caption":"ZappySys"},"sameAs":["http:\/\/www.zappysys.com\/","https:\/\/www.facebook.com\/ZappySys\/","https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/"],"url":"https:\/\/zappysys.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/195"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=195"}],"version-history":[{"count":20,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/195\/revisions"}],"predecessor-version":[{"id":11578,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/195\/revisions\/11578"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/1020"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=195"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=195"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}