The ability to call a REST endpoint natively from Azure SQL Database is now in Public Preview. The new functionality is within a system-stored procedure, sp_invoke_external_rest_endpoint, and is available in all current and future Azure SQL Databases.
You can call any of the following Azure Services using this feature:
|Azure Functions||API Management|
|Azure App Service Environment||Azure Apps Service|
|Azure Logic Apps||Azure Static Web Apps|
|Azure Event Grid||Azure Container Instances|
|Power Apps/Dataverse||Azure Event Hubs|
|Power BI||Azure Cognitive Search|
|Analysis Services||Microsoft Graph|
- Integration with Azure Event Hubs and Azure Event Grid drives the ability to push data out of Azure SQL and make it available to event-driven solutions.
- Power BI integration allows the execution of powerful DAX queries utilising the executeQueries REST endpoint, pulling the result straight into Azure SQL DB.
- Supply a notification straight to a website from Azure SQL DB via SignalR using Azure Function integration.
To learn everything about the new procedure, including the newly added security permission required to use it, support for Managed Service Identities, and more, take a look at the official documentation: sp_invoke_external_rest_endpoint (Transact-SQL) – SQL Server | Microsoft Learn