Export Data

Exports application data into a file using the export data settings, including file name, specified in a Planning job of type export data. The file containing the exported data is stored in the Planning repository.

You can also override some of the parameters of the job definition while executing this job with a REST API.

Request

Supported Media Types: application/json

Parameters

The following table summarizes the client request specific to this job. For parameters that are generic to all jobs, see Execute a Job.

Table 5-14 Export Data

Name Description Required Default
jobType Export Data or EXPORT_DATA (both parameters are supported) Yes None
jobName

The name of a job of type export data defined in the Planning application.

Example: dailydataexport

Yes None
exportFileName

You can specify a file name for the exported data. Data is exported as a ZIP file only. The exported fie is stored in the Planning repository.

The value must use JSON syntax.

No The file name for the exported data will be the same as Job Name.
delimiter

You can use this parameter to override the delimiter parameter.

Allowed value is comma or tab.

No Delimiter used in the job definition.

exportSmartListAs

You can use this parameter to override how Smart Lists are exported.

Allowed value is label or name.

No Smart Lists parameter of the job definition.

includeDynamicMembers

You can use this parameter to include or exclude dynamic members.

Allowed value is true or false.

No Dynamic Members parameter of the job definition.
cube You can use this parameter to run the export data job on a different cube. No Cube parameter of the job definition.
rowMembers You can override the row members defined in the job definition.

Example: "Name,Price,Discount %"

No Row parameter defined in the Slice section of the job definition.
columnMembers You can override the column members defined in the job definition.

Example: "Name,Price,Discount %"

No Column parameter defined in the Slice section of the job definition.
povMembers You can override the POV members defined in the job definition.

Example: "Name,Price,Discount %"

No Point of View parameter defined in the Slice section of the job definition.

Sample Payloads

Example 1: Executes the export data job “ExportJobDaily” and overrides the exportFileName parameter.

{"jobType":"EXPORT_DATA","jobName":"ExportJobDaily",
     "parameters":{
          "exportFileName":"myExportfile.zip"
          }
}

Example 2: Executes the export data job "ExportJobDaily" and overrides the delimiter, exportSmartListAs, and includeDynamicMembers parameters.

{"jobType":"EXPORT_DATA","jobName":"ExportJobDaily",
"parameters":{
     "delimiter":"tab",
     "exportSmartListAs":"name",
     "includeDynamicMembers":"true"
     }

Example 3: Executes the export data job "ExportJobDaily" and overrides the cube parameter only. This job will now execute for the cube Vis1ASO.

{"jobType":"EXPORT_DATA","jobName":"ExportJobDaily",
"parameters":{
     "cube":"Vis1ASO
     }
}

Example 4: Executes the export data job "ExportJobDaily" and overrides the cube name along with the rowMembers, columnMembers, and povMembers parameters. This job will now execute for the cube Vis1ASO.

{"jobType":"EXPORT_DATA","jobName":"ExportJobDaily",
"parameters":{
     "cube":"Vis1ASO",
     "rowMembers":"Current,Variance,Actual,Scenario",
     "columnMembers":"Statistics,Account",
     "povMembers":"Period,Year,Version,Entity,Product,Channel"
     }
}