调用阿里云数据库监控数据返回的json数据
基本思路
获取返回json数据
循环PerformanceKeys/PerformanceKey键内array
将key作为表名
将其它键作为属性名,并额外添加Date属性
循环Values/PerformanceValue,将Value和Date值存入数组
拼接字符串转化成插入sql语句
json格式
原代码
#案例数据
apidate={"DBInstanceId":"rm-test","RequestId":"test","PerformanceKeys":{"PerformanceKey":[{"Values":{"PerformanceValue":[{"Value":"2624&415&5&0&2204","Date":"2018-02-23T08:00:32Z"},{"Value":"2624&415&5&0&2204","Date":"2018-02-23T08:05:32Z"},{"Value":"2624&415&5&0&2204","Date":"2018-02-23T08:10:32Z"},{"Value":"2624&415&5&0&2204","Date":"2018-02-23T08:15:32Z"},{"V