存储json接口

看这篇，照着来，很详细

从json接口查数据并且存储

两层json解析

参考这篇，看完后提点了我
两层json数据解析

其实第一个不是什么难点，主要两层json解析我不清楚是我json解析公式用得不对还是kettle不支持，他必须要解析两次！！！！最终用如下图的方式解析出来了

接口返回数据如下：

{
    "error": 0,
    "errMsg": "",
    "result": {
        "id": 3,
        "deviceid": "DB 60 20 81 83 2D 0F 26 00 ",
        "version": "353031",
        "standby": "00 00 00 ",
        "cmd": "01 ",
        "tblid": "00 ",
        "time": "20220804174540",
        "powervol": "4.07",
        "latitudex": "0.00",
        "latitudey": "0.00",
        "state": "0.00",
        "temperaturecurrent": "25.01",
        "temperatureaverage": "25.00",
        "humcurrent": "43.00",
        "humaverage": "43.00",
        "rainpointcurrent": "11.56",
        "rainpointaverage": "0.00",
        "rainfallcurrent": "0.00",
        "rainfallaverage": null,
        "windspeedcurrent": "0.00",
        "windspeedaverage": "0.00",
        "winddircurrent": "246.89",
        "winddiraverage": "246.89",
        "sunradicurrent": "9.65",
        "sunradiaverage": "10.13",
        "soilmoicurrent": "0.00",
        "soilmoiaverage": "0.00",
        "soiltempcurrent": "0.00",
        "soiltempaverage": "0.00"
    }
}

可以看到，第一层读取到后，没法读取到result里的数据，只能分两次解析

如果有更好的解决方案欢迎留言学习！

Fuck kettle！