Forum Discussion
Web.Contents GET API call -- retry if 502 bad gateway
Hi! I have a table of GET API URLs in a query which I call with a Web.Contents in a separate function query. My table query refreshes often crash due to one of the function calls returning a...
Yes. There are a couple nice blog articles about that - for example Handling Unsuccessful HTTP Requests in Power Query M (tonymcgovern.com)
lbendlin
Super User
Super UserI am actually abusing try...otherwise... as a cheap way to have a second attempt at an API call if the first one fails (some APIs need "warm up calls"). Not generally recommended, but neat when it works.