{"id":34,"date":"2015-08-27T20:58:17","date_gmt":"2015-08-27T20:58:17","guid":{"rendered":"http:\/\/zappysys.com\/blog\/?p=34"},"modified":"2025-03-19T07:05:07","modified_gmt":"2025-03-19T07:05:07","slug":"how-to-set-base64-encoded-authorization-header-for-http-web-request","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/how-to-set-base64-encoded-authorization-header-for-http-web-request\/","title":{"rendered":"Calling REST API in SSIS with Basic Authentication \/ Userid-Password (BASE64 Authorization header)"},"content":{"rendered":"

Introduction<\/h2>\n

In this blog post you will explain how to pass basic credentials (i.e. UserID\/Password) along with your web request. You will also learn about setting up Authorization Header for HTTP Web Request in Base64 manually. To learn more about how to consume \/ call REST API in SSIS check this article<\/a>.<\/p>\n

HTTP Authorization Header basics<\/h2>\n

As per HTTP Standard you can pass credentials very simple way using basic Authorization header. Below is the sample of Basic Authorization header.<\/p>\n

As you can see it consist of HeaderName=Authorization and Value=some base64 encoded string<\/em>
\nAuthorization: Basic QWxhZGRpbjpvcGVuIHNlc2FtZQ==<\/code>
\nAs per standard Base64 encoded string is made up with two elements. your_userid:your_password<\/em><\/p>\n

NOTE:<\/strong> Base64 is encoding and not encryption method. So never hand over your encoded Authorization header string to anyone. Anyone can decode Base64 encoded string easily by using tools like this<\/a><\/p><\/blockquote>\n

Passing Basic Credentials along with HTTP Web Request<\/h2>\n

You can pass credentials (i.e. UserID\/Password) in two different ways.<\/p>\n

    \n
  1. Automatic approach – Using ZS-HTTP Connection Manager<\/a> (BASE64 Encoded Header automatically generated)<\/li>\n
  2. Manual approach – Supplying Authorization where UserID\/Password encoded as Base64<\/li>\n<\/ol>\n

    Automatic approach – Using ZS-HTTP Connection Manager<\/h3>\n

    Now lets look at how to use automatic approach to pass Basic Authorization in following 3 different tasks\/components<\/p>\n

      \n
    1. Passing basic credentials in\u00a0SSIS REST API Task<\/a><\/li>\n
    2. Passing basic credentials in\u00a0SSIS JSON Source<\/a><\/li>\n
    3. Passing basic credentials in\u00a0SSIS XML Source<\/a><\/li>\n<\/ol>\n

      Using SSIS REST API Task (Pass Basic credentials using Connection Manager)<\/h4>\n

      The simplest way to pass credentials is use HTTP Connection Manager. If you are using REST API Task<\/a> then you can use Url from Connection<\/strong> Access Mode. And on connection manager specify UserId and password to pass Basic Authorization Header <\/strong><\/p>\n

      Advantages of this method are..
      \n1) Its very simple
      \n2)\u00a0Credentials are encrypted in SSIS Package<\/p>\n

      NOTE:<\/strong> We recommend using https<\/strong>:\/\/ Urls whenever possible otherwise your web request can be decoded in plain text by any servers sitting between you and target and possibly they can get your password by decoding base64 header.<\/p><\/blockquote>\n

      \"SSIS<\/div>\n
      <\/div>\n
      Analyze Base64 Encoded HTTP Authorization Header generated by HTTP Connection Manager<\/strong><\/div>\n
      You can analyze Webrequest in some 3rd party Free Debugging tools such as Fiddler (Check this article<\/a>). As you see how its sending Authorization header in Base64 encoded string.<\/div>\n
      <\/div>\n
      \"Base64
      \nBase64 Encoded HTTP Basic Authorization Header – View in Fiddler<\/div>\n

      Using SSIS JSON\/XML Source \u00a0(Pass Basic credentials using Connection Manager)<\/h4>\n

      You can use HTTP Connection manager in JSON Source<\/a> and XML Source<\/a> too. Only difference is you have to check Use Credentials checkbox and select HTTP connection manager from available connection managers dropdown.<\/p>\n

        \n
      1. Select AccessMode as “File Path or Web URL”<\/li>\n
      2. Enter API URL<\/li>\n
      3. Check “Use Credentials” option<\/li>\n
      4. Click “New” next to Connection dropdown or select New “ZS-HTTP” connection from dropdown<\/li>\n
      5. Configure HTTP Connection as below (i.e. Enter URL, Select Basic Auth, Enter UserID, Password)<\/li>\n
      6. Clock OK on HTTP connection manager UI to save and now Test JSON or XML Source UI by clicking Preview (Assuming no other configuration needed)<\/li>\n<\/ol>\n
        \"SSIS<\/a>

        SSIS JSON Source – Passing Basic Credentials (Supply UserID \/ Password) using HTTP Connection<\/p><\/div>\n

        Manual approach – Supplying Authorization where UserID\/Password encoded as Base64<\/h3>\n

        Our JSON Source<\/a>, XML Source<\/a> and REST API Task <\/a> they all support passing BASE64 Encoded String for Authorization header (see below screenshot). Setting up userid and password in HTTP Connection Manger would do same trick as setting up it manually.<\/p>\n

        To encode any Header value in BASE64 format you simply have to add BASE64ENC format specifier after variable name.<\/p>\n

        Example: {{User::varUserAndPassword,BASE64ENC<\/strong>}}<\/p>\n

         <\/p>\n

        \"SSIS
        \nSSIS JSON Source Task – Pass Base64 Encoded HTTP Authorization Header<\/div>\n
        \"Base64<\/div>\n

        Reference<\/h2>\n

        Wikipedia Article – HTTP Basic Authorization Header<\/a><\/p>\n

        Download FREE SSIS Components<\/h2>\n

        <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

        Introduction In this blog post you will explain how to pass basic credentials (i.e. UserID\/Password) along with your web request. You will also learn about setting up Authorization Header for HTTP Web Request in Base64 manually. To learn more about how to consume \/ call REST API in SSIS check this article. HTTP Authorization Header […]<\/p>\n","protected":false},"author":1,"featured_media":10398,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,17],"tags":[147,123,6,3,12,226,148,4,144,140],"yoast_head":"\r\nCalling REST API in SSIS with Basic Authentication \/ Userid-Password (BASE64 Authorization header) | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Learn how to call REST API in SSIS and Supply Basic Credentials (e.g. Pass Userid \/ Password) using HTTP Connection Manager or Manual way (BASE64 Header)\" \/>\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\/how-to-set-base64-encoded-authorization-header-for-http-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=\"Calling REST API in SSIS with Basic Authentication \/ Userid-Password (BASE64 Authorization header) | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Learn how to call REST API in SSIS and Supply Basic Credentials (e.g. Pass Userid \/ Password) using HTTP Connection Manager or Manual way (BASE64 Header)\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/how-to-set-base64-encoded-authorization-header-for-http-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-08-27T20:58:17+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-03-19T07:05:07+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/how-to-set-base64-encoded-authorization-header-for-http-web-request-1.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"830\" \/>\r\n\t<meta property=\"og:image:height\" content=\"751\" \/>\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=\"4 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-set-base64-encoded-authorization-header-for-http-web-request\/\",\"url\":\"https:\/\/zappysys.com\/blog\/how-to-set-base64-encoded-authorization-header-for-http-web-request\/\",\"name\":\"Calling REST API in SSIS with Basic Authentication \/ Userid-Password (BASE64 Authorization header) | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-set-base64-encoded-authorization-header-for-http-web-request\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-set-base64-encoded-authorization-header-for-http-web-request\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/how-to-set-base64-encoded-authorization-header-for-http-web-request-1.png\",\"datePublished\":\"2015-08-27T20:58:17+00:00\",\"dateModified\":\"2025-03-19T07:05:07+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"Learn how to call REST API in SSIS and Supply Basic Credentials (e.g. Pass Userid \/ Password) using HTTP Connection Manager or Manual way (BASE64 Header)\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-set-base64-encoded-authorization-header-for-http-web-request\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/how-to-set-base64-encoded-authorization-header-for-http-web-request\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-set-base64-encoded-authorization-header-for-http-web-request\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/how-to-set-base64-encoded-authorization-header-for-http-web-request-1.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/how-to-set-base64-encoded-authorization-header-for-http-web-request-1.png\",\"width\":830,\"height\":751},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-set-base64-encoded-authorization-header-for-http-web-request\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Calling REST API in SSIS with Basic Authentication \/ Userid-Password (BASE64 Authorization header)\"}]},{\"@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":"Calling REST API in SSIS with Basic Authentication \/ Userid-Password (BASE64 Authorization header) | ZappySys Blog","description":"Learn how to call REST API in SSIS and Supply Basic Credentials (e.g. Pass Userid \/ Password) using HTTP Connection Manager or Manual way (BASE64 Header)","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\/how-to-set-base64-encoded-authorization-header-for-http-web-request\/","og_locale":"en_US","og_type":"article","og_title":"Calling REST API in SSIS with Basic Authentication \/ Userid-Password (BASE64 Authorization header) | ZappySys Blog","og_description":"Learn how to call REST API in SSIS and Supply Basic Credentials (e.g. Pass Userid \/ Password) using HTTP Connection Manager or Manual way (BASE64 Header)","og_url":"https:\/\/zappysys.com\/blog\/how-to-set-base64-encoded-authorization-header-for-http-web-request\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2015-08-27T20:58:17+00:00","article_modified_time":"2025-03-19T07:05:07+00:00","og_image":[{"width":830,"height":751,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/how-to-set-base64-encoded-authorization-header-for-http-web-request-1.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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/how-to-set-base64-encoded-authorization-header-for-http-web-request\/","url":"https:\/\/zappysys.com\/blog\/how-to-set-base64-encoded-authorization-header-for-http-web-request\/","name":"Calling REST API in SSIS with Basic Authentication \/ Userid-Password (BASE64 Authorization header) | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/how-to-set-base64-encoded-authorization-header-for-http-web-request\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/how-to-set-base64-encoded-authorization-header-for-http-web-request\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/how-to-set-base64-encoded-authorization-header-for-http-web-request-1.png","datePublished":"2015-08-27T20:58:17+00:00","dateModified":"2025-03-19T07:05:07+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"Learn how to call REST API in SSIS and Supply Basic Credentials (e.g. Pass Userid \/ Password) using HTTP Connection Manager or Manual way (BASE64 Header)","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/how-to-set-base64-encoded-authorization-header-for-http-web-request\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/how-to-set-base64-encoded-authorization-header-for-http-web-request\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/how-to-set-base64-encoded-authorization-header-for-http-web-request\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/how-to-set-base64-encoded-authorization-header-for-http-web-request-1.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/how-to-set-base64-encoded-authorization-header-for-http-web-request-1.png","width":830,"height":751},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/how-to-set-base64-encoded-authorization-header-for-http-web-request\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Calling REST API in SSIS with Basic Authentication \/ Userid-Password (BASE64 Authorization header)"}]},{"@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\/34"}],"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=34"}],"version-history":[{"count":10,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/34\/revisions"}],"predecessor-version":[{"id":11249,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/34\/revisions\/11249"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/10398"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=34"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=34"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=34"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}