如何使用下划线js转换json

Question

我正在调用Athena Rest API，作为回应，我收到了下面提到的JSON。可以有更多的"；数据"；除了第一个"；数据"；元素将始终包含键；数据"；元素将包含下面payLoad 中提到的值

{
"ResultSet": {
"Rows": [
{
"Data": [
{
"VarCharValue": "date"
},
{
"VarCharValue": "location"
},
{
"VarCharValue": "browser"
},
{
"VarCharValue": "uri"
},
{
"VarCharValue": "status"
}
]
},
{
"Data": [
{
"VarCharValue": "2014-07-05"
},
{
"VarCharValue": "SFO4"
},
{
"VarCharValue": "Safari"
},
{
"VarCharValue": "/test-image-2.jpeg"
},
{
"VarCharValue": "200"
}
]
},
{
"Data": [
{
"VarCharValue": "2014-07-05"
},
{
"VarCharValue": "SFO4"
},
{
"VarCharValue": "opera"
},
{
"VarCharValue": "/test-image-2.jpeg"
},
{
"VarCharValue": "300"
}
]
}
]
},
"UpdateCount": 0
}

我需要做的是将这个对象转换成下面提到的JSON。搞不清楚。如有任何帮助，我们将不胜感激。感谢

[ 
{     
"date": "2014-07-05"     
"location": "SFO4"
"browser": "Safari"
"uri": "/test-image-2.jpeg"
"status": "200"                
},
{     
"date": "2014-07-05"     
"location": "SFO4"
"browser": "opera"
"uri": "/test-image-2.jpeg"
"status": "300"                
}
]

Answer 1

我能够用这个实现所需的结果

var rows = response.ResultSet.Rows;
// Get columns name (first row).
var columnsName = _.pluck(rows[0].Data, 'VarCharValue');
return _.map(_.rest(rows, 1), function(row) {
return _.object(columnsName, _.pluck(row.Data, 'VarCharValue'));
});