So im attempting to use a power automate flow to access the NIB Database(A database for all bridges and their reports), turn it into a CSV, and then return the CSV to a power app to then use as a list, but the HTTP request keeps failing. I'm getting "Http request failed as there is an error: 'A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. (www.fhwa.dot.gov:443)'." and it reruns it like 25 times and never gets a proper response. I know its not a problem with the website in general because i can easily do an HTTP request in python using requests.get and only pass in the URL and it works just fine. I think this may be a problem with it not being an api and instead its just a CSV hosted on a website, but I'm unsure why this would be a problem for the http connector but not requests.get. I have included the link. Any advice?
https://www.fhwa.dot.gov/bridge/nbi/2023/delimited/AL23.txt
