json issues with datatables

Question

I have the json coming as this

"{\"data\":[{\"Youtube\":\"CD7JYg1inF8\",\"ID\":1,\"Title\":\"New Zealand\",\"Description\":\"raceway.\}]}"

error i am getting is this

DataTables warning: table id=ivideos - Requested unknown parameter 'id' for row 0, column 0. For more information about this error, please see http://datatables.net/tn/4

i have the call code like thhis:

$('##ivideos').DataTable({
         'deferRender': true,
         'ajax': {
            'url': 'a.cfc?method=getvideos',
            "dataSrc": function (d) {
                return d
            }
         },
         'columns': [            
            { 'data': 'id' },
            { 'data': 'title' },
            { 'data': 'description' },
            { 'data': 'youtube' }
         ]
      }); //dataTable

using datatables version 1.10 onwards

Looks like it is `ID` in the source array,, not `id` .... – WillardSolutions Dec 28 '19 at 19:35 — WillardSolutions, Dec 28 '19 at 19:35

score 0 · Answer 1 · answered Dec 28 '19 at 19:39

0

I don't have much experience with datatables, but it appears that column names are case sensitive as is usually the case with libraries, etc. that look for JSON properties. Fix the casing and try your method again. See this answer for more details:

answered Dec 28 '19 at 19:39

djsoteric

188
1
10

i tried with the casing too, but i am getting same error – CDN Dec 30 '19 at 17:14

json issues with datatables

1 Answers1