{"id":4249,"date":"2025-02-12T07:00:08","date_gmt":"2025-02-12T15:00:08","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/azure-sql\/?p=4249"},"modified":"2025-02-11T12:11:02","modified_gmt":"2025-02-11T20:11:02","slug":"external-rest-endpoint-invocation-in-mi-in-public-preview","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/azure-sql\/external-rest-endpoint-invocation-in-mi-in-public-preview\/","title":{"rendered":"External REST Endpoint Invocation in Azure SQL Managed Instance is now in Public Preview"},"content":{"rendered":"<p>External REST Endpoint Invocation is available in Azure SQL Managed Instance with the <a class=\"preserve-view\" href=\"https:\/\/learn.microsoft.com\/en-us\/azure\/azure-sql\/managed-instance\/update-policy?view=azuresql&amp;tabs=azure-portal#always-up-to-date-update-policy&amp;preserve-view=true\" data-linktype=\"absolute-path\">Always-up-to-date update policy<\/a> configured. Call Azure Services such as functions, Azure OpenAI, event hubs, content safety and <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/system-stored-procedures\/sp-invoke-external-rest-endpoint-transact-sql?view=fabric&amp;tabs=request-headers#allowed-endpoints\">more<\/a>!<\/p>\n<p>To enable this feature in Azure SQL Managed Instance, run the following code:<\/p>\n<pre class=\"has-inner-focus\"><code class=\"lang-SQL\">sp_configure 'external rest endpoint enabled', 1;\r\nRECONFIGURE <span class=\"hljs-keyword\">WITH<\/span> OVERRIDE;\r\n<\/code><\/pre>\n<p>To execute sp_configure to change a configuration option or to run the RECONFIGURE statement, a user must be granted the ALTER SETTINGS server-level permission. The ALTER SETTINGS permission is implicitly held by the sysadmin and serveradmin fixed server roles.<\/p>\n<p>Examples and sample code can be found <a href=\"https:\/\/github.com\/Azure-Samples\/azure-sql-db-invoke-external-rest-endpoints\">here<\/a> and a workshop <a href=\"https:\/\/github.com\/Azure-Samples\/sql-ai-embeddings-workshop\">here<\/a>. You can also find all about the latest advancements with SQL and AI <a href=\"https:\/\/aka.ms\/sqlai\">here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>External REST Endpoint Invocation is available in Azure SQL Managed Instance with the Always-up-to-date update policy configured. Call Azure Services such as functions, Azure OpenAI, event hubs, content safety and more! To enable this feature in Azure SQL Managed Instance, run the following code: sp_configure &#8216;external rest endpoint enabled&#8217;, 1; RECONFIGURE WITH OVERRIDE; To execute [&hellip;]<\/p>\n","protected":false},"author":95874,"featured_media":81,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-4249","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure-sql"],"acf":[],"blog_post_summary":"<p>External REST Endpoint Invocation is available in Azure SQL Managed Instance with the Always-up-to-date update policy configured. Call Azure Services such as functions, Azure OpenAI, event hubs, content safety and more! To enable this feature in Azure SQL Managed Instance, run the following code: sp_configure &#8216;external rest endpoint enabled&#8217;, 1; RECONFIGURE WITH OVERRIDE; To execute [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/4249","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/users\/95874"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/comments?post=4249"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/4249\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media\/81"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media?parent=4249"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/categories?post=4249"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/tags?post=4249"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}