Pass in JSON input to DataTables

Question

...
// result is a JSON data passed to this function from outside
var result = getMyJSON();
var input = "{aaData: ["+result+"],"+'aoColumns':[
    { 'sTitle': 'Title', 'mDataProp': 'title' }]}";

$(document).ready(function() {
    $('#example').dataTable(input);
});
</script>

<table id='example' class='example' border='1'>

I know that .dataTable() function expects initialization object as specified here: http://datatables.net/ref#aaData If inside the dataTable function I manually paste the JSON data - then it displays everything fine. How can I "prepare" and pass in as an initialization object to dataTables() function? Right now this is not working as it should.

Thanks

Michal · Accepted Answer · 2012-04-04 22:25:57Z

2

I am not sure why you are building your input var as a string - it is an object. Try this instead

var input = {
    "aaData" : [result],
    "aoColumns" : [{
        "sTitle" : "Title"
    }, {
        "mDataProp" : "title"
    }]
};

answered Apr 4, 2012 at 22:25

Michal

13.7k4 gold badges38 silver badges33 bronze badges

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

1 Comment

Sriram Over a year ago

What if I don't want to specify aoColumns attribute. I want to prepare my table's header with few conditions. So I cannot go with it. Will that allow to give a proper table?

Collectives™ on Stack Overflow

Pass in JSON input to 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