How to eliminate top-level elements in a JSON object

Question

How to eliminate top-level elements in a JSON object

Here is the initial JSON payload:

{
    "Products": {
      "Product": [
        {
          "ProductID": 458761,
          "Designation": "CB 024-2001",
          "EntryDate": "2002-01-20T19:00:00.000-05:00",
          "S1": "024",
          "S2": 2001,
          "Year": 2001
        },
        {
          "ProductID": 458234,
          "Designation": "AGRS03/08",
          "EntryDate":"2008-03-05T19:00:00.000-05:00",
          "S1": "03",
          "S2": "08",
          "Year": 2008
        }
      ]
    }
  }

I need to convert it into a different JSON format like this:

[
    {
      "Designation": "CB 024-2001",
      "EntryDate": "2002-01-20T19:00:00.000-05:00",
      "ProductID": 458761,
      "S1": "024",
      "S2": 2001,
      "Year": 2001
    },
    {
      "Designation": "AGRS03/08",
      "EntryDate": "2008-03-05T19:00:00.000-05:00",
      "ProductID": 458761,
      "S1": "03",
      "S2": "08",
      "Year": 2008
    }
  ]

If anyone could provide assistance in writing a JavaScript code for this transformation, that would be greatly appreciated. Thank you!

javascript json

Answer 1

Answer №1

UPDATE: I noticed that the question has been altered.

If your initial JSON data is stored in a variable called input, you can retrieve the necessary information by using this JavaScript code snippet:

var output = input.Products.Product;

ORIGINAL IDEA: One way to achieve this task is by utilizing the map method:

var output = input.Products.Product.map(function(inObj) {
    return {
        "Designation": inObj.Designation,
        "EntryDate": inObj.EntryDate,
        "S1": inObj.S1,
        "S2": inObj.S2,
        "Year": inObj.Year
    }
});

This will produce the desired result - an array of objects without the ProductIDs included. Another approach could involve manipulating object references with the help of delete:

var output = input.Products.Product.map(function(inObj) {
    var outObj =  inObj;
    delete outObj.ProductID;
    return outObj;
});

It's important to note that this modification will also affect the original values stored in the input variable, so caution is advised if you intend to utilize that data later on.

Answer 2

UPDATE: I noticed that the question has been altered.

If your initial JSON data is stored in a variable called input, you can retrieve the necessary information by using this JavaScript code snippet:

var output = input.Products.Product;

ORIGINAL IDEA: One way to achieve this task is by utilizing the map method:

var output = input.Products.Product.map(function(inObj) {
    return {
        "Designation": inObj.Designation,
        "EntryDate": inObj.EntryDate,
        "S1": inObj.S1,
        "S2": inObj.S2,
        "Year": inObj.Year
    }
});

This will produce the desired result - an array of objects without the ProductIDs included. Another approach could involve manipulating object references with the help of delete:

var output = input.Products.Product.map(function(inObj) {
    var outObj =  inObj;
    delete outObj.ProductID;
    return outObj;
});

It's important to note that this modification will also affect the original values stored in the input variable, so caution is advised if you intend to utilize that data later on.

Answer 3

Answer №2

let initial = {
  "Items": {
      "Item": [
          {
              "ItemID": 458761,
              "Name": "CB 024-2001",
              "DateAdded": "2002-01-20T19:00:00.000-05:00",
              "Category1": "024",
              "Category2": 2001,
              "Year": 2001
          },
          {
              "ItemID": 458234,
              "Name": "AGRS03/08",
              "DateAdded": "2008-03-05T19:00:00.000-05:00",
              "Category1": "03",
              "Category2": "08",
              "Year": 2008
          }
      ]
  }
}

let modified = initial.Items.Item;

In order to customize it as per your requirements:

for(let index = 0; index < modified.length; index++){

 delete modified[index].ItemID;

 }

Answer 4

let initial = {
  "Items": {
      "Item": [
          {
              "ItemID": 458761,
              "Name": "CB 024-2001",
              "DateAdded": "2002-01-20T19:00:00.000-05:00",
              "Category1": "024",
              "Category2": 2001,
              "Year": 2001
          },
          {
              "ItemID": 458234,
              "Name": "AGRS03/08",
              "DateAdded": "2008-03-05T19:00:00.000-05:00",
              "Category1": "03",
              "Category2": "08",
              "Year": 2008
          }
      ]
  }
}

let modified = initial.Items.Item;

In order to customize it as per your requirements:

for(let index = 0; index < modified.length; index++){

 delete modified[index].ItemID;

 }

Answer 5

Answer №3

Here is a convenient function that you can utilize:

var data = {
  "Products": {
    "Product": [{
      "ID": 458761,
      "Name": "CB 024-2001",
      "DateAdded": "2002-01-20T19:00:00.000-05:00",
      "S1": "024",
      "S2": 2001,
      "Year": 2001
    }, {
      "ID": 458234,
      "Name": "AGRS03/08",
      "DateAdded": "2008-03-05T19:00:00.000-05:00",
      "S1": "03",
      "S2": "08",
      "Year": 2008
    }]
  }
};


function modifyJSON(array){
  var products = array.Products.Product;
  products.forEach(function(item){delete item.ID});
  return JSON.stringify(products);
}

document.write(modifyJSON(data));

Answer 6

Here is a convenient function that you can utilize:

var data = {
  "Products": {
    "Product": [{
      "ID": 458761,
      "Name": "CB 024-2001",
      "DateAdded": "2002-01-20T19:00:00.000-05:00",
      "S1": "024",
      "S2": 2001,
      "Year": 2001
    }, {
      "ID": 458234,
      "Name": "AGRS03/08",
      "DateAdded": "2008-03-05T19:00:00.000-05:00",
      "S1": "03",
      "S2": "08",
      "Year": 2008
    }]
  }
};


function modifyJSON(array){
  var products = array.Products.Product;
  products.forEach(function(item){delete item.ID});
  return JSON.stringify(products);
}

document.write(modifyJSON(data));

Answer 7

Answer №4

Using underscores:

const newResults = _.map(data.Products.Products, (product) => {
    return _.omit(product, 'ProductID');
});

Answer 8

Using underscores:

const newResults = _.map(data.Products.Products, (product) => {
    return _.omit(product, 'ProductID');
});

How to eliminate top-level elements in a JSON object

Answer №1

Answer №2

Answer №3

Answer №4

Similar questions

Only the first parameter is recognized by the Ajax POST method

Issues with rendering in Next.jsORErrors encountered during rendering

Is it possible to utilize jQuery for extracting information from HTML pages?

Is it possible for a web server to transmit information without being prompted by the client?

Guide on adjusting the spotlight(s) based on the camera's location in Three.js?

Click on the button to add a new question and watch as another row magically appears

NPM encountered difficulties in resolving the dependency tree

How to display JSON data in a table using UI5

What is the best way to display a dialog after a successful API call in a React application?

How can you optimize the storage of keys in JS objects?

Tips for merging JSON outputs

Issue with child rows not functioning properly in DataTables when utilizing Datetime-moment

Integrating Cache and Resolved Promises in Angular's UI-Router: A Comprehensive Guide

Ways to retrieve Json Data

How can I ensure that a radio button remains checked when selecting a disabled option in Internet Explorer?

Share content on Facebook using a single-page application

Pushing state history causes browser back and forward button failure

When you click on `window.open('my-app://', '_blank');`, it won't directly open the desktop app from the browser. However, typing `my-app://`

Error in AngularJs: [$injector:modulerr] Unable to create schemaForm module instance

Creating a new tab within a window that is already open