Call a write REST operation
epm_rest_writeCalls one PUT, POST or DELETE operation of the Oracle EPM REST API that is not a job, by catalog id (see list_rest_operations): add a member, set or delete a substitution variable, import or clear a data slice. Only write operations are reachable here. Change sets are the safer option for member edits and production substitution variables. Selective artifact exports use exportCategoriesArtifactsV2 with snapshotName and categories containing categoryName and explicit selectedArtifacts from current Oracle inventory. Folder paths end with /. An omitted selection exports the whole category. Saved snapshots and repeat exports can miss new forms; compare current inventory with the exported entries. Use it for other changes the dedicated tools lack. Newly reviewed operations require a preview first, then confirm: true on the same arguments. Oracle's reference: https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/prest/ For a write, I require a preview first, then confirm: true and its confirmationToken. The token lasts ten minutes and works once.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"operationId": "<operationId>"
},
"name": "epm_rest_write"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| body | No | Request body as Oracle documents it for the operation | |
| query | No | Documented query parameters. | |
| params | No | Path parameters by placeholder name, e.g. { cube: "Plan1", name: "CurrMonth" }. app is filled from the application argument and must not be passed here. | |
| confirm | No | Set true after the user has approved the previewed change | |
| content | No | File content as UTF-8 text or canonical base64. At most 10 MiB after decoding. | |
| encoding | No | How content is encoded. | text |
| connection | No | Connection id or label from list_connections. Defaults to the user's default connection. | |
| application | No | Application name. Defaults to the connection's application. | |
| operationId | Yes | Catalog id of a write operation, e.g. addMember, setSubstitutionVariable, deleteSubstitutionVariable | |
| productionPod | No | Exact pod from the second security approval. | |
| confirmationToken | No | Single-use token from this exact preview. Send it with confirm: true after the user approves. It expires after ten minutes. | |
| productionApprovalId | No | Receipt from the second security approval. |