Unable to find [sys].[sp_invoke_external_rest_endpoint] in Azure Managed Instance Database

Question

I'm trying to execute [sys].[sp_invoke_external_rest_endpoint] in 1 of my databases. I can see it listed in the "System Stored Procedures", but I'm getting the error that it cannot be found. This is being ran on Azure Managed Instance. I've tried this on Azure SQL Server and it was working. I would have thought it would work in the Managed Instance version as well.

Answer 1

The documentation page for `sys.sp_invoke_external_rest_endpoint shows that it is available only in Azure SQL Database. Furthermore, the feature is in preview.

New features are usually released to Azure SQL Database first, followed by other SQL Server platforms as appropriate. Although this system stored proc may be visible on other platforms, it has not yet been implemented (at least currently).