时间戳

首页 > 解决方案 > JSON数据有什么问题？

javascript - JSON数据有什么问题？

问题描述

"gsdata" :[{"id":7,"SCRIP":"ASIANPAINT","LTP":3341,"OHL":"BUY","ORB15":"BREAKOUT","ORB30":"NT","PRB":"NA","CAMARILLA":"Buy","ALERT":3327.4,"PROFIT":null,"createdAt":"2021-09-09T15:31:02.000Z","updatedAt":"2021-09-10T16:34:01.000Z"},{"id":10,"SCRIP":"BAJAJ-AUTO","LTP":3699.4,"OHL":"NA","ORB15":"BREAKDOWN","ORB30":"BREAKDOWN","PRB":"BREAKDOWN","CAMARILLA":"Buy","ALERT":3699.4,"PROFIT":null,"createdAt":"2021-09-09T15:31:02.000Z","updatedAt":"2021-09-10T16:34:01.000Z"},{"id":15,"SCRIP":"BERGEPAINT","LTP":833.65,"OHL":"NA","ORB15":"NA","ORB30":"NT","PRB":"NA","CAMARILLA":"Buy","ALERT":833.65,"PROFIT":null,"createdAt":"2021-09-09T15:31:02.000Z","updatedAt":"2021-09-10T16:34:01.000Z"},{"id":18,"SCRIP":"BIOCON","LTP":352.3,"OHL":"NA","ORB15":"BREAKDOWN","ORB30":"BREAKDOWN","PRB":"BREAKDOWN","CAMARILLA":"Short","ALERT":352.3,"PROFIT":null,"createdAt":"2021-09-09T15:31:02.000Z","updatedAt":"2021-09-10T16:34:01.000Z"},{"id":23,"SCRIP":"CDSL","LTP":1321.45,"OHL":"NA","ORB15":"NA","ORB30":"NT","PRB":"BREAKUP","CAMARILLA":"Buy","ALERT":null,"PROFIT":null,"createdAt":"2021-09-09T15:31:02.000Z","updatedAt":"2021-09-10T16:34:01.000Z"}]

这是一个 JSON 数组数据。我正在使用 ajax 填充此数据。但低于警告信息

DataTables warning: table id=scrip-data - Invalid JSON response

有人可以指出我做错了什么。下面是我加载数据表的 ajax 片段。

var data1 = JSON.parse('<%- gsdata %>') ; //ejs template to read value of data send from controller    
var table = $('#scrip-data').DataTable( {
    "searching": false,
    paging: false,
    info: false,
    "processing": true,
    //"serverSide": true,
        ajax: {
            url: "dashboard",
            //type: "GET",
            dataSrc: "",
        },
        data: data1,
        //dataType: 'json',
        columns: [
            {data: "SCRIP"},
            {data: "LTP"},
            {data: "CAMARILLA"},
            {data: "ALERT"},
            {data: "PROFIT"},
            {data: "updatedAt"},
        ],
        //columnDefs: [{ }],
    } );

    setInterval( function () {
            table.ajax.reload();
        }, 20000 );

标签： javascriptnode.jsjsonajaxejs

解决方案

Just add the curly brackets around the json string.

{
    "gsdata": [{
        "id": 7,
        "SCRIP": "ASIANPAINT",
        "LTP": 3341,
        "OHL": "BUY",
        "ORB15": "BREAKOUT",
        "ORB30": "NT",
        "PRB": "NA",
        "CAMARILLA": "Buy",
        "ALERT": 3327.4,
        "PROFIT": null,
        "createdAt": "2021-09-09T15:31:02.000Z",
        "updatedAt": "2021-09-10T16:34:01.000Z"
    }, {
        "id": 10,
        "SCRIP": "BAJAJ-AUTO",
        "LTP": 3699.4,
        "OHL": "NA",
        "ORB15": "BREAKDOWN",
        "ORB30": "BREAKDOWN",
        "PRB": "BREAKDOWN",
        "CAMARILLA": "Buy",
        "ALERT": 3699.4,
        "PROFIT": null,
        "createdAt": "2021-09-09T15:31:02.000Z",
        "updatedAt": "2021-09-10T16:34:01.000Z"
    }, {
        "id": 15,
        "SCRIP": "BERGEPAINT",
        "LTP": 833.65,
        "OHL": "NA",
        "ORB15": "NA",
        "ORB30": "NT",
        "PRB": "NA",
        "CAMARILLA": "Buy",
        "ALERT": 833.65,
        "PROFIT": null,
        "createdAt": "2021-09-09T15:31:02.000Z",
        "updatedAt": "2021-09-10T16:34:01.000Z"
    }, {
        "id": 18,
        "SCRIP": "BIOCON",
        "LTP": 352.3,
        "OHL": "NA",
        "ORB15": "BREAKDOWN",
        "ORB30": "BREAKDOWN",
        "PRB": "BREAKDOWN",
        "CAMARILLA": "Short",
        "ALERT": 352.3,
        "PROFIT": null,
        "createdAt": "2021-09-09T15:31:02.000Z",
        "updatedAt": "2021-09-10T16:34:01.000Z"
    }, {
        "id": 23,
        "SCRIP": "CDSL",
        "LTP": 1321.45,
        "OHL": "NA",
        "ORB15": "NA",
        "ORB30": "NT",
        "PRB": "BREAKUP",
        "CAMARILLA": "Buy",
        "ALERT": null,
        "PROFIT": null,
        "createdAt": "2021-09-09T15:31:02.000Z",
        "updatedAt": "2021-09-10T16:34:01.000Z"
    }]
}

推荐阅读