电子邮件警报Azure表存储 [英] Email alert Azure table storage

问题描述

我正在将传感器数据发送到天蓝色表存储.如果列中的值小于特定值，我想发送电子邮件.

请找到所附的图像

          -If a value in GPIOPin column is less than 7 then an email alert has to be sent.

有人可以指导如何进行吗?我已经尝试过使用Logic应用程序，但是我不了解如何在其中提供条件.

解决方案

AFAIK，Logic Apps目前不支持Azure表存储触发器.您可以在此处添加反馈.根据您的方案，您需要选择 Schedule-recurrence 连接器，以从表存储中检索记录并定期处理逻辑.由于没有用于创建/更新操作的触发器，因此您需要添加新列(例如status)，以指示逻辑应用程序流是否已对其进行检查.这是我针对这种情况的设计师，您可以参考以下内容:

注意:

• 对于(Azure Table Storage)获取实体操作，您可以在高级选项下将过滤器查询特定于status eq false，以检索以前未检查的记录.

• 对于条件块，如果单个条件块中有多个规则，则需要在代码视图中使用@and()或@or().这是一个反馈，您可以参考此处.

• 如果条件块为true，则可以发送电子邮件，成功发送电子邮件之后，需要使用Azure表存储的合并实体"操作来更新当前记录的状态列，如下所示:

• 如果条件块为false，则还需要更新表存储的当前记录的状态列.

此外，在SQL Server中创建项目时，逻辑应用程序还支持触发器.如果可能的话，您可以以一种更简单的方式更改数据存储.此外，Azure Functions中没有针对表存储的触发器绑定.您可以利用计时器触发器，存储表绑定， SendGrid绑定. >

I am sending sensor data to azure table storage. I want to send an email if a value in a column is less than a particular value.

please find the attached images

          -If a value in GPIOPin column is less than 7 then an email alert has to be sent.

Could someone please guide how to proceed? I have tried with Logic apps but I am not understanding how to provide a condition there.

解决方案

AFAIK, Logic Apps do not support Triggers for Azure Table Storage for now. You could add your feedback here. Based on your scenario, you need to choose the Schedule - recurrence Connector for retrieving records from your table storage and process your logic Periodically. Since there is no trigger for create/update operation, you need to add a new column (e.g. status) which indicates that whether it has been checked by your logic app flow. Here is my designer for this scenario, you could refer to it as follows:

Note:

• For the (Azure Table Storage) Get entities action, you could specific the filter query to status eq false under the advanced options for retrieving the records which have not been checked before.

• For the condition block, if there has multiple rules within a single condition block, you need to use @and() or @or() in code-view. Here is a feedback, you could refer to here.

• If true for the condition block, you could send the email, after successfully send the email you need to use the Merge Entity action of Azure Table storage to update the status column of the current record as follows:

• If false for the condition block, you also need to update the status column for the current record of table storage.

Additionally, logic apps support the trigger when a item is created in SQL Server. If possible, you could change your data store for a simpler way. Moreover, there is no triggers binding for Table Storage in Azure Functions. You could leverage timer trigger, Storage table bindings, SendGrid bindings in Azure Functions for achieving your purpose.

这篇关于电子邮件警报Azure表存储的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！