Download file from HTTPS link received in email: Logic Apps

Question

I am currently receiving an email that links to a report that I will want to download. I am wanting to automate this via logic apps but am unsure how to proceed.

1) The email tells me the newest version of the report i want to download that has a link that takes me to the repository.

2) The reports are situated in a single URL and it looks like I would need to tell Logic Apps which one to download.

3) The URL is for a workday report

I created a simple Logic App that uses a "GET" with the report URL in it and that seems to work. However, how do I make this dynamic so it always grabs the most recent report instead of one that I hard code into the URL?

Thanks

Answer 1

As long as there's a programmatic way to generate the url for the most recent report you can use an expression inside the URI field to set the value dynamically. This could be something like a data parameter or something you pass into the app trigger.

For example, if I have a date parameter in the report url, I can get the current date and format it into my query string: