Datatable with JSON

Question

I’m making a datatable with ajax return.

$.getJSON("sql.php?operacao=usuario_lista&excluidos=false", function (data) {
    alert(data.users);

    $('#tabusuarios').DataTable({
        "aaData": data.users,
        "aoColumns": [
            { "mDataProp": "ID" },
            { "mDataProp": "NOME" },
            { "mDataProp": "USUARIO" }
        ]
    });
});

My JSON returns to:

{
    "users": [
        {
            "ID": "89",
            "NOME": "aaabbbb",
            "USUARIO": "a.b",
            "DTNASC": "2017-01-01",
            "NUM": "112233"
        },
        {
            "ID": "76",
            "NOME": "Bruno Pereira",
            "USUARIO": "brunopereira",
            "DTNASC": "2011-01-01",
            "NUM": "11"
        }
    ]
}

But he gives the error:

Datatables Warning: table id=tabusuarios - Cannot reinitialise Datatable. For more information about this error, Please see http://datatables.net/tn/3

And don’t populate a table..

Answer 1

In accordance with reply on Soen, you can do it this way:

$(document).ready(function() {
    $('#tabusuarios').DataTable({
        "processing" : true,
        "ajax" : {
            "url" : "sql.php?operacao=usuario_lista&excluidos=false",
            dataSrc : ''
        },
        "columns" : [ {
            "data" : "ID"
        }, {
            "data" : "NOME"
        }, {
            "data" : "USUARIO"
        }]
    });
});