Calling API from Auze SQL Stored procedure

Amardeepthi Venkata Siripurapu 26 Reputation points
2021-09-14T11:23:47.273+00:00

Can we call an endpoint from Azure SQL stored procedure.

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. Oury Ba-MSFT 17,061 Reputation points Microsoft Employee
    2021-09-14T16:34:18.35+00:00

    Hi @Amardeepthi Venkata Siripurapu Thank you for posting your question on Microsoft Q&A.
    Unfortunately calling API from Azure stored procedure is not supported for PaaS (Azure SQL DB).

    132081-image.png

    If you need to do something similar, SQL Managed Instance has CLR (CLR is not supported in Azure SQL neither)
    https://learn.microsoft.com/en-us/azure/azure-sql/database/features-comparison#features-of-sql-database-and-sql-managed-instance
    https://learn.microsoft.com/en-us/sql/relational-databases/clr-integration/common-language-runtime-integration-overview?view=sql-server-ver15

    Please feel free to reach out if you have additional queries.

    Regards,
    Oury


0 additional answers

Sort by: Most helpful