How to download file from website by using logic app?

Alan Gutierrez Encizo 41 Reputation points
2022-06-28T21:12:07.623+00:00

Hey folks, how you doing?

I'm trying to download a excel file from a web site (Specifically DataCamp) in order to use its data into an automatic process, but before to get the file is necessary to sign in on the page. I was thinking that this would be possible with the JSON Query on the HTTP action, but to be honest I don't know where to start (I'm new on Azure).

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MayankBargali-MSFT 68,476 Reputation points
    2022-07-01T06:53:26.02+00:00

    @Alan Gutierrez Encizo Thanks for reaching out. There is no out of the box solution that can help you with your requirement. You can leverage the logic app HTTP connector, but it will return the response as per the HTTP URI you are calling. As per the screenshot it looks like it is the HTML page so the response will be HTML page string response.

    You can collect the fiddler/F12 traces to get more details how the request is built and what authentication header/how it is passing to the request in case there is no REST API provided by the endpoint. This would be the workaround as it will return the HTML string and you need to traverse to the HTML tag to get the actual download URL.

    Alternatively, you can offload this functionality (your custom code) to azure function and call azure function within logic app or write JavaScript inline code

    0 comments