Skip to main content

/Data/GetPivot/:pivotName

Retrieves the definition of the given pivot table.

Request Method

GET

URL Parameters

pivotName

Full name of the pivot table.

Request Body Details

The request body is ignored.

Example Request

Example Response

{
  "Info": {
    "Error": "",
    "PivotName": "SampleFolder/SamplePivot.pivot"
  },
  "Result": {
    "mdx": "",
    "sqlRestriction": "",
    "cellStyle": "",
    "columnHeaderStyle": "",
    "rowHeaderStyle": "",
    "cellWidth": "120",
    "cellHeight": "22",
    "rowLabelSpan": 1,
    "columnLabelSpan": 1,
    "showEmptyRows": 0,
    "showEmptyColumns": 0,
    "cubeName": "HOLEFOODS",
    "caption": "",
    "listing": "",
    "defaultListing": "",
    "listingRows": "",
    "showStatus": 1,
    "pageSize": "100",
    "colorScale": "",
    "rowTotals": 0,
    "showZebra": 0,
    "showRowCaption": 1,
    "columnTotals": 0,
    "columnTotalAgg": "sum",
    "rowTotalAgg": "sum",
    "rowTotalSource": "page",
    "measureLocation": "columns",
    "hideMeasures": "1",
    "autoExecute": 1,
    "previewMode": 0,
    "canDrillDown": 1,
    "dataSource": "automatic",
    "userMDX": "",
    "rowLevels": [
      {
        "spec": "[Discount].[H1].[Discount Type].Members",
        "key": "",
        "value": "",
        "text": "Discount Type",
        "enabled": 1,
        "headEnabled": 0,
        "headCount": "",
        "filterEnabled": 0,
        "filterExpression": "",
        "orderEnabled": 0,
        "orderExpression": "",
        "orderDirection": "BDESC",
        "aggEnabled": 0,
        "aggFunction": "",
        "levelCaption": "",
        "levelFormat": "",
        "levelType": "",
        "aggFunctionParm": "",
        "drillLevel": "0",
        "advanced": 0,
        "levelStyle": "",
        "levelHeaderStyle": "",
        "levelSummary": "",
        "suppress8020": 0,
        "drilldownSpec": "",
        "childLevels": []
      }
    ],
    "columnLevels": [
      {}
    ],
    "filters": [],
    "listingFilters": [],
    "drillLevels": [],
    "measures": [],
    "listingFields": [],
    "formatRules": [],
    "calculatedMembers": []
  }
}
FeedbackOpens in a new tab