详情

首页手游攻略 阿里云物联网平台数据转发到表格存储(Table Store)示例参考

阿里云物联网平台数据转发到表格存储(Table Store)示例参考

佚名 2026-09-01 14:42:56

处理阿里云物联网平台数据转发到表格存储(Table Store)示例参考这类问题时,先确认目标场景,再按步骤核对配置或玩法细节。

概述

前提准备

1、物模型定义

_

_

2、上行消息payLoad

request.topic = "/sys/"   pk   "/"   dn   "/thing/event/property/post";request.payloadObj = "{"id":"230788029","method":"thing.event.property.post","params":{"Status":1,"Data": ["  "{"  ""P": 25,"  ""I": 105,"  ""E": 11"  "},"  "{"  ""P": 121,"  ""E": 119,"  ""I": 11"  "}"  "]},"version":"1.0"}";

3、日志服务监控上行消息情况

_

4、Table Store准备

_

操作步骤

1、在规则的数据流转详情页,创建规则 --> 编辑查询规则语句:

SELECT deviceName() as deviceName, "items.Data.value[0].P" as P, "items.Data.value[0].I" as I,"items.Data.value[0].E" as E FROM "/sys/a1D8NwXCe56/device1/thing/event/property/post"

_

小技巧:如果使用者对具体上行消息经过物模型解析后的格式不是特别清楚,建议可以直接使用服务端订阅订阅上行消息,这样就可以直接参考具体的消息格式类型了,如下是测试订阅获取的消息格式:

"deviceName":"device1","items":{"Status":{"value":1,"time":1561886161283},"Data":{"value":[{"P":25,"E":11,"I":105},{"P":121,"E":119,"I":11}],"time":1561886161283}}}

2、转发数据

_

3、数据流转详情

_

4、开启规则引擎(注意配置完成后务必记住要开启,否则配置不生效)

_

5、表格存储中检查数据

_

点击查看更多
推荐专题
热门阅读