I receive a daily email that contains the out of a report in a csv file. The csv file is not attached, but is hosted at AWS and the link to the file is included in the body of the email.
I can use the link with an HTTP get task to pull down the csv file, but the link is unique each day with randomized characters.
I would like to create job to read the body of the email, parse it for the link, store the link in a variable and use that in the http task.
Is there some way to use a task or a trigger to check an email and ready the body so that I can parse it?
I used an email trigger to download the message and store it in a file, but when I open the message file, the body is encoded.