/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
-
Request Method:
GET
-
Request URL:
https://localhost/api/deepsee/v3/Data/GetPivot/SampleFolder%2FSamplePivot.pivot
For comments on the possible forms of the URL, see Introduction to the Business Intelligence REST API.
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": []
}
}
