Example of Remote Data in Javascript Pivot Table Control

Remote Data

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

More Details...


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. More information on the Essential JS2 Pivot Table can be found in these JSON & CSV documentation section.