I have a remote json datasource which comes in as follows:
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:
Any ideas?
[[
"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?