jquery datatable get json data from ajax

Question

I want to build a datatable from the json data I am getting on the server

    $(document).ready(function() {
        $('#example').DataTable( {

        "ajax": "/analyze/List",
        "columns": [
        { responsedata: "Name" },
        { responsedata: "Total" },
        { responsedata: "Passed" },
        { responsedata: "Failed" }]  

        } );
    } );

Didn't work.Is that not how it's supposed to be done ? .

Here's the json data format on server-

{"responseCode":0,"responseData":[{"Name":"Rocky","Total":39,"Passed":35,"Failed":4}]}

Also, I'm an error Uncaught TypeError: Cannot read property 'length' of undefined. Could someone help ? I'm a noob in this.

Check out the "Ajax" tab on the example, I think your JSON needs to be formatted differently: datatables.net/examples/data_sources/ajax.html — Adam
– Adam, Commented Aug 12, 2016 at 14:50

davidkonrad · Accepted Answer · 2016-08-14 10:03:13Z

3

Yu are doing it a little bit backwards. Use the dataSrc attribute to instruct dataTables that the rows is hold by the responseData property, and refer to each field via the data attribute, not responseData :

$('#example').DataTable({
    ajax: {
        url: '/analyze/List',
        dataSrc: 'responseData'
    },
    columns: [
      { data: "Name" }, 
      { data: "Total" }, 
      { data: "Passed" },
      { data: "Failed" }
    ]
})

demo -> http://jsfiddle.net/2qycjwaz/

answered Aug 14, 2016 at 10:03

davidkonrad

85.7k17 gold badges211 silver badges273 bronze badges

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

Collectives™ on Stack Overflow

jquery datatable get json data from ajax

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related