Convert or Format data of Nested Arrays in JSON Objects to Nested JSON Objects in Typescript For Bind Kendo Grid

Question

I have been trying to convert a data of Nested Arrays in JSON Objects to Nested JSON Objects in Typescript. This is return data from rest api as getting in typescript:

Nested array contains square brackets.

data={ "ID":29614,"Ratio":8,"UOM":"IN", "manufacturers": [{ "manufacturerName": "john", "categories": [{ "categoryName": "Beverage", "products": [{ "uid": "567", "productID": 130927, "name": "After Shocks Popping Candy 1.06"}] }] } , { "manufacturerName": "Dan", "categories": [{ "categoryName": "Organization", "products": [{ "uid": "65", "productID": 5656, "name": "After Shocks Popping Candy 2.06"}] }] } ] }


Format I need is:

data=[{ "ID":29614,"Ratio":8,"UOM":"IN", "manufacturers": { "manufacturerName": "john", "categories": { "categoryName": "Beverage", "products": { "uid": "567", "productID": 130927, "name": "After Shocks Popping Candy 1.06"} } } , { "manufacturerName": "Dan", "categories": { "categoryName": "Organization", "products": { "uid": "65", "productID": 5656, "name`enter code here`": "After Shocks Popping Candy 2.06"} } } }]

Output nested array should remove square brackets.

I have tried this as

public gridData: any[];
//gridData  for bind Kendo grid 

return this.restApi.getProductBin().subscribe((data: {}) => {
this.gridData = Array.of(data); //convert to array
}

Kendo Grid binding UI format as: <kendo-grid [data]="gridData" [height]="150" style="float:left;"> <kendo-grid-column field="ID" title="ID" width="50"> </kendo-grid-column> <kendo-grid-column field="manufacturers.manufacturerName" title="manufacturerName" width="50"> </kendo-grid-column> </kendo-grid> — ASP.NET
– ASP.NET, Commented Dec 30, 2019 at 15:30
This is a horribly written question. Kindly improve. You don't need good english, you simply need good formatting. — DUDANF
– DUDANF, Commented Dec 30, 2019 at 15:53

David Fagerburg · Accepted Answer · 2019-12-30 16:48:28Z

1

If all you want to do is remove the square brackets, you could stringify the JSON, use a regular expression to remove all '[' and ']', and then parse it back into a JSON object:

getNoArrayJSON(data: {}): {} {
    let dataString = JSON.stringify(data);
    dataString = dataString.replace(/(\[)|(\])/g, "");
    return JSON.parse(dataString);
});

I wouldn't do this unless you know that the arrays in the response you're dealing with will only ever have a size of 1.

Working Example: RegEx Remove arrays

If you're set on putting that result in an array, let newData = [getNoArrayJSON(data)]; and the format will exactly match your desired output.

answered Dec 30, 2019 at 16:48

David Fagerburg

514 bronze badges

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

2 Comments

ASP.NET Over a year ago

Could you please Format below data = { "ID":29614,"Ratio":8,"UOM":"IN", "manufacturers": [{ "manufacturerName": "john", "categories": [{ "categoryName": "Beverage", "products": [{ "uid": "567", "productID": 130927, "name": "After Shocks Popping Candy 1.06"}] }] } , { "manufacturerName": "Dan", "categories": [{ "categoryName": "Organization", "products": [{ "uid": "65", "productID": 5656, "name": "After Shocks Popping Candy 2.06"}] }] } ] } @David Fagerburg

ASP.NET Over a year ago

Could you please help me to format of multiple size of data @David Fagerburg

Adrita Sharma · Accepted Answer · 2019-12-30 15:31:32Z

0

Try like this:

  output = [];

  constructor() {
    this.output.push({
      ID: this.data.ID,
      Ratio: this.data.Ratio,
      UOM: this.data.UOM,
      manufacturers: {
        manufacturerName: this.data.manufacturers[0].manufacturerName,
        categories: {
          categoryName: this.data.manufacturers[0].categories[0].categoryName,
          products: this.data.manufacturers[0].categories[0].products[0]
        }
      }
    });
  }

Working Demo

answered Dec 30, 2019 at 15:31

Adrita Sharma

22.3k11 gold badges75 silver badges85 bronze badges

2 Comments

ASP.NET Over a year ago

,@MEDZ ,I there any way to remove Square brackets without mention array object names to use commonly.@Adrita Sharma

ASP.NET Over a year ago

Could you plz help to this JSon data loop through,To remove square brackets.@Adrita Sharma

Collectives™ on Stack Overflow

Convert or Format data of Nested Arrays in JSON Objects to Nested JSON Objects in Typescript For Bind Kendo Grid

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related