Add JSON data to datatable

Question

I want to add JSON data to a existing datatable.

The JSON data looks like this:

[
    ["Trident","Internet Explorer 4.0","Win 95+","4","X","X"],
    ["Trident","Internet Explorer 4.0","Win 95+","4","X","X"],
    ["Trident","Internet Explorer 4.0","Win 95+","4","X","X"],
    ["Trident","Internet Explorer 4.0","Win 95+","4","X","X"]
]

I tried:

$('#' + tab + '_table').dataTable().fnAddData(data);

data is holding the JSON data.

Anything seems wrong there since it adds only one row with this:

enter image description here

user1864610 · Accepted Answer · 2014-01-19 01:25:59Z

6

It looks like you're asking dataTables to add raw JSON data to your table. You should parse it first with JSON.parse() and add the resulting Javascript array.

var jsdata = JSON.parse(data);
$('#' + tab + '_table').dataTable().fnAddData(jsdata);

answered Jan 19, 2014 at 1:25

user1864610

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

2 Comments

TheNiceGuy Over a year ago

Okay one more question. How can i remove the existing rows? So that it does not just adds them but removes the old ones before? Thanks

user1864610 Over a year ago

Use fnClearTable() to empty the table completely, or fnDeleteRow() to be more selective. Details are in the API docs for DataTables

Collectives™ on Stack Overflow

Add JSON data to datatable

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related