Datatables.net error on Ajax load

Question

I am working on a simple ajax example in datatables and it is not working and I am at a loss to explain it. I have a simple table as follows:

<table id="tblAddresses">
  <thead>
    <tr>
        <th>Street Address</th>
        <th>City</th>
        <th>State</th>
        <th>Zip Code</th>
    </tr>
 </thead>
 <tfoot>
    <tr>
        <th>Street Address</th>
        <th>City</th>
        <th>State</th>
        <th>Zip Code</th>
        </tr>
 </tfoot>
</table>

I have a json data source with data that looks like this (I prettied it up a bit for display here but the file is one long line with no line breaks).

{"data":[{"street":"19 Brook Avenue","city":"PASSAIC","state":"NJ","postcode":"07055"},
{"street":"27 Brook Avenue","city":"PASSAIC","state":"NJ","postcode":"07055"},
{"street":"31 Brook Avenue","city":"PASSAIC","state":"NJ","postcode":"07055"},
{"street":"35 Brook Avenue","city":"PASSAIC","state":"NJ","postcode":"07055"},
{"street":"39 Brook Avenue","city":"PASSAIC","state":"NJ","postcode":"07055"},
{"street":"49 Brook Avenue","city":"PASSAIC","state":"NJ","postcode":"07055"}]}

Finally, I load it in my document ready function:

<script type="text/javascript">
    $(document).ready(function(){
        $("#tblAddresses").DataTable({
            "ajax" : {
                "url" : "/json/07055.json",
                "columns" : [{"data":"street"},
                             {"data":"city"},
                             {"data":"state"},
                             {"data":"postcode"}]
            }
        });
    });
</script>

When I load the page, I see the ajax call. I can see the data accepted by the browser but DataTables is giving me an error:

DataTables warning: table id=tblAddresses - Requested unknown parameter '0' for row 0, column 0.

I have worked with ajax many times before albeit never loading from a static data file. I can't find the error in the JSON or Javascript.

Basanta Matia · Accepted Answer · 2017-07-07 12:44:00Z

2

You are binding data in wrong way. You need to bind columns after ajax method, like bellow,

$("#tblAddresses").DataTable({
        "ajax" : {
            "url" : "/json/07055.json",
            "type": "Get"
        }, //Here end of ajax method. Now you can bind the columns
         "columns" : [{"data":"street"},
                      {"data":"city"},
                      {"data":"state"},
                      {"data":"postcode"}]
        });

Hope it helps!

edited Jul 7, 2017 at 12:44

answered Jul 7, 2017 at 12:33

Basanta Matia

1,5904 gold badges15 silver badges29 bronze badges

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

1 Comment

Menachem Bazian Over a year ago

I KNEW it was something stupid but I couldn't see it! THANKS!

Collectives™ on Stack Overflow

Datatables.net error on Ajax load

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related