javascript - How to parse JSON with multiple rowsresults - Stack Overflow

admin管理员组

文章数量:1355540

I don't know if this is malformed JSON string or not, but I cannot work out how to parse each result to get the data out.

This is the data.d response from my $.ajax function (it calls a WebMethod in Code Behind (C#)):

{"Row":[
{"ID1":"TBU9THLCZS","Project":"1","ID2":"Y5468ASV73","URL":"","Wave":"w1","StartDate":"18/06/2015 5:46:41 AM","EndDate":"18/06/2015 5:47:24 AM","Status":"1","Check":"0"},
{"ID1":"TBU9THLCZS","Project":"2","ID2":"T7J6SHZCH","URL":"","Wave":"w1","StartDate":"23/06/2015 4:35:22 AM","EndDate":"","Status":"","Check":""}
]}

With all the examples I have looked at, only one or two showed something where my 'Row' is, and the solutions were not related, such as one person had a ma after the last array.

I would be happy with some pointers if not even the straight out answer.

I have tried various binations of response.Row, response[0], using $.each, but I just can't get it.

EDIT, this is my ajax call:

$.ajax({
    url: "Mgr.aspx/ShowActivity",
    type: "POST",
    data: JSON.stringify({
        "ID": "null"
    }),
    contentType: "application/json; charset=utf-8",
    dataType: "json",
    success: function (response) {
        var data = response.hasOwnProperty("d") ? response.d : response;
        console.log(data);
    },
    error: function (xhr, ajaxOptions, thrownError) {
        $('#lblResErr').html('<span style="color:red;">' + thrownError);
    }
});

At the moment I have just been trying to get ID1 value and ID2 value into the console.

EDIT (Resolved): Thanks to YTAM and Panagiotis !

success: function (response) {
    var data = response.hasOwnProperty("d") ? response.d : response;
    data = JSON.parse(data);
    console.log(data);
}

Now the console is showing me an array of two objects, and now I know what to do with them !!

I don't know if this is malformed JSON string or not, but I cannot work out how to parse each result to get the data out.

This is the data.d response from my $.ajax function (it calls a WebMethod in Code Behind (C#)):

{"Row":[
{"ID1":"TBU9THLCZS","Project":"1","ID2":"Y5468ASV73","URL":"http://blah1.","Wave":"w1","StartDate":"18/06/2015 5:46:41 AM","EndDate":"18/06/2015 5:47:24 AM","Status":"1","Check":"0"},
{"ID1":"TBU9THLCZS","Project":"2","ID2":"T7J6SHZCH","URL":"http://blah2.","Wave":"w1","StartDate":"23/06/2015 4:35:22 AM","EndDate":"","Status":"","Check":""}
]}

With all the examples I have looked at, only one or two showed something where my 'Row' is, and the solutions were not related, such as one person had a ma after the last array.

I would be happy with some pointers if not even the straight out answer.

I have tried various binations of response.Row, response[0], using $.each, but I just can't get it.

EDIT, this is my ajax call:

$.ajax({
    url: "Mgr.aspx/ShowActivity",
    type: "POST",
    data: JSON.stringify({
        "ID": "null"
    }),
    contentType: "application/json; charset=utf-8",
    dataType: "json",
    success: function (response) {
        var data = response.hasOwnProperty("d") ? response.d : response;
        console.log(data);
    },
    error: function (xhr, ajaxOptions, thrownError) {
        $('#lblResErr').html('<span style="color:red;">' + thrownError);
    }
});

At the moment I have just been trying to get ID1 value and ID2 value into the console.

EDIT (Resolved): Thanks to YTAM and Panagiotis !

success: function (response) {
    var data = response.hasOwnProperty("d") ? response.d : response;
    data = JSON.parse(data);
    console.log(data);
}

Now the console is showing me an array of two objects, and now I know what to do with them !!

• javascript
• jquery
• ajax
• json

Share Improve this question Follow edited Jun 24, 2015 at 6:56 RossS asked Jun 24, 2015 at 6:39 RossSRossS 4911 gold badge22 silver badges88 bronze badges 4

• 1 The question is marked both C# and Ajax, although it seems you are asking how to parse Json in Javascript. What did you try? Where is the code? Just parse the entire string, In any language, you'll get back an object with a Row array that contains 2 objects – Panagiotis Kanavos Commented Jun 24, 2015 at 6:43
• Apologies if marking C# as well confused the issue - I thought it might best as there might be something pertinent in the fact the ajax function was calling a function in C#. – RossS Commented Jun 24, 2015 at 6:47
• Actually, you should remove both the ajax and c# tag, add javascript and post the code you tried. It sounds as if you only have trouble accessing the properties of the resulting object. Which is kind of strange, response.Row[0] is the obvious choice - you have a response object with a Row property that is actually an array – Panagiotis Kanavos Commented Jun 24, 2015 at 6:50
• You guys Panagiotis and YTAM are legends, that was it ! I will update my code above. – RossS Commented Jun 24, 2015 at 6:54

Add a ment  | 

2 Answers 2

Sorted by: Reset to default 2

First you have to parse the string with JSON.parse

var data= JSON.parse(rowData);

Then you will get object like given below,

data = {
"Row": [
{
  "ID1":"TBU9THLCZS",
  "Project":"1",
  "ID2":"Y5468ASV73",
  "URL":"http://blah1.",
  "Wave":"w1",
  "StartDate":"18/06/2015 5:46:41 AM",
  "EndDate":"18/06/2015 5:47:24 AM",
  "Status":"1",
  "Check":"0"
},
{
  "ID1":"TBU9THLCZS",
  "Project":"2",
  "ID2":"T7J6SHZCH",
  "URL":"http://blah2.",
  "Wave":"w1",
  "StartDate":"23/06/2015 4:35:22 AM",
  "EndDate":"",
  "Status":"",
  "Check":""
}
]}

Here I am giving two options either direct retrieve data from data variable or through loop.

data.row[0].ID1
data.row[0].Project
data.row[0].ID2

and so on

OR

use loop,

var result = json.row;
for (var i = 0; i < result.length; i++) {
  var object = result[i];
   for (property in object) {
    var value = object[property];
  }
}

Hope this helps.

you may be getting a json string from the web method rather than an actual JavaScript object. Parse it into a JavaScript object by doing

var data = JSON.parse(response); 

then you'll be able to iterate over data.Row

本文标签： javascriptHow to parse JSON with multiple rowsresultsStack Overflow