Example of Remote Data in ASP.NET MVC Pivot Table Control

This sample demonstrates basic rendering of the pivot table bound to JSON or CSV data pulled from a remote server.

DEMO

SOURCE

The pivot table supports JSON and CSV data source. The dataSourceSettings->dataSource property can be assigned with the result of DataManager to bind remote data.

The DataManager, which will act as an interface between the service endpoint and the pivot table, will require the below minimal information to interact with service endpoint properly.

DataManager->url - Defines the service endpoint to fetch data.
DataManager->adaptor - Defines the adaptor option. Here, WebApiAdaptor is used for remote binding.

In this demo, with respect to JSON remote data, is bound by assigning service data as an instance of DataManager to the dataSourceSettings->dataSource property. But for CSV, the service URL is directly set to url for remote data consumption.