Dot "." operator in JSON field name IoT core

Question

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?

Answer

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

Dot "." operator in JSON field name IoT core

相關內容