JSON error on using jquery datatable

Question

[{"name":"aaa","firstname":"bbb","lastname":"ccc"},
{"name":"qqq","firstname":"eee","lastname":"mmm"},
{"name":"www","firstname":"ooo","lastname":"lll"}]

I am making ajax request to server, its returning the above json data.But i >am getting the json parse error

$(document).ready(function() {
    $('#example').dataTable( {
        "processing": true,
        "serverSide": true,
        "ajax": {
                "url": "http://example",
                "dataType": "jsonp",
        "columns": [
                { "data": "name"},
                { "data": "firstname" },
                { "data": "lastname" }
            ]
            }
        } );
});

is this the right way to assign columns ?datatables.net/examples/ajax/objects.html — Frebin Francis
– Frebin Francis, Commented Feb 12, 2015 at 8:56
@RohanKumar, well - he is getting a result back, and using jsonp .... So no, has nothing to do with Same-origin policy. — davidkonrad
– davidkonrad, Commented Feb 12, 2015 at 8:57
DataTables warning: table id=example - Invalid JSON response. For more information about this error, please see datatables.net/tn/1 — Gikar
– Gikar, Commented Feb 12, 2015 at 9:22

V31 · Accepted Answer · 2015-02-12 09:07:11Z

1

Your ajax attribute should not contain the column attribute.:

Code:

$(document).ready(function() {
    $('#example').dataTable( {
        "processing": true,
        "serverSide": true,
        "ajax": {
                "url": "http://example",
                "dataType": "jsonp"
        },
        "columns": [
                 { "data": "name"},
                 { "data": "firstname" },
                 { "data": "lastname" }
            ]
        } );
});

edited Feb 12, 2015 at 9:07

answered Feb 12, 2015 at 8:59

V31

7,6643 gold badges28 silver badges44 bronze badges

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

3 Comments

Gikar Over a year ago

If i remove jsonp, i am getting Same origin policy error

V31 Over a year ago

@GirishMahindrakar, ok for same origin policy can be added like that, however your ajax and columns where overlapping which I have shown in the answer

davidkonrad Over a year ago

+1. Good spot. I also think this is the correct answer. @GirishMahindrakar, you have simply malformed initialization options :)

Collectives™ on Stack Overflow

JSON error on using jquery datatable

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related