javascript parse nested json with dynamic variable

Question

I'm trying to parse some nested json returned by an api call. Below is a simplified version of what is being returned.

{
  "Includes":{
    "Products":{
      "P123456":{
        "Brand":{},
        "Description":"ipsem lorem",
        "Statistics":
          [
           "Author":"John Smith",
           "IsFeatured":false,
           "Total": 3
          ]
       }
     }
   }
 }

I've tried several different syntaxes to get what I need where product_code = "P123456"

data.Includes.Products.product_code.Statistics
data.Includes.Products[product_code].Statistics

I've also tried using 'get' and 'eval' to no avail. The error response is always the same

application.js:1639 Uncaught TypeError: Cannot read property 'Statistics' of undefined

I know the product code is correct as I have console logged it. I have also successfully console.logged

data.Includes.Products["P123456"].Statistics

How can I access the data nested under the product code, "P123456" ? The project uses zepto and not jQuery.

Wainage · Accepted Answer · 2016-03-18 22:02:34Z

3

Object.keys(data.Includes.Products) will return an array of keys under products.

If you want the first one Object.keys(data.Includes.Products)[0].

Statistics can be retrieved

var key = Object.keys(data.Includes.Products);
var statistics = data.Includes.Products[key].Statistics;

Pure JavaScript ... no libraries.

PS. Your JSON is malformed. That "Statistics" array is going to cause tears.

edited Mar 18, 2016 at 22:02

answered Mar 18, 2016 at 21:35

Wainage

5,5423 gold badges16 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

margo Over a year ago

This worked, thank you. None of the other answers seemed to take note that I have no control over the data being returned. I tried using $.getJSON and $.ajax. I'm unexperienced with js and json, would you mind explaining how the json is malformed? Not sure why my question was downvoted.

Wainage Over a year ago

Glad I could help. Your "Statistics" key points to an Array [ ] should be another object { }. @Nina Scholz has the correct JSON in her answer. Not sure about the downvotes :(

Wainage Over a year ago

BTW. Can you tag this as the correct answer. I'm new and need the rep so I can comment outside of my answers.

Nina Scholz · Accepted Answer · 2016-03-18 21:22:08Z

With valid data structure, you can access it via

object.Includes.Products.P123456

or

object.Includes.Products[product_code]

var object = {
        "Includes": {
            "Products": {
                "P123456": {
                    "Brand": {},
                    "Description": "ipsem lorem",
                    "Statistics": { // its an object, not an array
                        "Author": "John Smith",
                        "IsFeatured": false,
                        "Total": 3
                    }
                }
            }
        }
    },
    product_code = 'P123456';

document.write('<pre>' + JSON.stringify(object.Includes.Products.P123456, 0, 4) + '</pre>');
document.write('<pre>' + JSON.stringify(object.Includes.Products[product_code], 0, 4) + '</pre>');

Jamel de la Fuente · Accepted Answer · 2016-03-18 21:24:26Z

0

Did you already tried this? data.Includes.Products.P123456.Statistics ? It looks like property and not a indexed string.

answered Mar 18, 2016 at 21:24

Jamel de la Fuente

697 bronze badges

Collectives™ on Stack Overflow

javascript parse nested json with dynamic variable

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related