{"id":66,"date":"2015-10-21T22:08:55","date_gmt":"2015-10-21T22:08:55","guid":{"rendered":"http:\/\/zappysys.com\/blog\/?p=66"},"modified":"2025-10-17T02:02:56","modified_gmt":"2025-10-17T02:02:56","slug":"ssis-rest-api-task-pass-cookies-to-web-request","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-rest-api-task-pass-cookies-to-web-request\/","title":{"rendered":"Working with HTTP Cookies in SSIS or ODBC"},"content":{"rendered":"

Introduction<\/h2>\n

In this post, you will learn how to Parse Cookies from a Response and Pass Cookies to any Web Requests.\u00a0SSIS PowerPack v1.8.2<\/a> introduced a new feature that allows sending and receiving cookies with HTTP Web Request\/Response.<\/p>\n

We will use the SSIS REST API Task<\/a> to parse cookie values and then send cookies <\/strong>along with an HTTP Web Request. Cookies <\/em>are beneficial for maintaining session state across multiple web requests.<\/p>\n

Understanding Cookies<\/h2>\n

Let’s look at an example of\u00a0how Cookie works<\/a>. A cookie is a way of communication. Which means you can pass values to the Server or the Server can pass values to you.<\/p>\n

Getting Cookies from Server (Web Response)<\/strong><\/h3>\n

Many web APIs or sites send you cookies. If you are using a Browser, then it automatically saves for later use. The most common example is login pages. When you authenticate, the server sends cookies back via the Set-Cookie header. The server may send one or more Set-Cookie headers.\u00a0 When you use the SSIS REST API Task<\/a>, you can map such a value on the Response Tab.\u00a0However, one crucial difference is that the REST API Task will\u00a0send only one\u00a0Set-Cookie<\/strong> header, combining all cookies\u00a0<\/span>in Key1=Value1; Key2=Value2 … so on.<\/span> You can use Cookie Tab to Parse each Cookie and save to a separate variable (Explained in the next section)<\/p>\n

Web Request:<\/strong><\/p>\n

POST http:\/\/mysite.com\/login\r\nContent-Type: application\/x-www-form-urlencoded\r\n\r\nuserid=SOME_USER_NAME&password=SOME_PASSWORD\r\n<\/pre>\n
Web Response:<\/strong><\/p>\n
\n
Set-Cookie: SitePreference=MobileVersion\r\nSet-Cookie: SessionId=12345\r\nSet-Cookie: LoginToken=AAA111222; Expires=Wed, 09 Jun 2021 10:18:14 GMT\r\n...\r\n...<\/pre>\n<\/div>\n
Passing Cookies to Server (Web Request)<\/strong><\/h3>\n
The user can pass one or multiple values in the form of Cookies to the server. To pass Cookie (s) to the Server, you have to send the\u00a0 Cookie<\/strong> header as follows<\/p>\n
Web Request:<\/strong><\/p>\n
\n
GET http:\/\/mysite.com\/securepage.html\r\nCookie: LoginToken=AAA1112222; SessionId=1234\r\n...\r\n...<\/pre>\n
 <\/p>\n<\/div>\n
Reading Cookies from Web Response using SSIS<\/h2>\n
SSIS REST API Task<\/a> supports reading cookies in three different ways.<\/span><\/p>\n
Method-1 (for SSIS \/ ODBC): Dynamic Token with Retain Cookie Setting (Using Cookie from Login)<\/h3>\n
In the new version of the HTTP Connection UI, you can find Retain Cookie settings as shown below.<\/p>\n
\"\"<\/a>
Dynamic token configuration<\/p><\/div>\n
\"\"<\/a>
Dynamic token – sending the request<\/p><\/div>\n
If you are not receiving a Token from the response and only want to use Cookies, then set the following way (Enter Fake Regular expression (i.e., word like “SOME-FAKE” is fine )<\/p>\n
\"\"<\/a>
Dynamic token – save the response<\/p><\/div>\n
Method-2 (for SSIS): Reading \/ Parsing Multiple Cookies (Save to SSIS variables)<\/h3>\n
If you like to save cookie value(s) into separate SSIS variable(s), then you can use SSIS REST API Task<\/a> >> Cookie Tab to configure Mappings. Perform the following steps.<\/p>\n
    \n
  1. Configure REST API Task with necessary information (e.g., URL, Headers, Body)<\/li>\n
  2. Go to the Cookie Tab. In the Mapping Grid, enter each Cookie Name and map it to an SSIS Variable, as shown below. When you run the SSIS Package, you will see values stored in the variable.<\/li>\n<\/ol>\n
    \"\"<\/a>
    REST API task – Cookies tab<\/p><\/div>\n
    Method-3 (for SSIS): Read as raw cookie string<\/h3>\n
    Sometimes you may need to see all cookies in key\/value pairs and save them to a variable. If that’s the case, then use the Response setting tab and map the Set-Cookie<\/strong> Response Header to some SSIS Variable.<\/p>\n
    \"\"<\/a>
    REST API task – Raw Cookie<\/p><\/div>\n
    \"\"<\/a>
    Final Result – cookies<\/p><\/div>\n
    Method-4 (for SSIS): Read Cookies \u00a0as CookieContainer<\/h3>\n
    Now, let’s look at how to use the CookieContainer Variable to save the Session across multiple API calls. All you have to do is create an Object datatype variable and select the same variable across various tasks.<\/p>\n
    In the example below, the first task is “Set Cookies”.It’s similar to a Login call in a traditional API call, where you get cookies back from the server. Call web url “http:\/\/httpbin.org\/cookies\/set?k2=val2&k1=myval1”, this generates some cookies and places them into a variable called “varCookies” (Must be Object datatype)<\/p>\n
    In the next step, we call the URL “http:\/\/httpbin.org\/cookies” and pass the previously captured cookies from “varCookies” (Set on the Cookies tab). And the 3rd step displays the response from the URL (this demo URL returns all supplied cookies in JSON format).<\/p>\n
    \"\"<\/a>
    SSIS REST API Task – Send Cookies with HTTP Web Request, Store Cookies in Variable<\/p><\/div>\n
    Pass Cookies to Web API (for SSIS \/ ODBC)<\/h2>\n
    Now, let’s look at how to Pass Cookie (s) along with your Web Request<\/p>\n
    To pass a cookie, you have to use the Cookie HTTP Header. You can pass multiple cookies in a single header as below<\/p>\n
    Cookie : Key1=value1; Key2=Value2<\/pre>\n
    You can use an SSIS variable to pass a dynamic value, as shown in the screenshot below. (e.g. MyCookieName={{User::MyVariable}} )<\/p>\n
    \"\"<\/a>
    REST API task – Cookies inside the header<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"
    Introduction In this post, you will learn how to Parse Cookies from a Response and Pass Cookies to any Web Requests.\u00a0SSIS PowerPack v1.8.2 introduced a new feature that allows sending and receiving cookies with HTTP Web Request\/Response. We will use the SSIS REST API Task to parse cookie values and then send cookies along with […]<\/p>\n","protected":false},"author":1,"featured_media":11562,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[14,15,6,3,12,4],"yoast_head":"\r\nWorking with HTTP Cookies in SSIS or ODBC | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Learn how use SSIS API Task to read cookies from web response, to pass cookie along with web request and making dynamic web request for REST API \/ Web API\" \/>\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\/ssis-rest-api-task-pass-cookies-to-web-request\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Working with HTTP Cookies in SSIS or ODBC | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Learn how use SSIS API Task to read cookies from web response, to pass cookie along with web request and making dynamic web request for REST API \/ Web API\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-rest-api-task-pass-cookies-to-web-request\/\" \/>\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-10-21T22:08:55+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-10-17T02:02:56+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/10\/Dynamic-token-configuration.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"804\" \/>\r\n\t<meta property=\"og:image:height\" content=\"704\" \/>\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=\"6 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-rest-api-task-pass-cookies-to-web-request\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-rest-api-task-pass-cookies-to-web-request\/\",\"name\":\"Working with HTTP Cookies in SSIS or ODBC | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-rest-api-task-pass-cookies-to-web-request\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-rest-api-task-pass-cookies-to-web-request\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/10\/Dynamic-token-configuration.png\",\"datePublished\":\"2015-10-21T22:08:55+00:00\",\"dateModified\":\"2025-10-17T02:02:56+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"Learn how use SSIS API Task to read cookies from web response, to pass cookie along with web request and making dynamic web request for REST API \/ Web API\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-rest-api-task-pass-cookies-to-web-request\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-rest-api-task-pass-cookies-to-web-request\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-rest-api-task-pass-cookies-to-web-request\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/10\/Dynamic-token-configuration.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/10\/Dynamic-token-configuration.png\",\"width\":804,\"height\":704,\"caption\":\"Dynamic token configuration\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-rest-api-task-pass-cookies-to-web-request\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Working with HTTP Cookies in SSIS or ODBC\"}]},{\"@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":"Working with HTTP Cookies in SSIS or ODBC | ZappySys Blog","description":"Learn how use SSIS API Task to read cookies from web response, to pass cookie along with web request and making dynamic web request for REST API \/ Web API","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\/ssis-rest-api-task-pass-cookies-to-web-request\/","og_locale":"en_US","og_type":"article","og_title":"Working with HTTP Cookies in SSIS or ODBC | ZappySys Blog","og_description":"Learn how use SSIS API Task to read cookies from web response, to pass cookie along with web request and making dynamic web request for REST API \/ Web API","og_url":"https:\/\/zappysys.com\/blog\/ssis-rest-api-task-pass-cookies-to-web-request\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2015-10-21T22:08:55+00:00","article_modified_time":"2025-10-17T02:02:56+00:00","og_image":[{"width":804,"height":704,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/10\/Dynamic-token-configuration.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":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/ssis-rest-api-task-pass-cookies-to-web-request\/","url":"https:\/\/zappysys.com\/blog\/ssis-rest-api-task-pass-cookies-to-web-request\/","name":"Working with HTTP Cookies in SSIS or ODBC | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-rest-api-task-pass-cookies-to-web-request\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-rest-api-task-pass-cookies-to-web-request\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/10\/Dynamic-token-configuration.png","datePublished":"2015-10-21T22:08:55+00:00","dateModified":"2025-10-17T02:02:56+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"Learn how use SSIS API Task to read cookies from web response, to pass cookie along with web request and making dynamic web request for REST API \/ Web API","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-rest-api-task-pass-cookies-to-web-request\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-rest-api-task-pass-cookies-to-web-request\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-rest-api-task-pass-cookies-to-web-request\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/10\/Dynamic-token-configuration.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/10\/Dynamic-token-configuration.png","width":804,"height":704,"caption":"Dynamic token configuration"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/ssis-rest-api-task-pass-cookies-to-web-request\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Working with HTTP Cookies in SSIS or ODBC"}]},{"@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\/66"}],"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=66"}],"version-history":[{"count":11,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/66\/revisions"}],"predecessor-version":[{"id":11570,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/66\/revisions\/11570"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/11562"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=66"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=66"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=66"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}