skip to Main Content

Azure SQL Database External REST Endpoints Integration Now in Public Preview

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
IoT Central
  • 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

Post Terms: Azure SQL | REST Endpoints

About the Author

Our communications team bring you Ballard Chalmers announcements, client news, technical updates such as feature releases or end of support, and social responsibility activities.

Previous Post
Next Post
Back To Top
Contact us for a chat