/Info/Pivots
Returns information about the pivot tables available in the InterSystems IRIS namespace that you access via this REST call.
Request Method
GET or POST
URL Parameters
None.
Request Body Details
This endpoint uses the following property of the request body:
BASECUBE
Optional. If specified, this property should equal the logical name of a cube. In this case, the server sends information only about pivot tables based on this cube.
Example Request
-
Request Method:
POST
-
Request URL:
https://localhost/api/deepsee/v3/Info/Pivots
For comments on the possible forms of the URL, see Introduction to the Business Intelligence REST API.
-
Request Body:
{"BASECUBE":"PATIENTS"}
Example Response
{
"Info": {
"Error":"",
"BaseCube":""
},
"Result": {
"Pivots": [
{"fullName":"Calculated Members\/Alternative Avg Allergy Count",
"name":"Alternative Avg Allergy Count",
"lastModified":"2016-11-14 11:22:08",
"itemType":"pivot"},
{"fullName":"Calculated Members\/Average Patient Count per Decade",
"name":"Average Patient Count per Decade",
"lastModified":"2016-11-14 11:22:08",
"itemType":"pivot"}
...]
}
}
In the response object, the Result property contains a property called Pivots, which contains an array of objects, one for each pivot table.
For information that applies to all response objects, see Notes on the Response Objects.
