How to search json structure

Question

I'm attempting to search through this json for a specific value.

I would like to search by the State value, such as 'NH' and get back the MaintenancePercentage and OfficePercentage.

I've tried looping through payrollDefaults.State and I'm getting back nothing.

var payrollDefaults =
    [
        {
            "State": "NH",
            "MaintenancePercentage": 21.45,
            "OfficePercentage": 22.56
        },
        {
            "State": "NC",
            "MaintenancePercentage": 21.79,
            "OfficePercentage": 22.41
        },
        {
            "State": "OH",
            "MaintenancePercentage": 21.33,
            "OfficePercentage": 22.25
        },
        {
            "State": "RI",
            "MaintenancePercentage": 23.04,
            "OfficePercentage": 23.22
        },
        {
            "State": "SC",
            "MaintenancePercentage": 21.31,
            "OfficePercentage": 31.33
        },
        {
            "State": "TX",
            "MaintenancePercentage": 35.6,
            "OfficePercentage": 24.48
        },
        {
            "State": "VA",
            "MaintenancePercentage": 32.32,
            "OfficePercentage": 30.47
        },
        {
            "State": "AL",
            "MaintenancePercentage": 13.33,
            "OfficePercentage": 12.42
        },
        {
            "State": "CA",
            "MaintenancePercentage": 49.37,
            "OfficePercentage": 59.67
        },
        {
            "State": "FL",
            "MaintenancePercentage": 34.62,
            "OfficePercentage": 31.06
        },
        {
            "State": "GA",
            "MaintenancePercentage": 35.55,
            "OfficePercentage": 30.29
        },
        {
            "State": "IN",
            "MaintenancePercentage": 33.45,
            "OfficePercentage": 30.69
        },
        {
            "State": "MA",
            "MaintenancePercentage": 32.9,
            "OfficePercentage": 29.34
        },
        {
            "State": "MI",
            "MaintenancePercentage": 34.95,
            "OfficePercentage": 29.46
        },
        {
            "State": "MT",
            "MaintenancePercentage": 35.91,
            "OfficePercentage": 30.02
        }
    ]

EDIT:

I ended up converting this from a string to JSON.

var json = $.parseJSON(payrollDefaults);

FYI: This isn't JSON. It's a JavaScript array. JSON is a string representation of data that resembles JavaScript syntax. If it's not a string, it's not JSON. — gen_Eric
– gen_Eric, Commented Oct 18, 2013 at 16:04
payrollDefaults.State is not a value. payrollDefaults is an array, loop through each element, and then check it's .State value. — gen_Eric
– gen_Eric, Commented Oct 18, 2013 at 16:05
The code above shows a Javascript array. Also there's no such thing as a JSON object. benalman.com/news/2010/03/theres-no-such-thing-as-a-json — Tom Bowers
– Tom Bowers, Commented Oct 18, 2013 at 16:16
@UmarFarooqKhawaja Each array element is actually a JavaScript object, not JSON. JSON = JavaScript Object Notation. JSON is a format to use within a string or file which can then be parsed by the JSON object to become a JavaScript object. The term "JSON object" is generally reserved for the native JavaScript object containing the methods for parsing JSON and stringifying JS objects (i.e. JSON.parse() and JSON.stringify() respectively). — guypursey
– guypursey, Commented Oct 18, 2013 at 16:21

Hakan Bilgin · Accepted Answer · 2014-01-07 07:04:53Z

