Searching through JSON object

Question

I am trying to search through a json object to select some values. For example I have a variable with the value 'product-2' and I want to look through the json object and return the attributes array of 'product-2'

{

 "attributes": [     
...
 ],
"portfolio": [
{
    "conn": [
        {

                "product": "product-1",
                "description": "Description in here",
                 "attributes": [
                    "OriginPostcode",
                    "Size",
                    "Bandwidth"
                ],

        },
        {

                "product": "product-2",
                "description": "Description in here"
                 "attributes": [
                    "OriginPostcode",
                    "Size",
                    "Bandwidth"
                ],
            }

    ]

}
]

Could anyone tell me how I can achieve this? Thank you

EDIT:

As per Pramods request - I was working with the following js (although its really wrong I am sure)

$scope.productAttributes = [];
    $scope.getProductDetails = function (product_id) {
        console.log(product_id);
        //search trough json
        angular.forEach($scope.listOfProducts.product_id, function(value, key) {

           // I was thinking I could loop through the json and when I find the matching product, then push its attributes into an array?
           // if (key === enteredValue) {
             //   $scope.productAttributes.push({atribute: key});
           // }
        });
    };

EDIT No.2

The JSON structure has changed

http://stackoverflow.com/questions/5288833/how-to-search-json-tree-with-jquery — Markvds, Feb 13 '15 at 12:19
i think You have to use ` portfolio.conn[1].product-2.attributes ` use if work than ask me i will comment it because you have to accept these answer — Gunjan Patel, Feb 13 '15 at 12:26
You could try using JPath : http://www.s-anand.net/blog/jpath-xpath-for-javascript/ — Pramod Karandikar, Feb 13 '15 at 12:32
Hey Gunjan - I tried that, Im already using allProducts.data.portfolio[0].conn to get to the product list. but I can't figure out how to search through conn for 'product-2' and loads its attributes into an array — Jose the hose, Feb 13 '15 at 14:31
Use a filter to destructure the array: $filter('filter')($scope.listOfProducts, {product: "product-2"})[0] — Martin, Feb 13 '15 at 16:20

score 1 · Accepted Answer · answered Feb 13 '15 at 16:09

Use a filter to destructure the array.

In my example I use a filter within a Controller. This should probably be done in a service or a view. For brevity I used the filter in a controller.

The filter expression essentially says, return the first object in the array with a property 'product' that is 'product-2'

var app = angular.module('app', []).controller('MyController', MyController);

MyController.$inject = ['$filter'];
function MyController($filter) {

  var data = [
        {

                "product": "product-1",
                "description": "Description in here",
                 "attributes": [
                    "OriginPostcode",
                    "Size",
                    "Bandwidth"
                ],

        },
        {

                "product": "product-2",
                "description": "Description in here",
                 "attributes": [
                    "OriginPostcode",
                    "Size",
                    "Bandwidth"
                ],
            }
    ]
  
    
    this.product = $filter('filter')(data, {product: "product-2"})[0];
  
}

<script src="https://ajax.googleapis.com/ajax/libs/angularjs/1.2.23/angular.min.js"></script>
<div ng-app="app">
  <div ng-controller="MyController as vm">
    Product-2: {{vm.product}}
  </div>
</div>

score 0 · Answer 2 · edited May 23 '17 at 12:27

0

Well, if you don't know how product-2 will be nested and you actually need to search for it, then you need to do a recursive search. A recursive function is a function that calls itself.

This means that you iterate over each of the keys, and if the key is an object, call the recursive function on that key as well, until the key you want is found.

Here is a similar question, with a few algorithms provided for doing recursive search on a JSON structure in JavaScript: traversing through JSON string to inner levels using recursive function

edited May 23 '17 at 12:27

Community

1
1

answered Feb 13 '15 at 14:00

Calvin Froedge

16,135
16
55
61

Thanks - I do know how the product-2 will be nested, as above. Does that mean I shouldn't do a recursive search? – Jose the hose Feb 13 '15 at 14:28
The do as Gunjan Patel said in his comment. – Calvin Froedge Feb 13 '15 at 14:39

score 0 · Answer 3 · answered Feb 13 '15 at 15:05

I think your JSON is wrong , So please correct it

Correct JSON

{
    "attributes": [],
"portfolio": [
    {
    "conn": [
        {
            "product-1": {
                "label": "product-1",
                "description": "Description in here",
        "attributes": [
                    "OriginPostcode",
                    "Size",
                    "Bandwidth"
                ],
            }
        },
        {
            "product-2": {
                "label": "product-2",
                "description": "Description in here",
         "attributes": [
                    "OriginPostcode",
                    "Size",
                    "Bandwidth"
                ],
            }
        }
        ]
    }
]
}

And to parse above json and return product information following is the code

$(document).ready(function() {
    $.each(dict['portfolio'][0], function(key, list){
        $.each(list, function(index, value){
            $.each(value, function(product, info){
                if (product == "product-2"){
                    answer = {}
                    answer[product] = info;
                    return JSON.stringify(answer);
                }
            });
        });
    }); 
});

Fiddle link :-

http://fiddle.jshell.net/2t8uknkc/

Searching through JSON object

3 Answers3