Download file from HTTPS link received in email: Logic Apps

Jon Graber 1 Reputation point
2020-07-06T15:48:20.247+00:00

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

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,842 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Samara Soucy - MSFT 5,051 Reputation points
    2020-07-10T02:45:26.853+00:00

    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:
    11754-2020-07-09-22-43-18-logic-apps-designer-microsoft.png

    0 comments