Http Request from Azure SQL Stored Procedure (no CLR)
<p>I'm moving an on-premise SQL Server database to Azure SQL Database.
From inside a stored procedure, we need to make HTTP request.
I had built a CLR assembly to make HTTP request, and all was working well.</p>

<p>From what I understand, CLR Assemblies are not supported by Azure SQL Database.
So I have to find an alternative, </p>

<p>Note that the use of stored procedure is for a legacy app to communicate with our app.
The legacy app cannot make an HTTP request (or the devs don't know how).
So basically it goes like: </p>

<p>Legacy App --> Our Stored Proc --> Our Web App.</p>

<p>I'm looking for the simplest solution for an Azure SQL Database stored procedure to make a call to a Web App.</p>

<p>I would prefer no polling solution, ie: Legacy App insert row, then our Web App pools the database.</p>