API call from Azure SQL database

Question

API call from Azure SQL database

Renan 60

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.

Vijayalaxmi Kattimani 1,720 Reputation points Microsoft External Staff

2025-03-11T10:02:56.3433333+00:00

Hi @Renan,

Just checking in to see if the below answer helped.

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.

Accepted answer

0 additional answers

Your answer

Vijayalaxmi Kattimani 1,720 Reputation points Microsoft External Staff

2025-03-11T10:02:56.3433333+00:00

Hi @Renan,

Just checking in to see if the below answer helped.

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.

Answer 1

Vijayalaxmi Kattimani 1,720 Microsoft External Staff

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.

Adithya Prasad K 90 Reputation points Microsoft External Staff

2025-03-10T03:35:18.44+00:00

Hi Renan,,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Renan 60 Reputation points

2025-03-12T14:12:54.6866667+00:00

Thank you for the explanation and the links provided to complete the task.

Share via

API call from Azure SQL database

0 additional answers

Your answer