{"id":7631,"date":"2024-01-27T20:10:21","date_gmt":"2024-01-27T20:10:21","guid":{"rendered":"https:\/\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg"},"modified":"2024-01-27T20:11:52","modified_gmt":"2024-01-27T20:11:52","slug":"excel-get-data-from-web","status":"inherit","type":"attachment","link":"https:\/\/haydentechnology.com\/htblog\/2024\/01\/exceleration-import-jira-data-into-excel-using-power-query-and-jira-rest-api\/excel-get-data-from-web\/","title":{"rendered":"Excel Get Data from Web"},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"jetpack_post_was_ever_published":false},"class_list":["post-7631","attachment","type-attachment","status-inherit","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel Get Data from Web - Innovative Consulting for banks and credit unions<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Get Data from Web - Innovative Consulting for banks and credit unions\" \/>\n<meta property=\"og:description\" content=\"Excel Power Query Get Data from JIRA\" \/>\n<meta property=\"og:url\" content=\"https:\/\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg\" \/>\n<meta property=\"og:site_name\" content=\"Innovative Consulting for banks and credit unions\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-27T20:11:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?fit=2198%2C1390&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"2198\" \/>\n\t<meta property=\"og:image:height\" content=\"1390\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@mwoollen\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg\",\"url\":\"https:\/\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg\",\"name\":\"Excel Get Data from Web - Innovative Consulting for banks and credit unions\",\"isPartOf\":{\"@id\":\"https:\/\/haydentechnology.com\/htblog\/#website\"},\"datePublished\":\"2024-01-27T20:10:21+00:00\",\"dateModified\":\"2024-01-27T20:11:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/haydentechnology.com\/htblog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Get Data from Web\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/haydentechnology.com\/htblog\/#website\",\"url\":\"https:\/\/haydentechnology.com\/htblog\/\",\"name\":\"Innovative Consulting for banks and credit unions\",\"description\":\"Hayden Technology provides innovative thought leadership, complex program management and Agile technology delivery for banks and credit Unions\",\"publisher\":{\"@id\":\"https:\/\/haydentechnology.com\/htblog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/haydentechnology.com\/htblog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/haydentechnology.com\/htblog\/#organization\",\"name\":\"Innovative Consulting for banks and credit unions\",\"url\":\"https:\/\/haydentechnology.com\/htblog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/haydentechnology.com\/htblog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/09\/HT-full-transparentBG.png?fit=3000%2C800&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/09\/HT-full-transparentBG.png?fit=3000%2C800&ssl=1\",\"width\":3000,\"height\":800,\"caption\":\"Innovative Consulting for banks and credit unions\"},\"image\":{\"@id\":\"https:\/\/haydentechnology.com\/htblog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/mwoollen\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Get Data from Web - Innovative Consulting for banks and credit unions","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:\/\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg","og_locale":"en_US","og_type":"article","og_title":"Excel Get Data from Web - Innovative Consulting for banks and credit unions","og_description":"Excel Power Query Get Data from JIRA","og_url":"https:\/\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg","og_site_name":"Innovative Consulting for banks and credit unions","article_modified_time":"2024-01-27T20:11:52+00:00","og_image":[{"width":2198,"height":1390,"url":"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?fit=2198%2C1390&ssl=1","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_site":"@mwoollen","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg","url":"https:\/\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg","name":"Excel Get Data from Web - Innovative Consulting for banks and credit unions","isPartOf":{"@id":"https:\/\/haydentechnology.com\/htblog\/#website"},"datePublished":"2024-01-27T20:10:21+00:00","dateModified":"2024-01-27T20:11:52+00:00","breadcrumb":{"@id":"https:\/\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/haydentechnology.com\/htblog\/"},{"@type":"ListItem","position":2,"name":"Excel Get Data from Web"}]},{"@type":"WebSite","@id":"https:\/\/haydentechnology.com\/htblog\/#website","url":"https:\/\/haydentechnology.com\/htblog\/","name":"Innovative Consulting for banks and credit unions","description":"Hayden Technology provides innovative thought leadership, complex program management and Agile technology delivery for banks and credit Unions","publisher":{"@id":"https:\/\/haydentechnology.com\/htblog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/haydentechnology.com\/htblog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/haydentechnology.com\/htblog\/#organization","name":"Innovative Consulting for banks and credit unions","url":"https:\/\/haydentechnology.com\/htblog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/haydentechnology.com\/htblog\/#\/schema\/logo\/image\/","url":"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/09\/HT-full-transparentBG.png?fit=3000%2C800&ssl=1","contentUrl":"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/09\/HT-full-transparentBG.png?fit=3000%2C800&ssl=1","width":3000,"height":800,"caption":"Innovative Consulting for banks and credit unions"},"image":{"@id":"https:\/\/haydentechnology.com\/htblog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/mwoollen"]}]}},"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/a9CfAC-1Z5","jetpack_likes_enabled":true,"featured_media_urls":{"thumbnail":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?resize=150%2C150&ssl=1",150,150,true],"medium":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?fit=300%2C190&ssl=1",300,190,true],"medium_large":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?fit=768%2C486&ssl=1",768,486,true],"large":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?fit=840%2C532&ssl=1",840,532,true],"1536x1536":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?fit=1536%2C971&ssl=1",1536,971,true],"2048x2048":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?fit=2048%2C1295&ssl=1",2048,1295,true],"post-thumbnail":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?fit=1200%2C759&ssl=1",1200,759,true],"portfolio_item-thumbnail":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?resize=600%2C400&ssl=1",600,400,true],"portfolio_item-thumbnail@2x":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?resize=1200%2C800&ssl=1",1200,800,true],"portfolio_item-masonry":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?fit=600%2C379&ssl=1",600,379,true],"portfolio_item-masonry@2x":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?fit=1200%2C759&ssl=1",1200,759,true],"portfolio_item-thumbnail_cinema":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?resize=800%2C335&ssl=1",800,335,true],"portfolio_item-thumbnail_portrait":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?resize=600%2C900&ssl=1",600,900,true],"portfolio_item-thumbnail_portrait@2x":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?resize=1200%2C1390&ssl=1",1200,1390,true],"portfolio_item-thumbnail_square":["https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?resize=800%2C800&ssl=1",800,800,true]},"description":{"rendered":"<p class=\"attachment\"><a href=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?ssl=1\"><img fetchpriority=\"high\" decoding=\"async\" width=\"300\" height=\"190\" src=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?fit=300%2C190&amp;ssl=1\" class=\"attachment-medium size-medium\" alt=\"Excel Get JIRA Data from Web\" srcset=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?w=2198&amp;ssl=1 2198w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?resize=300%2C190&amp;ssl=1 300w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?resize=1024%2C648&amp;ssl=1 1024w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?resize=2000%2C1265&amp;ssl=1 2000w, https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?w=1680&amp;ssl=1 1680w\" sizes=\"(max-width: 300px) 85vw, 300px\" data-attachment-id=\"7631\" data-permalink=\"https:\/\/haydentechnology.com\/htblog\/2024\/01\/exceleration-import-jira-data-into-excel-using-power-query-and-jira-rest-api\/excel-get-data-from-web\/\" data-orig-file=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?fit=2198%2C1390&amp;ssl=1\" data-orig-size=\"2198,1390\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Excel Get Data from Web\" data-image-description=\"&lt;p&gt;Excel Power Query Get Data from JIRA&lt;\/p&gt;\n\" data-image-caption=\"&lt;p&gt;Excel Power Query Get Data from JIRA&lt;\/p&gt;\n\" data-medium-file=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?fit=300%2C190&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?fit=840%2C532&amp;ssl=1\" \/><\/a><\/p>\n<p>Excel Power Query Get Data from JIRA<\/p>\n"},"caption":{"rendered":"<p>Excel Power Query Get Data from JIRA<\/p>\n"},"alt_text":"Excel Get JIRA Data from Web","media_type":"image","mime_type":"image\/jpeg","media_details":{"width":2198,"height":1390,"file":"2022\/08\/Excel-Get-Data-from-Web.jpg","filesize":406318,"sizes":{"medium":{"file":"Excel-Get-Data-from-Web-300x190.jpg","width":300,"height":190,"filesize":12104,"mime_type":"image\/jpeg","source_url":"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?fit=300%2C190&ssl=1"},"large":{"file":"Excel-Get-Data-from-Web-1024x648.jpg","width":1024,"height":648,"filesize":89691,"mime_type":"image\/jpeg","source_url":"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?fit=840%2C532&ssl=1"},"thumbnail":{"file":"Excel-Get-Data-from-Web-150x150.jpg","width":150,"height":150,"filesize":4716,"mime_type":"image\/jpeg","source_url":"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?resize=150%2C150&ssl=1"},"inspiro-featured-image":{"file":"Excel-Get-Data-from-Web-2000x1265.jpg","width":2000,"height":1265,"filesize":239882,"mime_type":"image\/jpeg","source_url":"https:\/\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web-2000x1265.jpg"},"inspiro-loop":{"file":"Excel-Get-Data-from-Web-950x320.jpg","width":950,"height":320,"filesize":41561,"mime_type":"image\/jpeg","source_url":"https:\/\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web-950x320.jpg"},"inspiro-loop@2x":{"file":"Excel-Get-Data-from-Web-1900x640.jpg","width":1900,"height":640,"filesize":116856,"mime_type":"image\/jpeg","source_url":"https:\/\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web-1900x640.jpg"},"portfolio_item-thumbnail":{"file":"Excel-Get-Data-from-Web-600x400.jpg","width":600,"height":400,"filesize":39597,"mime_type":"image\/jpeg","source_url":"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?resize=600%2C400&ssl=1"},"portfolio_item-thumbnail@2x":{"file":"Excel-Get-Data-from-Web-1200x800.jpg","width":1200,"height":800,"filesize":116827,"mime_type":"image\/jpeg","source_url":"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?resize=1200%2C800&ssl=1"},"full":{"file":"Excel-Get-Data-from-Web.jpg?fit=2198%2C1390&ssl=1","width":2198,"height":1390,"mime_type":"image\/jpeg","source_url":"https:\/\/i0.wp.com\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg?fit=2198%2C1390&ssl=1"}},"image_meta":{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0","keywords":[]}},"post":7396,"source_url":"https:\/\/haydentechnology.com\/htblog\/wp-content\/uploads\/2022\/08\/Excel-Get-Data-from-Web.jpg","_links":{"self":[{"href":"https:\/\/haydentechnology.com\/htblog\/wp-json\/wp\/v2\/media\/7631","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/haydentechnology.com\/htblog\/wp-json\/wp\/v2\/media"}],"about":[{"href":"https:\/\/haydentechnology.com\/htblog\/wp-json\/wp\/v2\/types\/attachment"}],"author":[{"embeddable":true,"href":"https:\/\/haydentechnology.com\/htblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/haydentechnology.com\/htblog\/wp-json\/wp\/v2\/comments?post=7631"}]}}