Pivot Grid Datasource, can JSON be used?

[Gedalya]

I'm struggling to get a Pivot Grid to populate. The demo works fine locally; however the datasource for it is XML from the datacube/dll. I have been using other widgets successfully with data delivered as JSON; is it possible to use JSON for the Pivot Grid? Are there any examples of this or even other examples of a Pivot Grid aside from the demo? Thanks in advance. 

[Georgi Denchev]

Hello, Gedalya,

Yes, it is possible to bind the PivotGrid to JSON data.

You can check the Local Binding demo which uses a JSON file:

https://demos.telerik.com/kendo-ui/pivotgrid/local-flat-data-binding

The file can be viewed here:

https://demos.telerik.com/kendo-ui/content/shared/js/products.js  

The rest of the configuration would be the same as any other widget. If we take the Remote Data Binding demo as an example, you need to simply change the dataSource type to "json" and configure the Read endpoint to return the data in JSON format(as shown above).

Best Regards,
Georgi Denchev
Progress Telerik

[cirol]

Hi George, i finally manage to separate the action that render the grid/pivot from the action that "loads" those components (via datasource). That action was the same in the original architecture, so i change that

Thanks for your help!

[Gedalya]

Thanks George! This was what I needed!