TypeError: data is undefined when using datatable plugin

Question

I'm trying to retrieve data from the server using DataTables.I can view the json response in the network section of my browser as well.But in the console it gives me TypeError: data is undefined. Nothing shows inside the table except column names and Processing.. label.

Here is my Json response:

{"userList":[{"age":23,"userId":123,"user_name":"Mike"},{"age":22,"userId":345,"user_name":"John"},{"age":23,"userId":123,"user_name":"Peter"}]}

json response img

Java Script:

$(document).ready(function () {
       $('#mytable').dataTable({
                    "processing": true,
                    "serverSide": true,
                    "ajax": "jsond",
                    "columns": [
                        {"userList": "userId"},
                        {"userList": "user_name"},
                        {"userList": "age"}
                    ]
                });
            });

Html:

<table id="mytable">
                <thead>
                    <tr>
                        <th>Id</th>
                        <th>Name</th>
                        <th>Age</th>

                    </tr>
                </thead>
                <tbody>
                    <tr>
                        <td></td>
                        <td></td>
                        <td></td>
                    </tr>
                </tbody>
                <tfoot>
                    <tr>
                        <th>Id</th>
                        <th>Name</th>
                        <th>Age</th>
                    </tr>
                </tfoot>
            </table>

Can somebody suggest me a way to get rid of this error please ....

Omidam81 · Accepted Answer · 2015-10-17 03:35:59Z

2

according to this page your data format is wrong.

Ajax sourced data

{ 
    "data":[{"age":23,"userId":123,"user_name":"Mike"},{"age":22,"userId":345,"user_name":"John"},{"age":23,"userId":123,"user_name":"Peter"}]
}

answered Oct 17, 2015 at 3:35

Omidam81

1,91712 silver badges21 bronze badges

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

1 Comment

Madushan Perera Over a year ago

Thanks. That was the mistake.:)

Collectives™ on Stack Overflow

TypeError: data is undefined when using datatable plugin

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related