Grid with Json Variable and Schema

[Richard]

Hi All, 

   I have a js variable JSON_DATA that contains the return result from a .py api.  It has a schema 'xyz' and 5 columns (a,b,c,d,e).  I've tried to setup the the schema and datasource several different ways and I can't seem to get it to bind the data.  Can someone shed some light on this for me?  See below:

This is where I'm at now, I removed schema to see if I could get something back but I'm stuck: 

 

 \$(document).ready(function() {
                     \$("#grid").kendoGrid({
                        dataSource: {
                            data: $JSON_DATA },
                        height: 550,
                        scrollable: true,
                        sortable: true,
                        filterable: true,
                        pageable: {
                            input: true,
                            numeric: false
                        },
                        columns: [
                          { field: 'productType', title: 'CSS-WX Product Type', width: '230px'}, 
                            { field: 'serviceType', title: 'Web Service Type', width: '100px'},
                            { field: 'average', title: 'Average', width: '130px' },
                            { field: 'target', title: 'Target', width: '130px' },
                            { field: 'iterations', title: 'Iterations', width: '130px' }
                        ]
                    });
                });

[Martin]

Hello Richard,

Thank you for the provided code snippet. I tested it in this Dojo example with some dummy data, and it seems to be working as expected. Could you please review the example and if it does not completely replicate your scenario, modify it to do so? I will then be able to test it and discover what is causing the issue.

Looking forward to your reply.

Regards,
Martin
Progress Telerik

[Richard]

Hi Martin, 

  Thank you for the reply, the problem is I need to incorporate the schema.  It doesn't work correctly when I do so.  That's where I'm stuck.  ex data: 

 

{ "mySchemaXYZ": [ {  productType: "Product 1", serviceType:"Service 1", average: "Average 1", target: "Target 1", iterations: "Interation 1" }, { productType: "Product 2", serviceType:"Service 2", average: "Average 2", target: "Target 2", iterations: "Interation 2" } ]}

 

[Martin]

Hello Richard,

On my side the provided example is working as expected without a schema. Still, if you need to add one, you need to do that in the DataSource definition and not in the variable containing the data. Here is a small example for reference.

Let me know if that works for you.

Regards,
Martin
Progress Telerik