Datatables warning(table id = ‘example’): cannot reinitialise data table

In this tutorial, we will discuss how to fix the error, Datatables warning(table id = ‘example’): cannot reinitialise data table.

Datatables warning(table id = ‘example’): cannot reinitialise data table

The error comes while I was trying to retrieve more than 5000 items using Rest API from a SharePoint Online list and was trying to bind to the data to DataTables.

Here, I was using the code like below:

$('#Employee').DataTable({
	"aaData": response,
	"aoColumns": [
	{
	"mData": "Title"
	}
	]
	});

But it gave the error when I tried to execute the code. It gave error as:

DataTables warning: table id=Employee – Cannot reinitialise DataTable. For more information about this error, please see http://datatables.net/tn/3

To fix the error, you need to add the below attribute.

"bDestroy": true

It will look like below:

$('#Employee').DataTable({
	"aaData": response,
	"bDestroy": true,
	"aoColumns": [
	{
	"mData": "Title"
	}
	]
	});

You may like following SharePoint rest api tutorials:

• Create, Update and Delete SharePoint List using Rest API in SharePoint
• Retrieve SharePoint list items programmatically using jsom, rest api and csom
• How to display dynamic contents into a page using Rest API in SharePoint Online
• How to Display SharePoint List items using AngularJS and REST Api
• How to bind SharePoint Online list data using HTML and jQuery table using Rest API
• Rest API filter list items created by logged in user SharePoint
• How to make synchronous Rest API call in SharePoint Online/2013/2016 using jQuery?

After this the error did not came, this fix the issue Datatables warning(table id = ‘example’): cannot reinitialise data table.