From the below attached email, I want to retrieve the link which redirects to the csv file.
So, I have retrieved the mail messages, put it into a loop , retrieve the download link as a string, then open a browser and navigate to that that link for further download.
Could you please let me know how to modify the expression for downloadable link.
strDownloadableLink = System.Text.RegularExpressions.Regex.Match(item.Body.ToString, “https://[^\s]+”).Value
Hi @supriya117 ,
This did not work for me
Have you tested with item.HTMLBody instead of item.Body?
Try this:
System.Text.RegularExpressions.Regex.Match(currentItem.BodyAsHtml.ToString, “https://[^\s]+”).Value
Hope it will helps you 
Cheers!!
Can you share the download link. It’ll be easy to extract the link from it for downloading file.
You can use Extract Text Activity to get First or All URLs from mail. Change “What to extract” to “URLs” and pass mail.BodyAsHtml as input
Cheers
Hi @Nawazish_Ahmad ,
The download link keeps changing based on the date.
Hi,
To retrieve a specific link from an email that directs to a CSV file, as mentioned in your description, and considering the structure of the email shown in the first image, the Regex pattern needs to specifically target the URL structure that’s typically used for such links. Given that you’ve already set up the logic to loop through emails and identify the link, you just need to refine the Regex pattern.
The pattern you provided ("https://[^\s]+") will match any URL that starts with “https://” and continues until it hits a whitespace. This is a good start, but if there are multiple links in the email body, it will only capture the first one. To ensure you’re capturing the correct CSV file link, you can modify the Regex pattern to be more specific. If the link has a predictable structure, such as always containing the word “download” before the “.csv” part, you can include this in the Regex.
For example, if the link to the CSV file is always in the format https://.../download/.../file.csv, the Regex pattern can be:
strDownloadableLink = System.Text.RegularExpressions.Regex.Match(item.Body.ToString, @“https://[^\s]+/download/[^\s]+.csv”).Value;
This pattern looks for a string that starts with “https://” followed by any characters that are not whitespace, includes “/download/”, and ends with “.csv”. Remember to escape the dot before “csv” since a dot has a special meaning in Regex and you want to match it literally.
Make sure to test the pattern with actual email content to ensure it’s matching correctly. If the structure of the CSV file link varies, you may need a more complex or different pattern.
After setting the strDownloadableLink with the correct Regex pattern, the rest of your process that navigates to the link should work as expected.
Hi @srinivasmarneni ,
One of the sample url would be like below
this link extends and differs based on date
But in the email, it is always Download .csv file.
I have been struggling with this from last day. Could you please help to sort it out.
mailMessages.mailMessages.item.Body.Contains("Download .csv file").strDownloadableLink.System.Text.RegularExpressions.Regex.Match(item.Body.ToString, “href=”“(https?://\S+?.csv)”“”).Groups(1).Value
This pattern matches the href attribute of an anchor tag that points to a .csv file. The \S+? part matches any series of characters that are not whitespace, stopping as soon as it reaches “.csv”.
strDownloadableLink.strDownloadableLink is not empty before trying to navigate.sample code:
Get Mail Messages → Output to ‘mailMessages’
For Each ‘item’ in ‘mailMessages’
If item.Body.Contains(“Download .csv file”)
Then
Assign ‘strDownloadableLink’ with Regex to extract the URL
If ‘strDownloadableLink’ is not empty
Then
Navigate to ‘strDownloadableLink’
Download the file
Else
Log message “Download link not found.”
Else
Log message “Email does not contain the expected text.”
Hi @srinivasmarneni and @rikulsilva ,
I will check both and get back to you.
Complementing the usage of Extract Text activity… after you get all URLs, you can extract the desire one like this (in case there is more than one url in the mail body)
downloadedURL = allURLs.Where(Function (x) x.Contains("csv-exports/org-members/")).First()
Hi @srinivasmarneni ,
as per the step 2, my url does not end with .csv, instead with random ids as below
After extracted desired URL you can use Download File from URL Activity without need change anything
Cheers
Use Same Flow with the below Regex Pattern.
System.Text.RegularExpressions.Regex.Match(currentItem.BodyAsHtml.ToString,“https://figma[^'”\s]+").Value
Hi @srinivasmarneni ,
Based on the condition If it went to Else condition of the If saying email with download link do not exist.
try this…
System.Text.RegularExpressions.Regex.Match(inputString, “pattern”).Value
or
f your pattern includes backslashes (such as for escaping or denoting special regex characters), you would need to double them in VB.NET:
System.Text.RegularExpressions.Regex.Match(inputString, “https:\/\/example\.com”).Value
