How to load a table using datatables ajax?

Question

How to load a table using datatables ajax?

Navigation

#1 by (1 votes)

2

I'm trying to load a table using the datatables component.

The return of this ajax request is a json object in this format:

data = {
  "CLIENTES": {
    "0": {
      "ID": "1",
      "NOME": 'GABRIEL'
    },
    "1": {
      "ID": "2",
      "NOME": 'RODRIGUES'
    }
  }
}

In the documentation columns data it is mentioned that the following structure should be created:

table.DataTable({
  "ajax": url,
  columns: [
    {"data": "CLIENTES.ID"},
    {"data": "CLIENTES.NOME"}
  ]
});

But access to indexes is not done correctly, in this case they should be accessed:

{"data": "CLIENTES['0'].ID"},
{"data": "CLIENTES['1'].ID"},

Dynamically, how could I do this?

There is a related question that also did not solve my question: Load table with json using datatables

javascript html jquery-datatables

asked by anonymous 25.02.2016 / 13:13

1 answer

Navigation Drawer without interaction when clicked Subtract days to current date with PHP [duplicate]

score 1 · Accepted Answer

I just recreated the array by removing CUSTOMERS using the $.map function.

Solution:

$(document).ready(function() {
    data = {
      "CLIENTES": {
        "0": {
           "ID": "1",
           "NOME": 'GABRIEL'
        },
       "1": {
           "ID": "2",
           "NOME": 'RODRIGUES'
         }
       }
     };


   var newData = $.map(data.CLIENTES, function(el) { return el });

   $('#example').DataTable({
       data: newData,
       columns: [
       {"data": "ID"},
       {"data": "NOME"}
       ]
    });

});

See working at jsfiddle