Tips for retrieving nested JSON objects

Question

Tips for retrieving nested JSON objects

I'm struggling to access the nested JSON object values through iteration.

Even after attempting

console.log(test[0].Invoice[0].Cost.NO[0]);

, I still can't get it to work.

var test = [{
  "Invoice": {
    "NO": "869",
    "$$hashKey": "object:186"
  },
  "Cost": [{
    "NO": 183,
    "Amnt": 100
  }, {
    "NO": 184,
    "Amnt": 200
  }]
}, {
  "Invoice": {
    "NO": "698",
    "$$hashKey": "object:189"
  },
  "Cost": [{
    "NO": 110,
    "Amnt": 150
  }, {
    "NO": 142,
    "Amnt": 263
  }]
}];

console.log(test[0].Invoice[0].Cost.NO[0]);

javascript json

Answer 1

Answer №1

It appears your code using

console.log(test[0].Invoice[0].Cost.NO[0]);

is not functioning correctly.

It seems that Invoice and Cost are objects on the same level (Cost is not nested within Invoice).

Refer to the example below for guidance on accessing them properly.

It is essential to have a good understanding of Arrays [] and Objects {}.

var test = [{
  "Invoice": {
    "NO": "869",
    "$$hashKey": "object:186"
  },
  "Cost": [{
    "NO": 183,
    "Amnt": 100
  }, {
    "NO": 184,
    "Amnt": 200
  }]
}, {
  "Invoice": {
    "NO": "698",
    "$$hashKey": "object:189"
  },
  "Cost": [{
    "NO": 110,
    "Amnt": 150
  }, {
    "NO": 142,
    "Amnt": 263
  }]
}];

// Accessing COST
console.log(test[0].Cost[0].NO);

// Accessing Invoice
console.log(test[0].Invoice.NO);

Answer 2

It appears your code using

console.log(test[0].Invoice[0].Cost.NO[0]);

is not functioning correctly.

It seems that Invoice and Cost are objects on the same level (Cost is not nested within Invoice).

Refer to the example below for guidance on accessing them properly.

It is essential to have a good understanding of Arrays [] and Objects {}.

var test = [{
  "Invoice": {
    "NO": "869",
    "$$hashKey": "object:186"
  },
  "Cost": [{
    "NO": 183,
    "Amnt": 100
  }, {
    "NO": 184,
    "Amnt": 200
  }]
}, {
  "Invoice": {
    "NO": "698",
    "$$hashKey": "object:189"
  },
  "Cost": [{
    "NO": 110,
    "Amnt": 150
  }, {
    "NO": 142,
    "Amnt": 263
  }]
}];

// Accessing COST
console.log(test[0].Cost[0].NO);

// Accessing Invoice
console.log(test[0].Invoice.NO);

Answer 3

Answer №2

Here is the JSON data for you:

let data = [{
  "Invoice": {
    "Number": "869"
  },
  "Cost": [{
    "Number": 183,
    "Amount": 100
  }, {
    "Number": 184,
    "Amount": 200
  }]
}, {
  "Invoice": {
    "Number": "698"
  },
  "Cost": [{
    "Number": 110,
    "Amount": 150
  }, {
    "Number": 142,
    "Amount": 263
  }]
}];

console.log(data[0].Cost[0].Number);

will result in 183

If you are unfamiliar with JSON, you can use console.log(data) to verify the structure during development.

To iterate through the data, you can use a loop like the one explained here: https://www.w3schools.com/jsref/jsref_forEach.asp

Here is a simple example:

let myFunction = function(item, index){
    console.log(item.Cost[0].Number);
 }
 data.forEach(myFunction)

Answer 4

Here is the JSON data for you:

let data = [{
  "Invoice": {
    "Number": "869"
  },
  "Cost": [{
    "Number": 183,
    "Amount": 100
  }, {
    "Number": 184,
    "Amount": 200
  }]
}, {
  "Invoice": {
    "Number": "698"
  },
  "Cost": [{
    "Number": 110,
    "Amount": 150
  }, {
    "Number": 142,
    "Amount": 263
  }]
}];

console.log(data[0].Cost[0].Number);

will result in 183

If you are unfamiliar with JSON, you can use console.log(data) to verify the structure during development.

To iterate through the data, you can use a loop like the one explained here: https://www.w3schools.com/jsref/jsref_forEach.asp

Here is a simple example:

let myFunction = function(item, index){
    console.log(item.Cost[0].Number);
 }
 data.forEach(myFunction)

Answer 5

Answer №3

testing entails working with an array, so you must iterate through it.

During each iteration, you will receive an object with 2 properties: Invoice and Cost

Invoice is once again an object, so you only need to access the specific property you require

Cost is an array, meaning you need to iterate over each item, which are objects

var testing = [{
  "Invoice": {
    "NO": "869",
    "$$hashKey": "object:186"
  },
  "Cost": [{
    "NO": 183,
    "Amnt": 100
  }, {
    "NO": 184,
    "Amnt": 200
  }]
}, {
  "Invoice": {
    "NO": "698",
    "$$hashKey": "object:189"
  },
  "Cost": [{
    "NO": 110,
    "Amnt": 150
  }, {
    "NO": 142,
    "Amnt": 263
  }]
}];

