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
Hi @gblanks
By default retries are only 3, so I would check the action to see what its set too as 25 is certainly not a standard.
truth is we would have to see your HTTP Connector action and all you have typed in.
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey