Answers

• kthorngren Posts: 20,342Questions: 26Answers: 4,775

  February 2019

  Here is an example I created for other threads with the same question.
  http://live.datatables.net/huyexejo/1/edit

  It uses jQuery Ajax to fetch the data and the success function to extract the first row to build the columns. Note the use of columns.title to build the column headers.

  Kevin
• rajeevs.zone@yahoo.co.in Posts: 2Questions: 1Answers: 0

  February 2019 edited February 2019

  Thanks @kthorngren
  My question is how can I define nested json here.I tried below but it doesn't works.

  success: function (data) {
  //console.log(data);
  data = getData();
  data = JSON.parse(data);

      columnNames = Object.keys(data[0]);
      for (var i in columnNames) {
        if (columnNames[i] == "Allocations") {
          var allocationColumnNames = getAllocationColumnNames(data[0].Allocations);
          for (var j in allocationColumnNames) {
            console.log("A=" + data[0].Allocations[j].AvailableHours);
            columns.push({data: data[0].Allocations[j].AvailableHours, 
                  title: allocationColumnNames[j]});  
          }
  
        } else {
          columns.push({data: columnNames[i], 
                  title: columnNames[i]});  
        }
  
      }
  

  function getAllocationColumnNames(allocations) {
  var allocationColumnNames = [];
  for(var i in allocations) {
  allocationColumnNames[i] = allocations[i].AllocDate;
  }
  return allocationColumnNames;
  }

  function getData() {
  //return above nested json
  return data;
  }
• kthorngren Posts: 20,342Questions: 26Answers: 4,775

  February 2019

  My question is how can I define nested json here.I tried below but it doesn't works.

  My suggestion would be to look on SO for a code snippet that gets the keys of a nested object. Maybe this thread as an example.

  Kevin