Is there a way to excute Azure function from database trigger

Nuwan Wickramanayaka 21 Reputation points
2022-09-06T15:10:50.017+00:00

Hi all

There is a custom table in SQL database to store email detail that user want to send. Legacy application insert data to that table will all recipient details. What I need to do is I need to collect those data and need to send to email queue (Another application - not connected to same database). That email queue application will process the email data send and record the failure and successes.

Is there a way to send those email details to Azure function on insert using table level trigger ?

Thanks

Azure SQL Database
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,249 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nandan Hegde 29,886 Reputation points MVP
    2022-09-06T15:40:31.237+00:00

    Hey
    You can use logic app to monitor for the data updates in tables in database
    https://microsoft.github.io/AzureTipsAndTricks/blog/blog/tip156.html

    You can send email via logic app as well else you can trigger Azure function via logic app :
    https://learn.microsoft.com/en-us/azure/logic-apps/logic-apps-azure-functions

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful