Add new row to DataTable dynamically

VivekRao

Hi everyone,
I got stuck in adding a row to a datatable. on a page load i am loading data into datatable. I am trying to add a row to the same datatable by creating a instance of it. It says unknow parameter, I couldn't find any issues with data or the parameter. Please help.

Here is my
JSON when the page laods
{
"ID": 1,
"UserName": "NA",
"CallStatus": "",
"Cancelled": null,
"Completed":null,
"CompletedPercentage": null,
"ConvDate":null,
"CreatedorModifiedDate":"/Date(-2208970800000)/",
"EmailID": null,
"Favorites": 0,
"Firstname": "ANNIE",
"Image": "default_user.png",
"PhoneNumber": "",
}

I am trying to add row with JSON which has same items, but it says unknown parameter for phonenumber. Phone number is a string data type in my code.
Here is the code how i am adding a row to datatable

/Creating a instance of the datatable/
var newTable = $('#table2').DataTable();

/Adding row/
newTable.row.add([{
"ID": 1,
"UserName": "NA",
"CallStatus": "",
"Cancelled": null,
"Completed":null,
"CompletedPercentage": null,
"ConvDate":null,
"CreatedorModifiedDate":"/Date(-2208970800000)/",
"EmailID": null,
"Favorites": 0,
"Firstname": "ANNIE",
"Image": "default_user.png",
"PhoneNumber": "",
}]).draw();

this is the version i am using https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js

Thank you

kthorngren

The row.add() api expects only one row and that the object data is not in an array. The example in the doc shows this. You are adding the object within an array.

However, rows.add() does expects an array of the object(s) to add.

You can either use rows.add() with your current data within an array or just add the object with row.add().

Kevin

bindrid

where is your code that defines the column names?

I should see something like

var newTable = $('#table2').DataTable({
columns:[
{data:"ID"}, {data:"UserName"}
]});

for each column you want to show in the table. Also, these names are case sensitive.

take a look at https://datatables.net/reference/option/columns

VivekRao

Hi kthorngren. row.add worked but i am not sure why its not adding to the table. i am not getting any errors.When i try to run same code in Console tab of chrome, it adds a row, but when i do the same thing in javascript file of the page it does nothing. Bindrid i really appreciate your quick response.

allan

We'd really need to be able to see your page to be able to help in that case. Can you give us a link please?

Allan