You can enable xp_cmdshell and have a procedure that executes a powershell script using that command. The contents of the script can include anything, and in your case a web request. This doesn't require importing any assemblies, and I find CLR to be overkill for this usercase.