Transform json data for DataTables

Question

I have data which looks like this.

{
  "data": [
  { 
   "c1":  "datapt00",
   "size": 40
  },
  { 
   "c1":  "datapt001",
   "size": 80
  }
  ]
}

In HTML I am doing,

$(document).ready(function) { 
$('#example').DataTAble ( { 
"ajax": {
"url": "/data",
}} ); });

Is ther ean easy way to manipulate my data so its Datatable compliant?

annoyingmouse · Accepted Answer · 2017-12-20 16:32:27Z

1

This should do it:

var jsonData = {
  "data": [
  { 
   "c1":  "datapt00",
   "size": 40
  },
  { 
   "c1":  "datapt001",
   "size": 80
  }
  ]
};
$('#example').DataTable({
    "ajax": {
        "type": 'POST',
        "dataType": 'json',
        "url": '/echo/json/',
        "data": {
            "json": JSON.stringify(jsonData)
        },
        "dataSrc": "data"
    },
    "columns": [{
        "data": "c1"
    }, {
        "data": "size"
    }]
});

Working JSFiddle here: https://jsfiddle.net/annoyingmouse/70d01vo0/

answered Dec 20, 2017 at 16:32

annoyingmouse

5,6991 gold badge31 silver badges48 bronze badges

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

2 Comments

NinjaGaiden Over a year ago

what happens if I am not using jsonData. I am getting my data from "url"

annoyingmouse Over a year ago

Ah, bless you! There's no way of using AJAX on JSFiddle so this is the mechanism for getting json on JSFiddle. I think you'll probably be wanting to use something along the lines of "ajax": {"url": "/data", "dataSrc": "data"}. Hope that that makes sense and helps.

Collectives™ on Stack Overflow

Transform json data for DataTables

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related