You could use this JS lib, DefiantJS (http://defiantjs.com) - which extends the global object JSON with the method "search". With this method, you can search a JSON structure with XPath expressions and it returns an array (empty if no matches were found).

var payrollDefaults = [
        { "State": "NH", "MaintenancePercentage": 21.45, "OfficePercentage": 22.56 },
        { "State": "NC", "MaintenancePercentage": 21.79, "OfficePercentage": 22.41 },
        { "State": "OH", "MaintenancePercentage": 21.33, "OfficePercentage": 22.25 },
        { "State": "RI", "MaintenancePercentage": 23.04, "OfficePercentage": 23.22 },
        { "State": "SC", "MaintenancePercentage": 21.31, "OfficePercentage": 31.33 },
        { "State": "TX", "MaintenancePercentage": 35.6,  "OfficePercentage": 24.48 },
        { "State": "VA", "MaintenancePercentage": 32.32, "OfficePercentage": 30.47 },
        { "State": "AL", "MaintenancePercentage": 13.33, "OfficePercentage": 12.42 },
        { "State": "CA", "MaintenancePercentage": 49.37, "OfficePercentage": 59.67 },
        { "State": "FL", "MaintenancePercentage": 34.62, "OfficePercentage": 31.06 },
        { "State": "GA", "MaintenancePercentage": 35.55, "OfficePercentage": 30.29 },
        { "State": "IN", "MaintenancePercentage": 33.45, "OfficePercentage": 30.69 },
        { "State": "MA", "MaintenancePercentage": 32.9,  "OfficePercentage": 29.34 },
        { "State": "MI", "MaintenancePercentage": 34.95, "OfficePercentage": 29.46 },
        { "State": "MT", "MaintenancePercentage": 35.91, "OfficePercentage": 30.02 }
    ],
    res = JSON.search( payrollDefaults, '//*[State = "NH"]' );

console.log( res[0].MaintenancePercentage );
console.log( res[0].OfficePercentage );

Here is a working fiddle:
http://jsfiddle.net/hbi99/dMLdc/

Tom Bowers · Accepted Answer · 2013-10-18 16:15:37Z

0

This should do the trick...

http://jsfiddle.net/6zn7H/

function findState(state) {
    for(var i =0, l = payrollDefaults.length; i < l; i++){
        var value = payrollDefaults[i];
        if(value.State === state){
            return value;
        }
    }
}

Also note that this loop only evaluates the length once, and not on each iteration, helping efficiency.

edited Oct 18, 2013 at 16:15

answered Oct 18, 2013 at 16:04

Tom Bowers

5,1413 gold badges33 silver badges46 bronze badges

3 Comments

Tom Bowers Over a year ago

Anyone want to justify their downvote? This answer works and addresses the question.

guypursey Over a year ago

Happened to mine too. Strange. Your answer is more thorough so definitely didn't deserve it, but I don't think even mine was misleading or incorrect enough to warrant downvoting!

Tom Bowers Over a year ago

@guypursey Happens all over the place on SO. I think there's downvote ninjas whose sole boring purpose in life is to discredit correct answers in an attempt to undermine the system!

guypursey · Accepted Answer · 2013-10-18 16:03:21Z

0

You need to provide an index for the payrollDefaults array else your program won't know which specific object you want to pull the value of State from.

Just as an example, here's how to loop through all the State properties and print their values in the console.

for (var i = 0, l = payrollDefaults.length; i < l; i += 1) {
    console.log(payrollDefaults[i].State);
}

Notice the [i] and how that refers to a specific object in your array?

Hope that helps make sense of what you were missing!

answered Oct 18, 2013 at 16:03

guypursey

3,2043 gold badges27 silver badges43 bronze badges

1 Comment

guypursey Over a year ago

Bad answer? I thought this addressed the main part of the question which I took to be: "I've tried looping through payrollDefaults.State and I'm getting back nothing." I didn't provide a solution because I figured the OP already had that bit nailed and was missing something simple...

Robin · Accepted Answer · 2013-10-18 16:04:53Z

0

$.each(payrollDefaults,function(key,val){
  if(val.state == "NH"){
   console.log(val.MaintenancePercentage);
   console.log(val.OfficePercentage);
  }

});

This should help you

answered Oct 18, 2013 at 16:04

Robin

8649 silver badges20 bronze badges

Comments

forivall · Accepted Answer · 2013-10-18 16:04:54Z

0

Using lodash.js's find

_.find(payrollDefaults, {State: 'NH'});
>>> {
        "State": "NH",
        "MaintenancePercentage": 21.45,
        "OfficePercentage": 22.56
    }

answered Oct 18, 2013 at 16:04

forivall

10k3 gold badges37 silver badges58 bronze badges

Comments

ovunccetin · Accepted Answer · 2013-10-18 16:05:13Z

0

Try the below function:

function findByState(givenState) {
    var result = [];
    for(p in payrollDefaults) {
        if (p.State === givenState) {
            result.push(p);
        }
    }

    return result;
}

answered Oct 18, 2013 at 16:05

ovunccetin

8,7635 gold badges46 silver badges53 bronze badges

Comments

iJade · Accepted Answer · 2013-10-18 16:09:01Z

0

Here is how you need to search for a particular state

function GetMaintainancePercentage(state) {
    for (var i = 0; i < payrollDefaults.length; i++) {
        if (payrollDefaults[i]["State"] == state) {
            alert('Maintainance Percenatge is ' + payrollDefaults[i]["MaintenancePercentage"]);
        }
    }
}

Here is a demo

edited Oct 18, 2013 at 16:09

answered Oct 18, 2013 at 16:06

iJade

23.9k58 gold badges163 silver badges251 bronze badges

Comments

Aditya Singh · Accepted Answer · 2013-10-18 16:11:09Z

0

Try this out:- http://jsfiddle.net/ba5ZQ/1/

JS:-

var arr = jQuery.grep(payrollDefaults, function( a ) {
  return a.State =="NH";
});

console.log(arr);

answered Oct 18, 2013 at 16:11

Aditya Singh

9,6125 gold badges35 silver badges56 bronze badges

Collectives™ on Stack Overflow

How to search json structure

8 Answers 8

Comments

3 Comments

1 Comment

Comments

Comments

Comments

Comments

Try this out:- http://jsfiddle.net/ba5ZQ/1/

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

Comments

3 Comments

1 Comment

Comments

Comments

Comments

Comments

Try this out:- http://jsfiddle.net/ba5ZQ/1/

Comments

Your Answer

Sign up or log in

Post as a guest

Related