Filter nested JSON with jQuery for empty values

Question

I have a nested JSON which looks like this:

var unfilteredJSON = {  
   "payload":{  
      "oldKeys":[  
         "125262"
      ],
      "keyData":[  
         {  
            "key":"123456",
            "products":[  
               {  
                  "prodId":"H1",
                  "qty":"1"
               },
               {  
                  "prodId":"H2",
                  "qty":""
               }
            ],
            "rushFee":"true"
         },
         {  
            "key":"234234",
            "products":[  
               {  
                  "prodId":"H1",
                  "qty":"1"
               },
               {  
                  "prodId":"H2",
                  "qty":""
               }
            ],
            "rushFee":"false"
         }
      ],
      "submit":"false"
   }
}

The qty key can have empty values in the object. I want to filter the data with jQuery method and remove the object with blank qty so the JSON can look like this -

{  
   "payload":{  
      "oldKeys":[  
         "125262"
      ],
      "keyData":[  
         {  
            "key":"123456",
            "products":[  
               {  
                  "prodId":"H1",
                  "qty":"1"
               },
            ],
            "rushFee":"true"
         },
         {  
            "key":"234234",
            "products":[  
               {  
                  "prodId":"H1",
                  "qty":"1"
               },
            ],
            "rushFee":"false"
         }
      ],
      "submit":"false"
   }
}

Please help.

ggorlen · Accepted Answer · 2018-10-06 19:17:18Z

2

Here's a filter approach which mutates the object in-place:

var unfilteredJSON = {"payload":{"oldKeys":["125262"],"keyData":[{"key":"123456","products":[{"prodId":"H1","qty":"1"},{"prodId":"H2","qty":""}],"rushFee":"true"},{"key":"234234","products":[{"prodId":"H1","qty":"1"},{"prodId":"H2","qty":""}],"rushFee":"false"}],"submit":"false"}};

unfilteredJSON.payload.keyData.forEach(e => 
  e.products = e.products.filter(p => p.qty)
);

console.log(unfilteredJSON);

edited Oct 6, 2018 at 19:17

answered Oct 6, 2018 at 19:05

ggorlen

59.4k8 gold badges119 silver badges173 bronze badges

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

3 Comments

Aluan Haddad Over a year ago

Note that this does not use jQuery nor should it.

Akshay Over a year ago

Its giving me error in Internet explorer for this - unfilteredJSON.payload.keyData.forEach(e => e.products = e.products.filter(p => p.qty) );

ggorlen Over a year ago

It's probably the arrow functions. You can replace =>s with function (e) { ... }.

Collectives™ on Stack Overflow

Filter nested JSON with jQuery for empty values

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related