c# - 数据加载错误 - 由于数据类型无效，无法处理数据 Expecting : array Received: string

Question

我是制表符的新手，我想知道为什么这不起作用我的数据响应是这样的

[{"UserId":2,"Name":"John Doe","WorkingMinutes":0,"WorkingHours":"4:37","Date":"2018-05-15T08:35:20"},
{"UserId":14,"Name":"John Doe","WorkingMinutes":0,"WorkingHours":"0:47","Date":"2018-05-15T08:36:10"},
{"UserId":8,"Name":"John Doe","WorkingMinutes":0,"WorkingHours":"1:20","Date":"2018-05-15T08:37:47"},
{"UserId":16,"Name":"John Doe","WorkingMinutes":0,"WorkingHours":"2:55 (Nuk ka Deklaruar Pauze)","Date":"2018-05-15T08:37:52"},
{"UserId":11,"Name":"John Doe","WorkingMinutes":0,"WorkingHours":"2:54 (Nuk ka Deklaruar Pauze)","Date":"2018-05-15T08:38:03"},
{"UserId":1,"Name":"John Doe","WorkingMinutes":0,"WorkingHours":"2:38 (Nuk ka Deklaruar Pauze)","Date":"2018-05-15T08:49:23"}]

(为了保护隐私，名字都一样)

这是我的javascript

      <script type="text/javascript">
var table = new Tabulator("#MyTable", {
    ajaxURL: "@Url.Action("WorkingHours", "Dashboard")",
    height: "292px",
    layout: "fitColumns",
    pagination: "local",
    paginationSize: 20,
    movableColumns: true,
    columns: [
        { title: "UserId", field: "Id", formatter: "star", align: "center", width: 100 },
        { title: "Name", field: "name", width: 200 },
        { title: "Working Minutes", field: "progress", sorter: "number" },
        { title: "Working Hours", field: "progress" , sorter : "number" },
        { title: "Date", field: "dob", align: "center", sorter: "date" },
    ],
});

我检查了控制台和响应，它是这样说的:数据加载错误 - 由于数据类型无效，无法处理数据期望:数组接收:字符串然后是问题中的数据。是的，我的方法返回一个字符串，但它是 json。

Answer 1

您返回的数据采用未分页表格

所需的格式

对于分页数据，它需要以下格式:

{
    "last_page":15, //the total number of available pages (this value must be greater than 0)
    "data":[ // an array of row data objects
        {id:1, name:"bob", age:"23"}, //example row data object
    ]
}

有关如何使用远程分页的完整文档可以在 Tabulator Website 上找到