Can we call an endpoint from Azure SQL stored procedure.

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). 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

Calling API from Auze SQL Stored procedure

Accepted answer

Oury Ba-MSFT 16,636 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).

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
Please sign in to rate this answer.
Amardeepthi Venkata Siripurapu 26 Reputation points

2021-09-15T04:40:45.853+00:00

Thank you Oury! Can we use Logic Apps to call the endpoints as part of accomplishing business logic. We need to perform insert/update data on SQL tables based on endpoint data

Thanks
Deepthi

Oury Ba-MSFT 16,636 Reputation points Microsoft Employee

2021-09-15T15:49:36.587+00:00

Hi @Amardeepthi Venkata Siripurapu
What kind of endpoint are you referring to. But mostly this ca be achieved from Azure logic App as well as Azure functions. Please check out this thread which is similar to your questions and let us know if that was helpful.
https://learn.microsoft.com/en-us/answers/questions/529464/upsert-in-azure-logic-app-to-load-data-into-azure.html

Regards,
Oury

Amardeepthi Venkata Siripurapu 26 Reputation points

2021-09-15T15:56:05.677+00:00

Thanks @Oury Ba-MSFT ! This is helpful!
There are a few endpoints to fetch the data for getting current exchange rate, city codes etc based on which we may need to perform some calculations & load the data to Azure SQL tables. Also once the processing is done another http request need to be sent with the newly generated ids.

I believe the logic Apps would help in this scenario.

Thanks again!
Deepthi

Oury Ba-MSFT 16,636 Reputation points Microsoft Employee

2021-09-15T16:00:13.933+00:00

@Amardeepthi Venkata Siripurapu Yes Logic app will be helpful in this case.
Please let me know if you have additional query.

Regards,
Oury
Sign in to comment

Calling API from Auze SQL Stored procedure

0 additional answers