从JSON中获取密钥名称和值名称，并在Highcharts中使用

Question

我有一个JSON文件，其结构如下：

JSON结构：

[
{
"id": 1536700,
"title": "final_output",
"error": "",
"data": [
{
"metric": 4940616.0,
"title": "d_revenue"
},
{
"metric": 5132162.0,
"title": "p_revenue"
},
{
"metric": 4954576.0,
"title": "s_revenue"
},
{
"metric": 4882217.0,
"title": "u_revenue"
},
{
"metric": 4869609.0,
"title": "t_revenue"
},
{
"metric": 5075422.0,
"title": "w_revenue"
},
{
"metric": 4461996.0,
"title": "v_revenue"
}
]
}
]

下一个结构：

[
{
"run_id": 1536700,
"code_title": "select_data",
"error": "",
"data": [
{
"user_name": "C_51",
"num1": 51,
"num2": 101,
"num3": 151
},
{
"user_name": "H_51",
"num1": 51,
"num2": 101,
"num3": 151
},
{
"user_name": "C_52",
"num1": 52,
"num2": 102,
"num3": 152
},
{
"user_name": "H_52",
"num1": 52,
"num2": 102,
"num3": 152
},
{
"user_name": "C_53",
"num1": 53,
"num2": 103,
"num3": 153
}
]
}
]

我想把钥匙放在data里面，然后决定x轴和y轴是什么，我想做一些类似的事情http://jsfiddle.net/k32a59vL/1/.

这是我的代码：

$.getJSON(api, function(elem) {
console.log(elem);
elem.forEach(d => {
});
});

console.log(elem)给了我上面提到的json结构。如何从第一个结构中得到metric and title和user_name, num1, num2, num3。我如何获得这些值？

Answer 1

使用Object.keys(yourObject(获取密钥

$.getJSON(api, function(elem) {
let keys=elem.map( structure =>  Object.keys(structure.data[0]))         
});

运行以下代码段以检查它是否工作

let ele= [{"id": 1536700,"title": "final_output","error": "",
"data": [{"metric": 4940616.0,"title": "d_revenue"},{"metric": 5132162.0,"title": "p_revenue"},{"metric":4954576.0,"title": "s_revenue"},{"metric": 4882217.0,"title":"u_revenue"},{"metric": 4869609.0,"title":"t_revenue"},{"metric": 5075422.0,"title": "w_revenue"},{"metric": 4461996.0,"title": "v_revenue"}
]
},
{"run_id": 1536700,"code_title": "select_data","error": "",
"data": [{"user_name": "C_51","num1": 51,"num2": 101,"num3": 151},{"user_name": "H_51","num1": 51,"num2": 101, "num3": 151},{"user_name": "C_52","num1": 52,"num2": 102,"num3": 152},{"user_name": "H_52","num1": 52,"num2": 102,"num3":152},{"user_name": "C_53","num1": 53,"num2": 103,"num3": 153}
]}]
console.log(ele.map( structure =>  Object.keys(structure.data[0])))

.as-console-wrapper { max-height: 100% !important; top: 0; }