EPM REST API Export Data Slice Example

exportDataSlice.json

{
   "exportPlanningData": false,
   "gridDefinition": {
      "suppressMissingBlocks": true,
      "pov": {
         "dimensions": [
            "Movement",
            "Years",
            "Period",
            "Data Source",
            "Scenario",
            "Entity",
            "View",
            "Intercompany",
            "Multi-GAAP",
            "Product"
         ],
         "members": [
            [
               "FCCS_Mvmts_Subtotal"
            ],
	         [
               "FY18"
            ],
            [
               "YearTotal"
            ],
            [
               "FCCS_TotalInputAndAdjusted"
            ],
            [
               "Actual"
            ],
            [
               "C_100"
            ],
            [
               "FCCS_Periodic"
            ],
            [
               "FCCS_Intercompany Top"
            ],
            [
               "FCCS_IFRS"
            ],
            [
               "Total Product"
            ]
         ]
      },
      "columns": [
         {
            "dimensions": [
               "Consolidation",
               "Currency"
            ],
            "members": [
               [
                  "FCCS_Entity Total"
               ],
               [
                  "Entity Currency"
               ]
            ]
         }
      ],
      "rows": [
         {
            "dimensions": [
               "Account"
            ],
            "members": [
               [
                  "FCCS_Total Assets"
               ]
            ]
         }
      ]
   }
}