JQuery DataTables & Web API 2 OData column nested array data source

Question

When data is returned from a Web API 2.2 OData v4 controller with an OData metadata wrapper, I'm having trouble properly sourcing columns in the enumerated data set in JQuery DataTables. No error, simply "No data available in table" after initialization.

AJAX response:

{
  "odata.metadata":"http://localhost/blahblahblah/$metadata#SearchData","value":[
    {"ShipmentKey":"12345"},
    {"ShipmentKey":"12346"},
    {"ShipmentKey":"12347"},
    {"ShipmentKey":"12348"},
  ],"odata.nextLink":"http://localhost/blahblahblah/SearchData?$skip=100"
}

Datatables column intialiation:

"columns": [
                { "data": "value.ShipmentKey" },
            ]

Also tried:

"columns": [
                    { "data": "value..ShipmentKey" },
                ]

andrewbadera · Accepted Answer · 2015-02-09 15:40:30Z

1

Ah I see, I needed to use dataSrc to specify "value" in my ajax setup.

$('#blah').dataTable({
    "ajax": {
        "url": 'http://localhost/blahblahblah/SearchData',
        "dataSrc": 'value'
    },
    "columns": [
        { "data": "ShipmentNumber" },

answered Feb 9, 2015 at 15:40

andrewbadera

1,3629 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

JQuery DataTables & Web API 2 OData column nested array data source

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related