存储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!