麻烦问一下如何解析嵌套数组

EMQX
,
1

输入json

{
    "equipmentType": "01",
    "isRead": "0",
    "mqType": "05",
    "slaves": [
        {
            "addr": "2",
            "serialNumber": "1",
            "variates": [
                {
                    "name": "nodeType",
                    "value": "85",
                    "valueType": "01"
                },
                {
                    "name": "temperature",
                    "value": "23.200001",
                    "valueType": "01"
                },
                {
                    "name": "voltage",
                    "value": "3.202000",
                    "valueType": "01"
                },
                {
                    "name": "current",
                    "value": "0.000000",
                    "valueType": "01"
                },
                {
                    "name": "electrification",
                    "value": "1",
                    "valueType": "00"
                },
                {
                    "name": "switch01",
                    "value": "0",
                    "valueType": "00"
                },
                {
                    "name": "rssi",
                    "value": "-41",
                    "valueType": "01"
                }
            ]
        }
    ]
}

SQL

FOREACH
    payload.slaves as s
DO
    id,
    topic,
    s.addr as address,
    s.variater[1].value as temperature,
    s.variater[2].value as voltage,
    s.variater[3].value as cur
FROM
  "t/#"

问题

temperature，voltage，cur均为undefined，如何正确解析

2

兄弟，你的单词拼错了：
variater => variates