Extract URL link behind email body using LogicApps

Question

Extract URL link behind email body using LogicApps

Sergio Antonelli 0

Hi guys,

I'm trying to retrieve a .csv file from a recurring email I receive every day. This .csv is stored within a hyperlink, as seen below: Capture

I've seen one solution using azure functions to retrieve the link, and then submit an http request to get the file downloaded and saved into a blob container, but this didn't really go into much depth in terms of the azure function creation. I have a pretty good idea of what to do once I have the link, but not too sure how to retrieve it. Any ideas?

Thanks in advance!

Sergio

MayankBargali-MSFT 70,896 Reputation points

2023-08-24T04:54:33.0133333+00:00

Hi @Sergio Antonelli

Following up to see if my answer helps. Feel free to get back to me if you need any assistance.

Please "Accept Answer" if the answer is helpful so that it can help others in the community.
MayankBargali-MSFT 70,896 Reputation points

2023-08-28T06:19:37.0066667+00:00

Hi @Sergio Antonelli

I hope the answer helps. Feel free to get back to me if you need any assistance.

Please "Accept Answer" if the answer is helpful so that it can help others in the community.

1 answer

Your answer

MayankBargali-MSFT 70,896 Reputation points

2023-08-24T04:54:33.0133333+00:00

Hi @Sergio Antonelli

Following up to see if my answer helps. Feel free to get back to me if you need any assistance.

Please "Accept Answer" if the answer is helpful so that it can help others in the community.
MayankBargali-MSFT 70,896 Reputation points

2023-08-28T06:19:37.0066667+00:00

Hi @Sergio Antonelli

I hope the answer helps. Feel free to get back to me if you need any assistance.

Please "Accept Answer" if the answer is helpful so that it can help others in the community.

Answer 1

@Sergio Antonelli Thanks for reaching out. There is no out of box feature to get the csv link and you need to use the regex expression to extract the link from the body of your email. You can either use logic app inline code (that needs Integration account) to perform this operation or offload this function to Azure function. For your reference I am share the email body of my trigger and based on my body I have used the regex to extract the link

Email Body Content:

"<html><head>\r\n<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="Generator" content="Microsoft Word 15 (filtered medium)"><style>\r\n\r\n</style></head><body lang="EN-IN" link="#467886" vlink="#96607D" style="word-wrap:break-word"><div class="WordSection1"><p class="MsoNormal">This is the test link</p><p class="MsoNormal"> </p><p class="MsoNormal">This is the test <a href="***" originalsrc="https://testsite/Free_Test_Data_200KB_CSV-1.csv" shash="*">link</a></p></div></body></html>"

User's image

JavaScript Code:

var text = workflowContext.trigger.outputs.body.body;
let match=text.match(/originalsrc="([^"]*)"/)
if (match) {
  return match[1];
} else {
  return String.Empty
}

Note: The above regex is only for reference and may need to change as per your body content of email by the trigger. If you have more than one link then you need to match the csv format as well. Please modify and test the regex at your end.

For your reference sharing the you can refer to the inline document. Once you have the link you can use the HTTP action to call any HTTP/HTTPS native URL.

Feel free to get back to me if you need any assistance.

Please "Accept Answer" if the answer is helpful so that it can help others in the community.

Share via

Extract URL link behind email body using LogicApps

1 answer

Your answer