Forum Discussion
Power Query check validity URL via Web.Contents fails
Hi, I have a column [URL] with a list of urls. I want to add an extra column that checks whether the URL is valid or not. I know that certain urls return a 400 error, but I can't seem to get an erro...
That's just half of the code. You now need to actually implement the manualstatushandling.
BUT! You can only do that in custom connectors.
Note
Extensions are able to use the ManualStatusHandling option with status codes 401 and 403, which is not something that can be done in Web.Contents calls made outside of a custom data connector (that is, directly from Power Query).
Handling status codes with Web.Contents for Power Query connectors - Power Query | Microsoft Learn