Initialize

[POST] /Api/OlapChart/Initialize

It fetches the OLAP data required to initialize the PivotChart from server-end.

URL parameters

Parameter Description
action It holds the current action name as string
customObject It contains the custom object passed from client side

Response information

Code: 200

Content-Type: application/json;

Response: serialized JSON string

Code example

  • c#
  • public Dictionary<string, object> Initialize(Dictionary<string, object> jsonResult)
    {
        OlapDataManager DataManager = new OlapDataManager(connectionString);
        DataManager.SetCurrentReport(CreateOlapReport());
        return htmlHelper.GetJsonData(jsonResult["action"].ToString(), DataManager);
    }

    Drill

    [POST] /Api/OlapChart/Drill

    It fetches the drilled OLAP data required to render the PivotChart control from server-end.

    URL parameters

    Parameter Description
    action It holds the current action name as string
    drilledSeries It contains the name of the drilled member
    olapReport It contains the current report as compressed string
    customObject It contains the custom object passed from client side

    Response information

    Code: 200

    Content-Type: application/json;

    Response: serialized JSON string

    Code example

  • c#
  • public Dictionary<string, object> Drill(Dictionary<string, object> jsonResult)
    {
        OlapDataManager DataManager = new OlapDataManager(connectionString);
        DataManager.SetCurrentReport(Syncfusion.JavaScript.Olap.Utils.DeserializeOlapReport(jsonResult["olapReport"].ToString()));
        return htmlHelper.GetJsonData(jsonResult["action"].ToString(), DataManager, jsonResult["drilledSeries"].ToString());
    }

    Export

    [POST] /Api/OlapChart/Export

    It exports the PivotChart control at the instant to the specified format.

    URL parameters

    Parameter Description
    chartData It contains the information required to export the control

    Response information

    Code: 200

    Content-Type: application/json

    Response: file

    Code example

  • c#
  • public void Export()
    {
        string args = HttpContext.Current.Request.Form.GetValues(0)[0];
        string fileName = "Sample";
        htmlHelper.ExportPivotChart(args, fileName, System.Web.HttpContext.Current.Response);
    }

    ExcelExport

    [POST] /Api/OlapChart/ExcelExport

    It exports the PivotChart control at the instant to an Excel document.

    URL parameters

    Parameter Description
    chartData It contains the information required to export the control to an Excel sheet

    Response information

    Code: 200

    Content-Type: application/json

    Response: Excel document

    Code example

  • c#
  • public void ExcelExport()
    {
        PivotChartExcelExport pivotChartExcelExport = new PivotChartExcelExport();
        string args = HttpContext.Current.Request.Form.GetValues(0)[0];
        Dictionary<string, string> chartParams = serializer.Deserialize<Dictionary<string, string>>(args);
        pivotChartExcelExport.ExportToExcel(chartParams);
    }

    WordExport

    [POST] /Api/OlapChart/WordExport

    It exports the PivotChart control at the instant to a Word document.

    URL parameters

    Parameter Description
    chartData It contains the information required to export the control to a Word document

    Response information

    Code: 200

    Content-Type: application/json

    Response: Word document

    Code example

  • c#
  • public void WordExport()
    {
        PivotChartWordExport pivotChartWordExport = new PivotChartWordExport();
        string args = HttpContext.Current.Request.Form.GetValues(0)[0];
        Dictionary<string, string> chartParams = serializer.Deserialize<Dictionary<string, string>>(args);
        pivotChartWordExport.ExportToWord(chartParams);
    }

    PdfExport

    [POST] /Api/OlapChart/PdfExport

    It exports the PivotChart control at the instant to a PDF document.

    URL parameters

    Parameter Description
    chartData It contains the information required to export the control to a PDF document

    Response information

    Code: 200

    Content-Type: application/json

    Response: PDF document

    Code example

  • c#
  • public void PdfExport()
    {
        PivotChartPDFExport pivotChartPDFExport = new PivotChartPDFExport();
        string args = HttpContext.Current.Request.Form.GetValues(0)[0];
        Dictionary<string, string> chartParams = serializer.Deserialize<Dictionary<string, string>>(args);
        pivotChartPDFExport.ExportToPDF(chartParams);
    }

    ImageExport

    [POST] /Api/OlapChart/ImageExport

    It exports the PivotChart control at the instant as an Image in specified format.

    URL parameters

    Parameter Description
    chartData It contains the information required to export the control to an image file

    Response information

    Code: 200

    Content-Type: application/json

    Response: Image file

    Code example

  • c#
  • public void ImageExport()
    {
        PivotChartImageExport pivotChartImageExport = new PivotChartImageExport();
        string args = HttpContext.Current.Request.Form.GetValues(0)[0];
        Dictionary<string, string> chartParams = serializer.Deserialize<Dictionary<string, string>>(args);
        pivotChartImageExport.ExportToImage(chartParams);
    }