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 770

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=******@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 20,656 Reputation points Microsoft Employee Moderator

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 770 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 770 Reputation points

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

No new content here.
Pramod Valavala 20,656 Reputation points Microsoft Employee Moderator

2023-10-11T00:06:01.93+00:00

@King Java Following up here to see if the response here helps
support1 0 Reputation points

2023-10-26T23:05:25.9466667+00:00

I have the same issue,
however i am getting the emails with direct download links which containts the reports.
I am trying to automate the links data to be downloaded in azure blob.
used few operators, no luck.
can some one help me with the solution on how to use logic apps with outlook connector.
i tried different ways but unable to get the results
Pramod Valavala 20,656 Reputation points Microsoft Employee Moderator

2023-10-27T10:51:01.3333333+00:00

@support1 It would be best to create a new post with your scenario to better engage the community here 🙂

Accepted answer

1 additional answer

Your answer

Pramod Valavala 20,656 Reputation points Microsoft Employee Moderator

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 770 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 770 Reputation points

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

No new content here.
Pramod Valavala 20,656 Reputation points Microsoft Employee Moderator

2023-10-11T00:06:01.93+00:00

@King Java Following up here to see if the response here helps
support1 0 Reputation points

2023-10-26T23:05:25.9466667+00:00

I have the same issue,
however i am getting the emails with direct download links which containts the reports.
I am trying to automate the links data to be downloaded in azure blob.
used few operators, no luck.
can some one help me with the solution on how to use logic apps with outlook connector.
i tried different ways but unable to get the results
Pramod Valavala 20,656 Reputation points Microsoft Employee Moderator

2023-10-27T10:51:01.3333333+00:00

@support1 It would be best to create a new post with your scenario to better engage the community here 🙂

Answer 1

Pramod Valavala 20,656 Microsoft Employee Moderator

@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 770 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).
Pramod Valavala 20,656 Reputation points Microsoft Employee Moderator

2023-10-04T21:44:33.2333333+00:00

@King Java Looks like you are using the HTTP Trigger, which is a polling trigger and should have configuration for it as such at the end of all the parameters as shown in the docs.

If you need to run it on a schedule, change the parameters on the HTTP Trigger itself, or if you require a more on-demand solution, you will have to use the Request Trigger instead.
King Java 770 Reputation points

2023-10-12T04:30:51.8333333+00:00

@Pramod Valavala Sorry. I was/am swamped. I will get back to you later when I am little free. Thanks!
King Java 770 Reputation points

2023-10-27T21:49:39.49+00:00

@Pramod Valavala Thank you. I realized that there is an Recurrence area to configure. Thank you.

Answer 2

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Share via

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

1 additional answer

Your answer