How do I bring data using URL (with Azure Logic App)?

King Java 390 Reputation points
2023-09-05T21:06:51.86+00:00

I am trying to retrieve data using URL on a daily basis (data gets populated in a csv file).

(I figured Azure Logic App would do it, but I am not sure Azure Data Factory is a necessary tool.)

Basically, I have a URL with two date parameter that if I just run the URL in the browser, the output is in a csv file.

As you can see on the bottom, there are two areas with date ranges (possibly using some type of expression for those two parameters).

If I just change the date range, I would get the different data, with the final result in a csv file.

https://portal.test.com/care_ctr/reports/report/census/email?uname=jdoe@fakecompany.com&start_date=2023-09-05&end_date=2023-09-05&facility=0&division=0

If I use Azure Logic App, which object should I use?

If Azure Logic App cannot do the job, I would have to modify this post's Tag to ask Azure Data Factory.

Thanks.

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,400 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Pramod Valavala 17,551 Reputation points Microsoft Employee
    2023-09-22T16:26:24.01+00:00

    @King Java Apologies for the delay here! Glad you were able to solve till creating a file with the content.

    If you are looking to download files and don't specifically need Azure File Storage, it would be better to create a file in Blob Storage instead using the Azure Blob Storage Connector instead.

    With this, you can use the Create SAS URI by path (V2) action to generate a URL that can be used to download the file. You could extend the workflow to send this URL in an email, teams message, or into an excel sheet for example.