Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Previous sectionNext section

POST /Info/Pivots

Returns information about the pivot tables available in the Caché namespace that you access via this REST call.

URL Parameters

None.

Request Body Details

This service 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

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"}
         ...]
      }
}
Copy code to clipboard

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 the discussion at the start of this reference.