I apologize for delays responding, but this is something I solved for awhile ago in an updated version of the function. I haven't made the time to update this article...

This is great stuff!

One thing I didn't see in the article (sorry if I just missed it!) that might be worth pointing out is I believe (correct me if I'm...

I created a project on github for this function: https://github.com/eilerth/sqlclr-http-request

Note at the time I'm writing this there are breaking changes that will cause examples in this article to...

Yep, I've run into the same issue and have worked a solution into a new version that I hope to post soon.

Basically to fix the issue, this line...

spcghst440, thanks for the info!
I'll check that out and will probably make some tweaks to avoid that.

Thanks for the additional clarity (and kind words), Solomon!

I was thinking similarly about the OLE Automation. That is also a configuration which is turned off by default just like CLR and once enabled allows you to do so...

I was going to suggest you could wrap things up in a table-valued function so you could query something like this:

SELECT * FROM [dbo].[ufn_example_by_area_amenity]('Auckland', 'cinema')

[dbo].[clr_http_request] is the function this article describes. The steps to create the function are noted at the bottom of the article. I'll copy here...

Ha, careful with those chairs!

I was able to pretty quickly take your code and use this function to query it 🙂

Indeed, some policies (especially in larger corporate environments) may to some extent block this method. For those that allow it this can be a very convenient tool, though!

This...

Thanks for the great Feedback, Sergio!

Late last night I noticed that I missed the @convertResponseToBase64 parameter and submitted a fix for the article. I also just now submitted...

zerbit (12/22/2014)

It sound likes this script is doing a large amount of CPU work for just change 8bytes into another...