Get row number of json data

Question

I have a ajax request which returns data in json format like

{
    "response_code": 1,
    "response_data": {
        "ext": [
            {
                "client_id":"1003",
                "company_name":"Reachmediagg"
            },
            {
                "client_id":"1004",
                "company_name":"RaSpecial"
            }
        ],
        "row_count":2
    },
    "response_error":""
}

As you can see the data is inside the ext array inside json object, now I have to get the row number of the data, so I want for example row number of client_id 1004, which is 2. How will I do that in javascript?

possible duplicate http://stackoverflow.com/questions/4935632/parse-json-in-javascript — Ratul Sharker, Nov 02 '15 at 19:26
Could you run the JSON response through a JSON parser/formatter so that it's easier to read here? — StoicJester, Nov 02 '15 at 19:28
response_data is double encoded json (e.g. `JSON.parse(res.response_data)`) — Shanimal, Nov 02 '15 at 19:31
This question mixes two trivial problems, and this isn't clear from the title. In this way this attracts hits from Google which will all be disappointed. So not a good question... — oberlies, Sep 09 '19 at 12:29

Thijs Riezebeek · Accepted Answer · 2015-11-02T19:39:24.837

2

You have to loop through the ext array in your JSON and find the element that holds the correct client_id. The function described below does just that.

function get_row_number(data, client_id) {
    var ext = data.ext;

    // Loop through all the clients and try to find the one with the given client_id
    for (var i = 0; i < ext.length; i++) {
        if (ext[i].client_id == client_id)
            return i;
    }

    // Return -1 if the client_id could not be found
    return -1;
}

edited Nov 02 '15 at 19:39

answered Nov 02 '15 at 19:37

Thijs Riezebeek

1,762
1
15
22

1

you should be looping over ext, not data – StoicJester Nov 02 '15 at 19:38

score 0 · Answer 2 · answered Nov 02 '15 at 19:37

Technically the data doesn't have row numbers. Only in how you read the data can you infer/assign a row number.

Note that ext is an array. You can loop over that array until you find the record you want and keep a counter. For example:

var counter = 0;
for (;counter <= response_data.ext.length; counter++) {
    if (response_data.ext[counter].client_id == 1004) {
        break;
    }
}
// here "counter" is the "row number" where client_id == 1004

You can also extract this into a function where the target client_id is a parameter (or the condition itself is a parameter, allowing you to look for more than just client_id).

Get row number of json data

2 Answers2