我一直在尝试使用 JS 从下面的 json 中获取对象。它是一个直接变量但仍然没有成功。我已经厌倦了使用 For 循环没有运气我尝试使用 JSON.parse 这给了我错误。console.log('-0-' + JSON.stringify(getTotalProducts));
甚至对 JSON 数组进行硬编码也不起作用
所以当你这个 JSON 对象时,我有这样的记录列表a4wg0000000sdsGAA0
,a4wg000000asdaMGAA0
等等。我想获得名为 totalCogs 的直接变量。我怎么得到它?
{
"a4wg0000000uioGAA0": {
"familyMap": {
"MS Hardware": {
"familyName": "MS Hardware",
"familySObj": {
"Name": "MS Hardware",
"Sort_Order__c": 2,
"Task_Code__c": "4",
"Targeted_GM__c": 0.3,
"Family_Trigger_Date__c": "Manuf_Equipment_Elect_Buyouts_Trigger__c",
"Id": "a4ug000000052IjAAI"
},
"productsInFamily": [],
"sortOrder": 2,
"groupsInFamily": [],
"groupsInFamilyByGroupName": {},
"isBooking": false,
"isFee": false,
"totalUnits": 0,
"totalCogs": 0,
"totalStdCost": 0,
"totalRevenue": 0,
"totalTargetedSellPrice": 0,
"targetedSell": 0,
"targetedMargin": 0,
"spreadGrossMarginSell": 0,
"percentTotal": 0,
"totalCalcdMargin": 0
}
},
"rateMap": {
"GBP": 1,
"AUD": "1.87999999",
"BRL": "5.39999999",
"CAD": "1.75999999",
"CLP": "986.66765087",
"CNY": "9.93333315",
"DKK": "8.73040009",
"EUR": "1.12000000",
"JPY": "149.79994180",
"MXN": "26.26666728",
"MYR": "5.43999997",
"SEK": "0.14666667",
"SGD": "1.80000000",
"THB": "42.26666834"
},
"marginTotalStdCost": 94751,
"marginTotalCogs": 94751,
"marginTotalTargetedSellPrice": 103347,
"marginTotalTargetedCalcdMargin": 0.08317609606471399,
"bookingTotalStdCost": 101740,
"bookingTotalCogs": 101740,
"bookingTotalTargetedSellPrice": 110336,
"bookingTotalTargetedCalcdMargin": 0.07790748259860791,
"totalStdCost": 101740,
"totalCogs": 101740,
"totalTargetedSellPrice": 110336,
"totalTargetedCalcdMargin": 0.07790748259860791,
"marginTotalRevenue": 135361,
"marginTotalCalcdMargin": 0.3000125590088726,
"bookingTotalRevenue": 142350,
"bookingTotalCalcdMargin": 0.2852827537759045,
"totalRevenue": 142350,
"totalCalcdMargin": 0.2852827537759045,
"systemISO": "USD"
}
}
我相信即使您不知道密钥名称,您也需要访问 totalCogs 的值
我想这会帮助你
var jsonData=`{
"a4wg0000000uioGAA0":{
"familyMap":{
"MS Hardware":{
"familyName":"MS Hardware",
"familySObj":{
"Name":"MS Hardware",
"Sort_Order__c":2,
"Task_Code__c":"4",
"Targeted_GM__c":0.3,
"Family_Trigger_Date__c":"Manuf_Equipment_Elect_Buyouts_Trigger__c",
"Id":"a4ug000000052IjAAI"
},
"productsInFamily":[
],
"sortOrder":2,
"groupsInFamily":[
],
"groupsInFamilyByGroupName":{
},
"isBooking":false,
"isFee":false,
"totalUnits":0,
"totalCogs":0,
"totalStdCost":0,
"totalRevenue":0,
"totalTargetedSellPrice":0,
"targetedSell":0,
"targetedMargin":0,
"spreadGrossMarginSell":0,
"percentTotal":0,
"totalCalcdMargin":0
}
},
"rateMap":{
"GBP":1,
"AUD":"1.87999999",
"BRL":"5.39999999",
"CAD":"1.75999999",
"CLP":"986.66765087",
"CNY":"9.93333315",
"DKK":"8.73040009",
"EUR":"1.12000000",
"JPY":"149.79994180",
"MXN":"26.26666728",
"MYR":"5.43999997",
"SEK":"0.14666667",
"SGD":"1.80000000",
"THB":"42.26666834"
},
"marginTotalStdCost":94751,
"marginTotalCogs":94751,
"marginTotalTargetedSellPrice":103347,
"marginTotalTargetedCalcdMargin":0.08317609606471399,
"bookingTotalStdCost":101740,
"bookingTotalCogs":101740,
"bookingTotalTargetedSellPrice":110336,
"bookingTotalTargetedCalcdMargin":0.07790748259860791,
"totalStdCost":101740,
"totalCogs":101740,
"totalTargetedSellPrice":110336,
"totalTargetedCalcdMargin":0.07790748259860791,
"marginTotalRevenue":135361,
"marginTotalCalcdMargin":0.3000125590088726,
"bookingTotalRevenue":142350,
"bookingTotalCalcdMargin":0.2852827537759045,
"totalRevenue":142350,
"totalCalcdMargin":0.2852827537759045,
"systemISO":"USD"
}
}`;
var jsonParsedData=JSON.parse(jsonData);
for (var data in jsonParsedData) {
console.log("totalCogs")
console.log('-2-'+jsonParsedData[data].totalCogs)
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句