{"id":537,"date":"2016-05-26T17:15:38","date_gmt":"2016-05-26T17:15:38","guid":{"rendered":"http:\/\/zappysys.com\/blog\/?p=537"},"modified":"2017-12-08T17:01:21","modified_gmt":"2017-12-08T17:01:21","slug":"pass-authorization-header-redirected-location","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/pass-authorization-header-redirected-location\/","title":{"rendered":"Calling Web API in SSIS with Authorization and Redirect"},"content":{"rendered":"

Introduction<\/h2>\n

In some cases when you call API to http URL it may redirect you to different location (Also known as 301 or 302 redirect). Best example is when you type https:\/\/www.zappysys.com it will redirect you to https:\/\/zappysys.com. This can cause issue in some case if you are passing credentials (i.e. UserID \/ Password) because by default your credentials are not passed to redirected URL (This is security feature to avoid sending your credentials to different URL than you anticipated). So how to send Authorization to second URL if second URL expects same credentials too? Well not to worry… it’s just one extra step in that case. Lets see how to do that.<\/p>\n

Pass Authorization to 301 \/ 302 Redirect URL<\/h2>\n

Assume that you have to call below API URL which requires Basic Authentication (UserID\/Password)<\/a>\u00a0and it also redirects to some other URL which also needs same credentials. For this purpose we need to mainly perform below important changes.<\/p>\n

http:\/\/httpbin.org\/redirect-to?url=http%3A%2F%2Fexample.com%2F<\/pre>\n
    \n
  1. First drag ZS REST API Task<\/a> from SSIS Control Flow Toolbox<\/li>\n
  2. Change Url mode to URL from connection. Click New Connection.<\/li>\n
  3. Configure your connection with API Url, UrserID and Password as below. Click OK to save connection.\n
  4. Now go to Advanced Tab and Check Prevent 301 redirect option\n
  5. Now go to Response Settings Tab and Map Location Header as below (Assuming you have created SSIS Variable named NewLocation (string type) )\n
  6. Click OK to save.<\/li>\n<\/ol>\n
    Call API URL from URL<\/h2>\n
      \n
    1. Now drag another\u00a0ZS REST API Task<\/a> from SSIS Control Flow Toolbox<\/li>\n
    2. Change Url mode to URL from connection. Select connection created in previous section.<\/li>\n
    3. Now configure your Url as below so we read it from Variable.\n
    4. That’s it Save the task and run package.<\/li>\n<\/ol>\n
      Debug Web API call using Fiddler<\/h2>\n
      To test how things looking behind the scene we strongly suggest to use tool like\u00a0 fiddler<\/a>.<\/p>\n
      See how Fiddler shows 302 Status code for First API call and see how it passes Authorization (UserID\/Password). You can also test Just first task without [Prevent 301\/302 redirect] option see what happens]\n
      \"Debugging<\/a>
      Debugging Web API call using Fiddler in SSIS<\/p><\/div>\n
       <\/p>\n","protected":false},"excerpt":{"rendered":"
      Introduction In some cases when you call API to http URL it may redirect you to different location (Also known as 301 or 302 redirect). Best example is when you type https:\/\/www.zappysys.com it will redirect you to https:\/\/zappysys.com. This can cause issue in some case if you are passing credentials (i.e. UserID \/ Password) because […]<\/p>\n","protected":false},"author":1,"featured_media":2340,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,1],"tags":[123,12,4,144],"yoast_head":"\r\nCalling Web API in SSIS with Authorization and Redirect | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Calling Web API in SSIS with Authorization and Redirect - ZappySys Blog\" \/>\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\/pass-authorization-header-redirected-location\/\" \/>\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 Web API in SSIS with Authorization and Redirect | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Calling Web API in SSIS with Authorization and Redirect - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/pass-authorization-header-redirected-location\/\" \/>\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=\"2016-05-26T17:15:38+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2017-12-08T17:01:21+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/05\/ssis-rest-api-call-301-302-redirect-example.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"897\" \/>\r\n\t<meta property=\"og:image:height\" content=\"713\" \/>\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=\"2 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/pass-authorization-header-redirected-location\/\",\"url\":\"https:\/\/zappysys.com\/blog\/pass-authorization-header-redirected-location\/\",\"name\":\"Calling Web API in SSIS with Authorization and Redirect | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/pass-authorization-header-redirected-location\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/pass-authorization-header-redirected-location\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/05\/ssis-rest-api-call-301-302-redirect-example.png\",\"datePublished\":\"2016-05-26T17:15:38+00:00\",\"dateModified\":\"2017-12-08T17:01:21+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"Calling Web API in SSIS with Authorization and Redirect - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/pass-authorization-header-redirected-location\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/pass-authorization-header-redirected-location\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/pass-authorization-header-redirected-location\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/05\/ssis-rest-api-call-301-302-redirect-example.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/05\/ssis-rest-api-call-301-302-redirect-example.png\",\"width\":897,\"height\":713,\"caption\":\"SSIS REST API Example - Call with 301 \/ 302 Redirect\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/pass-authorization-header-redirected-location\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Calling Web API in SSIS with Authorization and Redirect\"}]},{\"@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 Web API in SSIS with Authorization and Redirect | ZappySys Blog","description":"Calling Web API in SSIS with Authorization and Redirect - ZappySys Blog","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\/pass-authorization-header-redirected-location\/","og_locale":"en_US","og_type":"article","og_title":"Calling Web API in SSIS with Authorization and Redirect | ZappySys Blog","og_description":"Calling Web API in SSIS with Authorization and Redirect - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/pass-authorization-header-redirected-location\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2016-05-26T17:15:38+00:00","article_modified_time":"2017-12-08T17:01:21+00:00","og_image":[{"width":897,"height":713,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/05\/ssis-rest-api-call-301-302-redirect-example.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":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/pass-authorization-header-redirected-location\/","url":"https:\/\/zappysys.com\/blog\/pass-authorization-header-redirected-location\/","name":"Calling Web API in SSIS with Authorization and Redirect | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/pass-authorization-header-redirected-location\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/pass-authorization-header-redirected-location\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/05\/ssis-rest-api-call-301-302-redirect-example.png","datePublished":"2016-05-26T17:15:38+00:00","dateModified":"2017-12-08T17:01:21+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"Calling Web API in SSIS with Authorization and Redirect - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/pass-authorization-header-redirected-location\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/pass-authorization-header-redirected-location\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/pass-authorization-header-redirected-location\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/05\/ssis-rest-api-call-301-302-redirect-example.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/05\/ssis-rest-api-call-301-302-redirect-example.png","width":897,"height":713,"caption":"SSIS REST API Example - Call with 301 \/ 302 Redirect"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/pass-authorization-header-redirected-location\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Calling Web API in SSIS with Authorization and Redirect"}]},{"@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\/537"}],"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=537"}],"version-history":[{"count":2,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/537\/revisions"}],"predecessor-version":[{"id":2345,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/537\/revisions\/2345"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/2340"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=537"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=537"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=537"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}