Datatables Json数组作为数据源

Question

我不知道我做错了什么，我有一个非常简单的JSON对象:

[{"siteName":"Site 1","issueType":"Scada programming Defect","issueSeverity":"Critical","issueDate":"21/10/2021","issueSource":"Customer Feedback","problemSummary":"Test Probelm S1","reportedBy":"[e-mail]","assignedTo":"[e-mail]","sitePic":"Automation Team","picEmail":"Testing","customerName":"Test Customer","problemDetail":"Problem Detail2","status":"OPEN","tickettime":"2021-10-23T14:45:18.016Z","ticketid":"BBP-000001"}]

我已经映射到最简单的Datatable配置:

<table id="data-table" class="table table-striped  table-bordered" style="width:100%"></table>

和我试图填充表使用Jquery Javascript如下所示:

$(document).ready(function() {
console.log(dataArray);
$('#data-table').DataTable({
data: dataArray,
responsive: true,
columns: [
{ data: 'ticketid' },
{ data: 'siteName' },
{ data: 'status' },
{ data: 'issueType' }
],

fnInitComplete : function() {
$("#overlay").hide();
}

});
});

它总是给我错误:

数据表警告:表id=数据表-请求的未知参数'ticketid'为第0行，第0列。有关此错误的详细信息，请参阅http://datatables.net/tn/4

Answer 1

问题是变量dataArray作为字符串返回，简单地解析为JSON就可以了。

希望对别人有所帮助。