Can we call an endpoint from Azure SQL stored procedure.
Can we call an endpoint from Azure SQL stored procedure.
Hi @AmardeepthiVenkataSiripurapu-9940 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://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison#features-of-sql-database-and-sql-managed-instance
https://docs.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
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
Hi @AmardeepthiVenkataSiripurapu-9940
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://docs.microsoft.com/en-us/answers/questions/529464/upsert-in-azure-logic-app-to-load-data-into-azure.html
Regards,
Oury
Thanks @OuryBa-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
9 people are following this question.