{"id":9974,"date":"2023-03-27T11:44:37","date_gmt":"2023-03-27T11:44:37","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=9974"},"modified":"2023-03-27T11:44:37","modified_gmt":"2023-03-27T11:44:37","slug":"how-to-get-all-urls-from-emails-from-outlook","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/how-to-get-all-urls-from-emails-from-outlook\/","title":{"rendered":"How to get all URLs from emails from Outlook"},"content":{"rendered":"

Introduction<\/strong><\/h2>\n

This time we will explain how to get all URLS from emails using MS Outlook.\u00a0Sometimes we need get \"\"<\/a>all URLs from emails. In this post, we will show how to do this. Step by step using SSIS.<\/p>\n

Microsoft Graph API<\/a>\u00a0is a unified way to access many Microsoft services API including\u00a0Office 365 API<\/strong><\/p>\n

Prerequisites<\/strong><\/h2>\n

Before we perform steps listed in this article, you will need to make sure following prerequisites are met:<\/p>\n

    \n
  1. SSIS designer installed. Sometimes it is referred as BIDS or SSDT (download it from Microsoft site<\/a>).<\/li>\n
  2. Basic knowledge of SSIS package development using Microsoft SQL Server Integration Services.<\/li>\n
  3. Make sure ZappySys SSIS PowerPack<\/a> is installed (download it<\/a>).<\/li>\n
  4. Optional (If you want to Deploy and Schedule ) – Deploy and Schedule SSIS Packages<\/a><\/li>\n<\/ol>\n

    Steps-by-step process to download images from HTML using SSIS<\/strong><\/h2>\n

    Register Application (OAuth2 App for Graph API)<\/span><\/h3>\n

    First, check our article about how to get the OAuth2 connection, click here for the article<\/a><\/p>\n

    Get the information for the body content from the emails<\/h3>\n

    1. Now, Drag and Drop SSIS\u00a0Data Flow Task<\/b>\u00a0from SSIS Toolbox.<\/p>\n

    Drag and drop Data flow task<\/p><\/div>\n

    2. Double click on the DataFlow task to see the DataFlow designer surface.<\/p>\n

    3. From the SSIS toolbox drag and drop JSON Source on the dataflow designer surface.<\/p>\n

    Drag and drop a JSON sourcec<\/p><\/div>\n

    4. Select the OAuth connection<\/strong> you created, then use this URL to get the body content<\/p>\n

    https:\/\/graph.microsoft.com\/v1.0\/me\/messages?$select=subject,body,bodyPreview,uniqueBody<\/pre>\n
     <\/p>\n
    \"Filter<\/a>
    Getting the information from the emails<\/p><\/div>\n
    5. Drag and drop the trash destination<\/strong> and save the result in a file with the following configuration. Make sure to check the Overwrite target file if exists<\/strong>.<\/p>\n
    \"Add<\/a>
    Save the body from the emails in a file<\/p><\/div>\n
    Now we have saved the email body in the file, to extract the links we need to go control flow and drag and drop the\u00a0Regular Expression Parser Task and follow the steps from below section.<\/p>\n
    Getting all URLs from emails inside a variable<\/h3>\n
    6. The next step is to save the URLs’. We will use the Regular Expression Parser Task for this.
    \nAlso, you need to use Regex and here is one example you can use, in this page\u00a0    Regex101<\/a> you can check more details about the expressions we are using:<\/p>\n
    \"URLs<\/a>
    Getting all URL from the emails<\/p><\/div>\n
    Expression: href=”(.*?)”{{*}}<\/span><\/p>\n
    Save the result in a file of the URLs from emails<\/h3>\n
    7. Finally, use the\u00a0Logging task<\/strong> to save the URLs in a file, use the following configuration<\/p>\n
    \"URLs<\/a>
    Uncheck all options and select message type as none<\/p><\/div>\n
    Conclusion<\/h2>\n
    If everything is OK, you will be able to download the URLS from your emails. To do that, we read the list from the body of the emails. Then we get the URLs of the emails using expressions. Finally, we store them in a local file.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Introduction This time we will explain how to get all URLS from emails using MS Outlook.\u00a0Sometimes we need get all URLs from emails. In this post, we will show how to do this. Step by step using SSIS. Microsoft Graph API\u00a0is a unified way to access many Microsoft services API including\u00a0Office 365 API Prerequisites Before […]<\/p>\n","protected":false},"author":5,"featured_media":10001,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,133],"tags":[610,235],"yoast_head":"\r\nHow to get all URLs from emails from Outlook | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"In this article, we will show how to get URLs from emails and save this information in a file using SQL Server Integration Services.\" \/>\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-get-all-urls-from-emails-from-outlook\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"How to get all URLs from emails from Outlook | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"In this article, we will show how to get URLs from emails and save this information in a file using SQL Server Integration Services.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/how-to-get-all-urls-from-emails-from-outlook\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2023-03-27T11:44:37+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2023\/03\/microsoft-office-365-api-integration-150x150.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"150\" \/>\r\n\t<meta property=\"og:image:height\" content=\"150\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys Team\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 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-get-all-urls-from-emails-from-outlook\/\",\"url\":\"https:\/\/zappysys.com\/blog\/how-to-get-all-urls-from-emails-from-outlook\/\",\"name\":\"How to get all URLs from emails from Outlook | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-all-urls-from-emails-from-outlook\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-all-urls-from-emails-from-outlook\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2023\/03\/microsoft-office-365-api-integration-150x150.png\",\"datePublished\":\"2023-03-27T11:44:37+00:00\",\"dateModified\":\"2023-03-27T11:44:37+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\"},\"description\":\"In this article, we will show how to get URLs from emails and save this information in a file using SQL Server Integration Services.\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-all-urls-from-emails-from-outlook\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/how-to-get-all-urls-from-emails-from-outlook\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-all-urls-from-emails-from-outlook\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2023\/03\/microsoft-office-365-api-integration-150x150.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2023\/03\/microsoft-office-365-api-integration-150x150.png\",\"width\":150,\"height\":150},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-all-urls-from-emails-from-outlook\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to get all URLs from emails from Outlook\"}]},{\"@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\/91b041e2dcf7ece5f068893c1a68ac6e\",\"name\":\"ZappySys Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"caption\":\"ZappySys Team\"},\"sameAs\":[\"https:\/\/zappysys.com\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to get all URLs from emails from Outlook | ZappySys Blog","description":"In this article, we will show how to get URLs from emails and save this information in a file using SQL Server Integration Services.","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-get-all-urls-from-emails-from-outlook\/","og_locale":"en_US","og_type":"article","og_title":"How to get all URLs from emails from Outlook | ZappySys Blog","og_description":"In this article, we will show how to get URLs from emails and save this information in a file using SQL Server Integration Services.","og_url":"https:\/\/zappysys.com\/blog\/how-to-get-all-urls-from-emails-from-outlook\/","og_site_name":"ZappySys Blog","article_published_time":"2023-03-27T11:44:37+00:00","og_image":[{"width":150,"height":150,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2023\/03\/microsoft-office-365-api-integration-150x150.png","type":"image\/png"}],"author":"ZappySys Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/how-to-get-all-urls-from-emails-from-outlook\/","url":"https:\/\/zappysys.com\/blog\/how-to-get-all-urls-from-emails-from-outlook\/","name":"How to get all URLs from emails from Outlook | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/how-to-get-all-urls-from-emails-from-outlook\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/how-to-get-all-urls-from-emails-from-outlook\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2023\/03\/microsoft-office-365-api-integration-150x150.png","datePublished":"2023-03-27T11:44:37+00:00","dateModified":"2023-03-27T11:44:37+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e"},"description":"In this article, we will show how to get URLs from emails and save this information in a file using SQL Server Integration Services.","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/how-to-get-all-urls-from-emails-from-outlook\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/how-to-get-all-urls-from-emails-from-outlook\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/how-to-get-all-urls-from-emails-from-outlook\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2023\/03\/microsoft-office-365-api-integration-150x150.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2023\/03\/microsoft-office-365-api-integration-150x150.png","width":150,"height":150},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/how-to-get-all-urls-from-emails-from-outlook\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to get all URLs from emails from Outlook"}]},{"@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\/91b041e2dcf7ece5f068893c1a68ac6e","name":"ZappySys Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","caption":"ZappySys Team"},"sameAs":["https:\/\/zappysys.com"],"url":"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/9974"}],"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\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=9974"}],"version-history":[{"count":14,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/9974\/revisions"}],"predecessor-version":[{"id":10235,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/9974\/revisions\/10235"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/10001"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=9974"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=9974"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=9974"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}