Filter json data in node js

Question

I am receiving following data in the form of json

 [{
     "Id": 1,
     "sku": "abc",
     "name": "Abbey Black Round Glass and Chrome 3 Tier Stand",
     "qty": 14
   },
   {
     "Id": 3,
     "sku": "abc",
     "name": "Ammy Black Glass and Chrome 5 Tier Corner Stand",
     "qty": 0
   },
   {
     "Id": 4,
     "sku": "abc",
     "name": "Barcelona Adjustable Gas Lift Black Bar Stool (Set of 2)",
     "qty": 0
   }
 ]

I have to filter data so that it shows only following key-value pair

sku
qty

Expected result will be

[{
    "sku": "abc",
    "qty": 14
  },
  {

    "sku": "abc",
    "qty": 0
  },
  {

    "sku": "abc",
    "qty": 23
  }
]

Any solution to filter data in such a format?. I can filter data based on specific values but I want json data containing only two pairs (sku,qty)

Ankit Agarwal · Accepted Answer · 2018-07-31 10:48:51Z

1

You can use Array.map() with array destructuring to make your code simple and short:

var data = [
  {
      "Id": 1,
      "sku": "abc",
      "name": "Abbey Black Round Glass and Chrome 3 Tier Stand",
      "qty": 14
  },
  {
      "Id": 3,
      "sku": "abc",
      "name": "Ammy Black Glass and Chrome 5 Tier Corner Stand",
      "qty": 0
  },
  {
      "Id": 4,
      "sku": "abc",
      "name": "Barcelona Adjustable Gas Lift Black Bar Stool (Set of 2)",
      "qty": 23
   }
];
var res = data.map(({sku, qty}) => ({sku, qty}));
console.log(res);

answered Jul 31, 2018 at 10:48

Ankit Agarwal

30.8k5 gold badges41 silver badges63 bronze badges

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

1 Comment

Ankit Agarwal Over a year ago

@mohammadobaid glad to help

Zeeshan Tariq · Accepted Answer · 2018-07-31 10:50:29Z

1

You can do it with map like this:

var array=[
    {
        "Id": 1,
        "sku": "abc",
        "name": "Abbey Black Round Glass and Chrome 3 Tier Stand",
        "qty": 14
    },
    {
        "Id": 3,
        "sku": "abc",
        "name": "Ammy Black Glass and Chrome 5 Tier Corner Stand",
        "qty": 0
    }];

array.map(function(item) { 
    delete item.Id; 
delete item.name; 
    return item; 
});

answered Jul 31, 2018 at 10:50

Zeeshan Tariq

6345 silver badges10 bronze badges

1 Comment

mohammad obaid Over a year ago

Thanks for the help , however above answer works seamlessly for me

Collectives™ on Stack Overflow

Filter json data in node js

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related