如何从Array获取所有Exit值(How to get all Exit values from Array)
console.log(data);
输出:
{ "Status": "OK", "Message": "", "Data": { "LocationId": 1, "LocationName": null, "LocationData": [ ], "DeviceData": [ ], "AverageData": [ { "Timestamp": "2017-01-01T00:00:00", "Data": [ { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T00:00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "12 AM", "TimeTitleLong": "01 Jan 2017 12 AM", "Epoh": 1483228800000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T01 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "01 AM", "TimeTitleLong": "01 Jan 2017 01 AM", "Epoh": 1483232400000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T02 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "02 AM", "TimeTitleLong": "01 Jan 2017 02 AM", "Epoh": 1483236000000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T03 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "03 AM", "TimeTitleLong": "01 Jan 2017 03 AM", "Epoh": 1483239600000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T04 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "04 AM", "TimeTitleLong": "01 Jan 2017 04 AM", "Epoh": 1483243200000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T05 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "05 AM", "TimeTitleLong": "01 Jan 2017 05 AM", "Epoh": 1483246800000, "RecordCount": 0 } ], "Title": "13 Apr" } ], "WeekdaySummary": null, "WeekdayEmpty": null, "Locationcapacity": 500, "Total": 0.0, "Max": 0.0, "Min": 0.0, "Average": 0.0, "NonZeroAverageDataCount": 0, "PeakHours": { }, "PeakHour1": "-", "PeakHour2": "-" } }现在如何使用JQuery或JavaScript从此JSON对象获取所有Exit值?
console.log(data);
output:
{ "Status": "OK", "Message": "", "Data": { "LocationId": 1, "LocationName": null, "LocationData": [ ], "DeviceData": [ ], "AverageData": [ { "Timestamp": "2017-01-01T00:00:00", "Data": [ { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T00:00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "12 AM", "TimeTitleLong": "01 Jan 2017 12 AM", "Epoh": 1483228800000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T01 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "01 AM", "TimeTitleLong": "01 Jan 2017 01 AM", "Epoh": 1483232400000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T02 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "02 AM", "TimeTitleLong": "01 Jan 2017 02 AM", "Epoh": 1483236000000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T03 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "03 AM", "TimeTitleLong": "01 Jan 2017 03 AM", "Epoh": 1483239600000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T04 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "04 AM", "TimeTitleLong": "01 Jan 2017 04 AM", "Epoh": 1483243200000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T05 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "05 AM", "TimeTitleLong": "01 Jan 2017 05 AM", "Epoh": 1483246800000, "RecordCount": 0 } ], "Title": "13 Apr" } ], "WeekdaySummary": null, "WeekdayEmpty": null, "Locationcapacity": 500, "Total": 0.0, "Max": 0.0, "Min": 0.0, "Average": 0.0, "NonZeroAverageDataCount": 0, "PeakHours": { }, "PeakHour1": "-", "PeakHour2": "-" } }now how to get all Exit values from this JSON object using JQuery or JavaScript ?
最满意答案
您只需映射数组值并返回退出状态
var data = { "Status": "OK", "Message": "", "Data": { "LocationId": 1, "LocationName": null, "LocationData": [ ], "DeviceData": [ ], "AverageData": [ { "Timestamp": "2017-01-01T00:00:00", "Data": [ { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T00:00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "12 AM", "TimeTitleLong": "01 Jan 2017 12 AM", "Epoh": 1483228800000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T01 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "01 AM", "TimeTitleLong": "01 Jan 2017 01 AM", "Epoh": 1483232400000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T02 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "02 AM", "TimeTitleLong": "01 Jan 2017 02 AM", "Epoh": 1483236000000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T03 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "03 AM", "TimeTitleLong": "01 Jan 2017 03 AM", "Epoh": 1483239600000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T04 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "04 AM", "TimeTitleLong": "01 Jan 2017 04 AM", "Epoh": 1483243200000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T05 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "05 AM", "TimeTitleLong": "01 Jan 2017 05 AM", "Epoh": 1483246800000, "RecordCount": 0 } ], "Title": "13 Apr" }, { "Timestamp": "2017-01-01T00:00:00", "Data": [ { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T00:00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "12 AM", "TimeTitleLong": "01 Jan 2017 12 AM", "Epoh": 1483228800000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T01 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "01 AM", "TimeTitleLong": "01 Jan 2017 01 AM", "Epoh": 1483232400000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T02 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "02 AM", "TimeTitleLong": "01 Jan 2017 02 AM", "Epoh": 1483236000000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T03 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "03 AM", "TimeTitleLong": "01 Jan 2017 03 AM", "Epoh": 1483239600000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T04 :00:00", "Entry": 0, "Exit": 1, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "04 AM", "TimeTitleLong": "01 Jan 2017 04 AM", "Epoh": 1483243200000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T05 :00:00", "Entry": 0, "Exit": 1, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "05 AM", "TimeTitleLong": "01 Jan 2017 05 AM", "Epoh": 1483246800000, "RecordCount": 0 } ], "Title": "14 Apr" } ], "WeekdaySummary": null, "WeekdayEmpty": null, "Locationcapacity": 500, "Total": 0.0, "Max": 0.0, "Min": 0.0, "Average": 0.0, "NonZeroAverageDataCount": 0, "PeakHours": { }, "PeakHour1": "-", "PeakHour2": "-" } } var arr = []; arr = data.Data.AverageData.map(function(data) { return data.Data.map(function(item) { return item.Exit; }) }) console.log(arr);You just need to map over the array values and return the Exit status
var data = { "Status": "OK", "Message": "", "Data": { "LocationId": 1, "LocationName": null, "LocationData": [ ], "DeviceData": [ ], "AverageData": [ { "Timestamp": "2017-01-01T00:00:00", "Data": [ { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T00:00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "12 AM", "TimeTitleLong": "01 Jan 2017 12 AM", "Epoh": 1483228800000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T01 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "01 AM", "TimeTitleLong": "01 Jan 2017 01 AM", "Epoh": 1483232400000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T02 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "02 AM", "TimeTitleLong": "01 Jan 2017 02 AM", "Epoh": 1483236000000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T03 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "03 AM", "TimeTitleLong": "01 Jan 2017 03 AM", "Epoh": 1483239600000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T04 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "04 AM", "TimeTitleLong": "01 Jan 2017 04 AM", "Epoh": 1483243200000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T05 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "05 AM", "TimeTitleLong": "01 Jan 2017 05 AM", "Epoh": 1483246800000, "RecordCount": 0 } ], "Title": "13 Apr" }, { "Timestamp": "2017-01-01T00:00:00", "Data": [ { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T00:00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "12 AM", "TimeTitleLong": "01 Jan 2017 12 AM", "Epoh": 1483228800000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T01 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "01 AM", "TimeTitleLong": "01 Jan 2017 01 AM", "Epoh": 1483232400000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T02 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "02 AM", "TimeTitleLong": "01 Jan 2017 02 AM", "Epoh": 1483236000000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T03 :00:00", "Entry": 0, "Exit": 0, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "03 AM", "TimeTitleLong": "01 Jan 2017 03 AM", "Epoh": 1483239600000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T04 :00:00", "Entry": 0, "Exit": 1, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "04 AM", "TimeTitleLong": "01 Jan 2017 04 AM", "Epoh": 1483243200000, "RecordCount": 0 }, { "Snapshot": false, "Id": null, "Timestamp": "2017-01-01T05 :00:00", "Entry": 0, "Exit": 1, "Value": 0.0, "TimeType": "HOUR", "TimeTitle": "05 AM", "TimeTitleLong": "01 Jan 2017 05 AM", "Epoh": 1483246800000, "RecordCount": 0 } ], "Title": "14 Apr" } ], "WeekdaySummary": null, "WeekdayEmpty": null, "Locationcapacity": 500, "Total": 0.0, "Max": 0.0, "Min": 0.0, "Average": 0.0, "NonZeroAverageDataCount": 0, "PeakHours": { }, "PeakHour1": "-", "PeakHour2": "-" } } var arr = []; arr = data.Data.AverageData.map(function(data) { return data.Data.map(function(item) { return item.Exit; }) }) console.log(arr);
更多推荐
发布评论