Dot "." operator in JSON field name IoT core

Hello I receive JSON like: { "peer": "37.47.128.172:21477", "position.latitude": 49.692065, "position.longitude": 20.497348 } And i try create rule in IoT core for message routing :

SELECT position.latitude, position.longitude FROM 'myTopic'.

It doesn't work bcs "." Operator this operator accesses members in embedded JSON objects. How can I fix my SQL script?

Kamil
2 个月前
Solution: SELECT position_latitude, position_longitude FROM 'myTopic'.

change . to _

主题

物联网 (IoT)

标签

AWS IoT Core

语言

English

Kamil

已提问 2 个月前100 查看次数

1 回答

最新
投票最多
评论最多

这些答案有用吗？为正确答案投票，以帮助社区从您的知识中受益。

You can use

SELECT get(*,"position.latitude") as latitude ,get(*,"position.longitude") as longitude FROM 'testTopic'

to extract the data. The output will be like

{
  "latitude": 49.692065,
  "longitude": 20.497348
}

ref: https://docs.aws.amazon.com/iot/latest/developerguide/iot-sql-json.html

支持工程师

Bony_T

已回答 1 个月前

专家

Giovanni Lauria

已审核 1 个月前

Dot "." operator in JSON field name IoT core

相关内容