如何在javascript中提取JSON对象?

阿文德

我一直在尝试使用 JS 从下面的 json 中获取对象。它是一个直接变量但仍然没有成功。我已经厌倦了使用 For 循环没有运气我尝试使用 JSON.parse 这给了我错误。console.log('-0-' + JSON.stringify(getTotalProducts));

甚至对 JSON 数组进行硬编码也不起作用

所以当你这个 JSON 对象时,我有这样的记录列表a4wg0000000sdsGAA0a4wg000000asdaMGAA0等等。我想获得名为 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"
  }
}
Jijin

我相信即使您不知道密钥名称,您也需要访问 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)
}

jsBin上的对象示例

本文收集自互联网,转载请注明来源。

如有侵权,请联系 [email protected] 删除。

编辑于
0

我来说两句

0 条评论
登录 后参与评论

相关文章

如何在Android中提取JSON对象?

如何在Hive中提取嵌套的JSON对象

如何在 JavaScript 中提取对象的重复值?

如何使用javascript从JSON返回的对象中提取特定值?

如何使用密钥从 json 中提取对象?

如何从 BeautifulSoup 对象中提取 JSON?

如何从String Builder中提取json对象?

如何从 JSON 对象中提取元素

如何从json嵌套对象中提取数据?

如何在PHP中的JSON对象中提取对象并为其分配正确的索引

如何在Java中按名称从JSON数组中提取JSON对象?

如何在量角器中从 JSON 对象中提取字符串

如何在 json 对象数组中提取深嵌套和浅嵌套字段

如何在Presto中的嵌套json数组对象中提取键?

pandas 数据框 - 如何在 json 对象中提取特定值

如何从 JSON 中的对象数组中提取对象?

如何存储由ajax查询从javascript中的JSON中提取数据的结果组成的对象数组?

如何使用python json从JSON文件中提取特定对象

如何使用 JQ 从 JSON 数组中提取 JSON 对象

在Javascript中提取对JSON对象的API响应的特定部分

从数组中提取json对象

如何在Delphis LiveBindings中提取BindSource的对象?

从javascript对象中提取数组

从 javascript 对象中提取值

如何从php中的JSON对象中提取变量?

我如何从JSON结果中提取对象usinig angularJS

如何通过json_query从数组中提取对象?

如何使用 PHP 从数组中提取多个 JSON 对象?

如何使用python从JSON对象中提取特定数据?