Jquery Get specific values from JSON result?

Question

How can I select some fields from this Json Result or response which has the blow format

var WPQ3ListData = { "Row" : 
[{
  "ID": "27",
  "PermMask": "0x400001f07fff1bff",
  "FSObjType": "0",
  "Title": "NOOO",
  "FileLeafRef": "27_.000",
  "TotalCost": "87",
  "TotalCost.": "87.0000000000000",
  "TC1ID": "23",
  "TotalCost.SUM": "160"
}]
}

for example I want to select TotalCost.SUM value and store it into a variable on document.ready of jQuery

That response is coming from SharePoint 2013 why it is wrong — MJ X, Feb 22 '15 at 07:47
possible duplicate of [How to get JSON objects value if its name contains dots?](http://stackoverflow.com/questions/2577172/how-to-get-json-objects-value-if-its-name-contains-dots) — Pushker Yadav, Feb 22 '15 at 07:50

void · Accepted Answer · 2015-02-22T07:48:30.910

3

You can fetch it using WPQ3ListData.row[0]["TotalCost.SUM"]

var WPQ3ListData = { "Row" : 
[{
  "ID": "27",
  "PermMask": "0x400001f07fff1bff",
  "FSObjType": "0",
  "Title": "NOOO",
  "FileLeafRef": "27_.000",
  "TotalCost": "87",
  "TotalCost.": "87.0000000000000",
  "TC1ID": "23",
  "TotalCost.SUM": "160"
}]
};

$(document).ready(function(){
  var valueReq = WPQ3ListData.Row[0]["TotalCost.SUM"];
});

edited Feb 22 '15 at 07:48

answered Feb 22 '15 at 07:42

void

36,090
8
62
107

I think `row` should be `Row` – hawk Feb 22 '15 at 07:47
@hawk Yep a typo.. Thanks for notifying. – void Feb 22 '15 at 07:50
Thinks it worked perfect you put Row in small case upper case worked var valueReq = WPQ3ListData.Row[0]["TotalCost.SUM"]; – MJ X Feb 22 '15 at 07:52

Akshat · Answer 2 · 2015-02-22T08:06:10.127

0

It should be done with associative array indexing ie, object["property"]

var WPQ3ListData = { "Row" : 
[{
  "ID": "27",
  "PermMask": "0x400001f07fff1bff",
  "FSObjType": "0",
  "Title": "NOOO",
  "FileLeafRef": "27_.000",
  "TotalCost": "87",
  "TotalCost.": "87.0000000000000",
  "TC1ID": "23",
  "TotalCost.SUM": "160"
}]
}



$(document).ready(function(){
  var value = WPQ3ListData.Row[0]["TotalCost.SUM"];
});

edited Feb 22 '15 at 08:06

answered Feb 22 '15 at 07:44

Akshat

479
4
9

In `JSON.parse()` first argument must be `text` corresponding to JSON as string. – hawk Feb 22 '15 at 07:59
Mistake on my end. It should be done with associative array indexing. I edited my answer. – Akshat Feb 22 '15 at 08:06

score 0 · Answer 3 · answered Feb 22 '15 at 07:48

`WPQ3ListData.Row[0]["TotalCost.SUM"]`

    var WPQ3ListData = { "Row" : 
    [{
      "ID": "27",
      "PermMask": "0x400001f07fff1bff",
      "FSObjType": "0",
      "Title": "NOOO",
      "FileLeafRef": "27_.000",
      "TotalCost": "87",
      "TotalCost.": "87.0000000000000",
      "TC1ID": "23",
      "TotalCost.SUM": "160"
    }]
    };

    $(document).ready(function(){
      var requestValue = WPQ3ListData.Row[0]["TotalCost.SUM"];
    });

Jquery Get specific values from JSON result?

3 Answers3