[Solved] Binding to JSON only containing list of values, not dictionary

[Darren]

I have a remote json datasource which comes in as follows:

[["Advantage", null, "2012-05-07T01:54:02.130000", "sqlsvrautosysjobs", "2012-05-07T01:54:02.130000", "sqlsvrautosysjobs", 1], ["ALDOP", null, "2012-05-07T01:54:02.130000", "sqlsvrautosysjobs", "2012-05-07T01:54:02.130000", "sqlsvrautosysjobs", 1]]

How can I bind my datasource to this?  I cannot change the datasource so I will need to use ordinal references or something like that.  I've tried the following with no luck:

$("#grid").kendoGrid({

    dataSource: {

        type: "json",

        transport: {

            read: {

                url: 'list',

                dataType: 'json',

                contentType: 'application/json'

            }

        },

        schema: {

            model: {

                fields: {

                    SourceSystem: { type: "string" },

                    ModifiedComment: { type: "string" },

                    CreatedDate: { type: "date" },

                    ModifiedDate: { type: "date" },

                    ModifiedUser: { type: "string" },

                    Version: { type: "number" }

                }

            }

        },

        pageSize: 10,

        serverPaging: true,

        serverFiltering: true,

        serverSorting: true

    },

    height: 250,

    filterable: true,

    sortable: true,

    pageable: true,

    columns: [{

            field:"SourceSystem",

            title: "Source"

        }, {

            field: "ModifiedComment",

            title: "Comment",

            filterable: false

        },

        "Version",

        {

            field: "CreatedDate",

            title: "Created Date",

            width: 100,

            format: "{0:MM/dd/yyyy}"

        }, {

            field: "ModifiedDate",

            title: "Modified Date",

            width: 100,

            format: "{0:MM/dd/yyyy}"

        }, {

            field: "ModifiedUser",

            title: "Modified By"

        }

    ]

});

Any ideas?

[Atanas Korchev]

Hi Darren,

You need to convert that data to a format which the DataSource can understand. Here is how: http://jsbin.com/ibatex/edit#javascript,html 

 The key is to use the parse method of the schema:

parse: function(raw) {
     var result = [];

     for (var i = 0; i < raw.length; i++) {
        result.push( {
            SourceSystem: raw[i][0],
            ModifiedComment: raw[i][1],
            CreatedDate: raw[i][2],
            ModifiedDate: raw[i][4],
            ModifiedUser: raw[i][5],
            Version: raw[i][6]
         });
    }

    return result;
},

Regards,
Atanas Korchev
the Telerik team

[Darren]

Hi Atanas,

That worked perfect; thanks for such a clear solution!