working with JSON array information

Question

working with JSON array information

I have a JSON array retrieved from a database that I need to manipulate. Currently, it consists of 8 separate elements and I would like to condense it down to just 2 elements while nesting the rest. The current structure of my JSON looks like this:

{
  "itemId": 1,
  "desc": [{
    "type": "A",
    "size": "xx",
    "count": 12,
    "price": 122
  },
  {
    "type": "A",
    "size": "xl",
    "count": 18,
    "price": 180
  },
  {
    "type": "B",
    "size": "xx",
    "count": 12,
    "price": 122
  },
  {
    "type": "B",
    "size": "xl",
    "count": 12,
    "price": 122
  }]
}

The data needs to be transformed into the following format:

{
 "type": "A",
  "desc":{
    "size": "xx",
    "count": 12,
    "price": 122
  },
  {
    "size": "xl",
    "count": 12,
    "price": 122
  },
 },
  {
 "type": "B",
  "desc":{
    "size": "xx",
    "count": 12,
    "price": 122
  },
  {
    "size": "xl",
    "count": 12,
    "price": 122
  },
 }

Although I am currently using a forEach loop to achieve this, it is producing individual elements instead of the desired two elements in the resulting array. Any solutions or suggestions would be greatly appreciated.

javascript arrays json

Answer 1

Answer №1

One way to approach this is by using the following code:

var newData = {
    A: {type: 'A', desc: []},
    B: {type: 'B', desc: []}
};

$.each(data.desc, function( index, value ) {
  newData[value.type].desc.push(value);
});

You can also handle unknown types dynamically with the following code:

var newData = {};

$.each(data.desc, function( index, value ) {
  if(typeof newData[value.type] === "undefined") {
    newData[value.type] = {type: value.type, desc: [value]}
  } else {
    newData[value.type].desc.push(value);
  }
});

For a working example, you can visit https://jsfiddle.net/5cnaxn04/1/

Answer 2

One way to approach this is by using the following code:

var newData = {
    A: {type: 'A', desc: []},
    B: {type: 'B', desc: []}
};

$.each(data.desc, function( index, value ) {
  newData[value.type].desc.push(value);
});

You can also handle unknown types dynamically with the following code:

var newData = {};

$.each(data.desc, function( index, value ) {
  if(typeof newData[value.type] === "undefined") {
    newData[value.type] = {type: value.type, desc: [value]}
  } else {
    newData[value.type].desc.push(value);
  }
});

For a working example, you can visit https://jsfiddle.net/5cnaxn04/1/

Answer 3

Answer №2

Your code contains multiple syntax errors, particularly with the use of {} for both Arrays and Objects. It seems like you may need to incorporate some loops in order to format the data correctly according to your desired output.

For a demonstration, refer to this JSFiddle link.

Answer 4

Your code contains multiple syntax errors, particularly with the use of {} for both Arrays and Objects. It seems like you may need to incorporate some loops in order to format the data correctly according to your desired output.

For a demonstration, refer to this JSFiddle link.

working with JSON array information

Answer №1

Answer №2

Similar questions

Nuxt 3.11 - Best Practices for Integrating the `github/relative-time-element` Dependency

Unable to locate a contact within the state

NodeJS: Issue when implementing try/catch with async/await causing SyntaxError

The value entered is displaying as not defined

The Lenis smooth scrolling feature (GSAP) is not functioning properly

What causes the inconsistency in TypeScript's structure typing?

Combining two numbers retrieved from Firebase using React

There are multiple sets of radio buttons within nested ng-repeats, but only the final group displays the selected value

Associating checkbox options with an array that is void of elements

Eliminate duplicated partial objects within a nested array of objects in TypeScript/JavaScript

Transform every character into its corresponding ASCII value within the JSON object

Having difficulty retrieving model values from the angular ui modal dialog

The Django template is unable to retrieve the JSON Key when it is enclosed in double quotes like this: {" 'Key' ": " Value "}

How to programmatically close a colorbox using an ASP.NET form's Submit button within an iframe

Error encountered with the OffsetWidth in the Jq.carousel program

Why isn't my JSON data being transmitted accurately from the front end to the back end?

AWS Amplify-hosted Nuxt applications are resilient to errors during the build process

When using Vue.js and Quasar to implement multiple filtering forms, an issue arises where the input value disappears

The process of implementing web-based online diagramming software involves a strategic approach to designing and integrating various

Switching between vertical and horizontal div layouts while reorganizing text fields within the top div