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 ?http://www.datatables.net/examples/ajax/objects.html — Frebin Francis, Feb 12 '15 at 08:56
@RohanKumar, well - he **is** getting a result back, and using jsonp .... So no, has nothing to do with Same-origin policy. — davidkonrad, Feb 12 '15 at 08:57
DataTables warning: table id=example - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1 — Gikar, Feb 12 '15 at 09:22
@Quentin - eehh, what is correct JSONP data then? How does JSONP differ from other AJAX sources? — davidkonrad, Feb 14 '15 at 00:22
http://stackoverflow.com/questions/2067472/what-is-jsonp-all-about — Quentin, Feb 14 '15 at 15:01

V31 · Accepted Answer · 2015-02-12T09:07:11.337

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 '15 at 09:07

answered Feb 12 '15 at 08:59

V31

7,626
3
26
44

If i remove jsonp, i am getting Same origin policy error – Gikar Feb 12 '15 at 09:05
@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 – V31 Feb 12 '15 at 09:07
+1. Good spot. I also think this is the correct answer. @GirishMahindrakar, you have simply malformed initialization options :) – davidkonrad Feb 14 '15 at 00:28

JSON error on using jquery datatable

1 Answers1

Linked