How to read information from deeply nested objects in Datatables?

Question

I have json in this format:

[
    {"aaa":"aaa"},
    {"Columns":[
        [{"bbb":"bbbb"}, {"name":"name1"}, {"gender":"gender1"}],
        [{"bbb":"bbbb"}, {"name":"name2"}, {"gender":"gender2"}],
    ]}
]

I tried:

$(document).ready(function() {
    $('#example').DataTable( {
        "ajax": "data/file.txt",
        "columns": [
            { "data": "Columns.0.name" },
            { "data": "Columns.0.gender" },
        ]
    } );
} );

but it gave me an error: Uncaught TypeError: Cannot read property 'length' of undefined How should I read name and gender? Thanks.

Gyrocode.com · Accepted Answer · 2016-09-01 03:14:44Z

1

Use the code below:

var table = $('#example').DataTable({
    ajax: {
       url: 'https://api.myjson.com/bins/2p254',
       dataSrc: '1.Columns'
    },
    columns: [
        { "data": '0.name' },
        { "data": '0.gender' }
    ]        
});

See this jsFiddle for code and demonstration.

answered Sep 1, 2016 at 3:14

Gyrocode.com

59k16 gold badges157 silver badges192 bronze badges

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

1 Comment

Harrison Over a year ago

Thanks, that works, but I got the json wrong in the post. I have updated my post. Could you please have a look. Thanks.

Collectives™ on Stack Overflow

How to read information from deeply nested objects in Datatables?

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