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

Question

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

King Java 390

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.

Pramod Valavala 17,551 Reputation points Microsoft Employee

2023-09-05T22:16:48.5333333+00:00

@King Java You should be able to use either service to fetch the data from the URL but knowing what you intend to do with the data after retrieval should help suggest the right service to use.

Could you elaborate on your use case?
King Java 390 Reputation points

2023-09-05T23:38:47.3533333+00:00

@Pramod Valavala

I was able to come up with expression inside URI, and now I am able to get the data.

My challenge now is, I would like to download the data into csv format.

Currently, I am using "Create file", and it creates a file (in csv file extension) in the destination Azure file Share, but I am not able to download it.

Does bottom one look fine?
King Java 390 Reputation points

2023-09-05T23:57:02.8266667+00:00

No new content here.

Pramod Valavala 17,551 Reputation points Microsoft Employee

2023-09-05T22:16:48.5333333+00:00

@King Java You should be able to use either service to fetch the data from the URL but knowing what you intend to do with the data after retrieval should help suggest the right service to use.

Could you elaborate on your use case?
King Java 390 Reputation points

2023-09-05T23:38:47.3533333+00:00

@Pramod Valavala

I was able to come up with expression inside URI, and now I am able to get the data.

My challenge now is, I would like to download the data into csv format.

Currently, I am using "Create file", and it creates a file (in csv file extension) in the destination Azure file Share, but I am not able to download it.

Does bottom one look fine?
King Java 390 Reputation points

2023-09-05T23:57:02.8266667+00:00

No new content here.

Answer 1

Pramod Valavala 17,551 Microsoft Employee

@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.

King Java 390 Reputation points

2023-09-22T19:59:54.2966667+00:00

@Pramod Valavala Thank you for getting back to me. It was working (meaning somehow, it generated csv file). I was able to get the data, but now, the issue is: somehow, Logic App is creating file everyday automatically even though I did not schedule the Logic App. Isn't this strange? So, I had to disabled it for now (because there is other piece that I have to add later).

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

1 answer

Activity