testing.forEach(t=>{
  console.log("Invoice N°: " + t.Invoice.NO);
  t.Cost.forEach(c=>{
    console.log("- Cost N°: "+ c.NO + " - Amount: " + c.Amnt);
  });
});

Answer 6

testing entails working with an array, so you must iterate through it.

During each iteration, you will receive an object with 2 properties: Invoice and Cost

Invoice is once again an object, so you only need to access the specific property you require

Cost is an array, meaning you need to iterate over each item, which are objects

var testing = [{
  "Invoice": {
    "NO": "869",
    "$$hashKey": "object:186"
  },
  "Cost": [{
    "NO": 183,
    "Amnt": 100
  }, {
    "NO": 184,
    "Amnt": 200
  }]
}, {
  "Invoice": {
    "NO": "698",
    "$$hashKey": "object:189"
  },
  "Cost": [{
    "NO": 110,
    "Amnt": 150
  }, {
    "NO": 142,
    "Amnt": 263
  }]
}];

testing.forEach(t=>{
  console.log("Invoice N°: " + t.Invoice.NO);
  t.Cost.forEach(c=>{
    console.log("- Cost N°: "+ c.NO + " - Amount: " + c.Amnt);
  });
});

Answer 7

Answer №4

Your statement is incorrect

test[0].Invoice[0].Cost.NO[0]

The correct format is

 test[0].Cost[0].NO

Since Invoice and Cost are properties of the same JSON object.

Please give this a try

  var test = [{ "Invoice": { "NO": "869", "$$hashKey": "object:186" }, "Cost": [{ "NO": 183, "Amnt": 100 }, { "NO": 184, "Amnt": 200 }] }, { "Invoice": { "NO": "698", "$$hashKey": "object:189" }, "Cost": [{ "NO": 110, "Amnt": 150 }, { "NO": 142, "Amnt": 263 }] }];

  console.log(test[0].Cost[0]);
 console.log(test[0].Cost[0].NO);

Answer 8

Your statement is incorrect

test[0].Invoice[0].Cost.NO[0]

The correct format is

 test[0].Cost[0].NO

Since Invoice and Cost are properties of the same JSON object.

Please give this a try

  var test = [{ "Invoice": { "NO": "869", "$$hashKey": "object:186" }, "Cost": [{ "NO": 183, "Amnt": 100 }, { "NO": 184, "Amnt": 200 }] }, { "Invoice": { "NO": "698", "$$hashKey": "object:189" }, "Cost": [{ "NO": 110, "Amnt": 150 }, { "NO": 142, "Amnt": 263 }] }];

  console.log(test[0].Cost[0]);
 console.log(test[0].Cost[0].NO);

Answer 9

Answer №5

 let example = [{ "Invoice": { "NO": "869", "$$hashKey": "object:186" }, "Cost": [{ "NO": 183, "Amnt": 100 }, { "NO": 184, "Amnt": 200 }] }, { "Invoice": { "NO": "698", "$$hashKey": "object:189" }, "Cost": [{ "NO": 110, "Amnt": 150 }, { "NO": 142, "Amnt": 263 }] }];
        for (let e in example)
        {
            let obj = example[e];
            console.log(obj.Invoice.NO);
            console.log(obj.Invoice.$$hashKey);
            for (let cost in obj.Cost)
            {
                console.log("Cost Value: " + obj.Cost[cost].NO + " " + obj.Cost[cost].Amnt);
            }
        }

Answer 10

 let example = [{ "Invoice": { "NO": "869", "$$hashKey": "object:186" }, "Cost": [{ "NO": 183, "Amnt": 100 }, { "NO": 184, "Amnt": 200 }] }, { "Invoice": { "NO": "698", "$$hashKey": "object:189" }, "Cost": [{ "NO": 110, "Amnt": 150 }, { "NO": 142, "Amnt": 263 }] }];
        for (let e in example)
        {
            let obj = example[e];
            console.log(obj.Invoice.NO);
            console.log(obj.Invoice.$$hashKey);
            for (let cost in obj.Cost)
            {
                console.log("Cost Value: " + obj.Cost[cost].NO + " " + obj.Cost[cost].Amnt);
            }
        }

Tips for retrieving nested JSON objects

Answer №1

Answer №2

Answer №3

Answer №4

Answer №5

Similar questions

What are the steps to transforming a regular expression into a dynamic format?

The AnimationMixer is refusing to start playing the animation from the gltf file

Retrieving a MongoDB collection using its unique ID

Unable to send data to Spring Controller from form submission

What could be causing my ul list to not be populated by ajax?

Unable to conceal tab content upon clicking the identical tab

Verifying the selection state of a dynamically generated checkbox with JavaScript

Stop javascript function from automatically invoking itself

Object displaying no visible illumination

Node.js & Express: Bizarre file routes

What is the best way to convert a JSON object into a C# object within a Xamarin Get API?

"Need to remove all chosen selections within an ng-repeat loop? Here's how

What is the best way to bring a string into my .tsx file using a relative reference from a module?

The backend error message isn't triggering an alert!

What is the JSON Schema counterpart to XSD's maxOccurs property?

Is it possible to save an HTML5 Canvas screenshot directly onto the page?

What is the best way to execute a .js file with a Mocha suite repeatedly within a loop?

Function useAppDispatch is missing a return type

Developing an npm library with ReactJs: A step-by-step guide

AngularJS ng-repeat - cascading dropdown not refreshing