Multiple additions to datastore from single JSON
My IoT device sends out a JSON via MQTT to IoT Core, which is passed to a single IoT Analytics channel and then to a pipeline.
An example JSON received is as follows:
```
{
"mesh_name": "mesh_network_1",
"datetime": "2019-07-17 09:00",
"eui64": "BB797FFFFE897420",
"sensors": [
{
"name": "office_1",
"value": 24.6,
"category": "temperature",
},
{
"name": "office_2",
"value": 55,
"category": "humidity",
},
{
"name": "outdoor_1",
"value": 22.3,
"category": "temperature",
}
... (every sensor occupies a separate object within this list)
]
}
```
For each of the sensors I want to have a separate entry to the datastore. For example this input JSON would give:
mesh|datetime|name|value|category
"mesh_network_1"|"2019-07-17 09:00"|"office_1"|24.6|"temperature"
"mesh_network_1"|"2019-07-17 09:00"|"office_2"|55|"humidity"
"mesh_network_1"|"2019-07-17 09:00"|"outdoor_1"|22.3|"temperature"
However, I'm not sure how to do this within an IoT Analytics pipeline, as this seems to assume a single datastore addition per JSON.
Anyone know if there's a good way to do this, or will I have to just send three MQTT messages to convey this example instead? I'd really prefer not to do that.