API call from Azure SQL database

Question

I am working with an Azure SQL Database and currently using SQL Server Management Studio (SSMS) for text-based queries. I would like to know if it is possible to make an API call directly from the database. I am aware that Azure SQL Database may have certain limitations compared to traditional SSMS, and I would like to confirm this.

Answer 1

Hi Renan,

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

Yes, it is possible to make an API call directly from an Azure SQL Database. You can use the sp_invoke_external_rest_endpoint system stored procedure to invoke an HTTPS REST endpoint from Azure SQL Database. Also, facilitating integration with various services such as Azure Functions, Event Hubs, Power BI, Cognitive Services, and more.

Please refer the below mentioned links for more information.

https://learn.microsoft.com/en-gb/sql/relational-databases/system-stored-procedures/sp-invoke-external-rest-endpoint-transact-sql?view=fabric&ocid=AID754288&wt.mc_id=azfr-c9-scottha%2CCFID0739&tabs=request-headers

https://devblogs.microsoft.com/azure-sql/azure-sql-database-external-rest-endpoints-integration-public-preview/

https://learn.microsoft.com/en-us/shows/azure-friday/calling-external-rest-endpoints-from-azure-sql-database

I hope, This response will address your query and helped you to overcome on your challenges.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.