通过将新行插入(添加)到表SQL Server数据库中来触发Azure函数 [英] Trigger Azure Function by inserting (adding) new row into table, SQL Server Database

问题描述

是否可以通过将新行插入表(使用SQL Server数据库)来触发Azure功能. 或者，是否可以创建Logic App来通知我们，如果新记录已添加到SQL Server数据库表中(例如，一旦添加新记录以发送新的信息电子邮件)

Is it possible to trigger Azure Function by inserting new row into table (using SQL Server Database). Or, is it possible create Logic App to inform us, in case of new record has been added into table, SQL Server database (e.g once the new record is added to send new info email)

推荐答案

您可以使用

You can use Azure Event Grid as stated on this article "Extend existing workflows by triggering a Logic App once there is a new record in your database".

您还可以创建一个Logic App来轮询表，并添加一个操作项以调用Azure函数或RESTful调用.

You can also create a Logic App to poll the table and add an action item to call the Azure function or a RESTful call.

希望这会有所帮助.

这篇关于通过将新行插入(添加)到表SQL Server数据库中来触发Azure函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！