I am using Datatables.net to display results of an oracle query. Query works fine and I appear to be getting the right JSON output, but DataTables complains that my JSON is invalid. I have this javascript:
ajax: {
url: "php/requests.php",
type: "POST",
dataSrc: ""
},
paging: false,
scrollY: '60vh',
scrollCollapse: true,
// note: DataTables.render.number(thousandsSeparater,decimalSeparator,precision,[prefix ie '$'],[suffix])
columns: [
{ data: "Request_Id" },
{ data: "Description" },
{ data: "Requestor" },
{ data: "Request_Date" },
{ data: "Processed", className: "dt-right", render: DataTable.render.number(',', '.', 0) },
{ data: "Processed_Rate", className: "dt-right", render: DataTable.render.number(',', '.', 1) },
{ data: "Pending", className: "dt-right", render: DataTable.render.number(',', '.', 0) },
{ data: "Succeeded", className: "dt-right", render: DataTable.render.number(',', '.', 0) },
{ data: "Success_Rate", className: "dt-right", render: DataTable.render.number(',', '.', 1) }
{ data: "Failed", className: "dt-right", render: DataTable.render.number(',', '.', 0) },
],
order: [0, 'asc']
requests.php gets called as expected when the page loads and this json string is output:
[
{
"Request_Id": "10082",
"Description": "test",
"Requestor": "[email protected]",
"Request_Date": "27-AUG-25",
"Processed": 354,
"Processed_Rate": 69.00584795321637,
"Pending": 159,
"Succeeded": 354,
"Success_Rate": 100,
"Failed": 0
}
]
(as copied from Edge/developer tools/network/response )