Oracle Essbase

Oracle Essbase Scripts API

Manage calculation and MDX scripts

GitHub OpenAPI

Operations 5

GET /applications/{applicationName}/databases/{databaseName}/scripts Oracle Essbase List Scripts #
POST /applications/{applicationName}/databases/{databaseName}/scripts Oracle Essbase Create Script #
GET /applications/{applicationName}/databases/{databaseName}/scripts/{scriptName} Oracle Essbase Get Script #
PUT /applications/{applicationName}/databases/{databaseName}/scripts/{scriptName} Oracle Essbase Update Script #
DELETE /applications/{applicationName}/databases/{databaseName}/scripts/{scriptName} Oracle Essbase Delete Script #

Documentation

📖
Documentation
https://docs.oracle.com/en/database/other-databases/essbase/21/essrt/index.html
📖
Authentication
https://docs.oracle.com/en/database/other-databases/essbase/21/erest/op-rest-v1-sessions-post.html
📖
GettingStarted
https://docs.oracle.com/en/database/other-databases/essbase/21/essrt/api-essbase.html

Specifications

⚙
OpenAPI
https://artifacts.apis.io/oracle-essbase/openapi/oracle-essbase-scripts-api-openapi.yml

Schemas & Data

📊
JSONSchema
https://artifacts.apis.io/oracle-essbase/json-schema/oracle-essbase-application-schema.json
📊
JSONSchema
https://artifacts.apis.io/oracle-essbase/json-schema/oracle-essbase-database-schema.json
📊
JSONSchema
https://artifacts.apis.io/oracle-essbase/json-schema/oracle-essbase-job-schema.json
📊
JSONSchema
https://artifacts.apis.io/oracle-essbase/json-schema/oracle-essbase-user-schema.json
📊
JSONSchema
https://artifacts.apis.io/oracle-essbase/json-schema/oracle-essbase-session-schema.json
📊
JSONSchema
https://artifacts.apis.io/oracle-essbase/json-schema/oracle-essbase-dimension-schema.json
📊
JSONSchema
https://artifacts.apis.io/oracle-essbase/json-schema/oracle-essbase-connection-schema.json
📊
JSONSchema
https://artifacts.apis.io/oracle-essbase/json-schema/oracle-essbase-script-schema.json
📊
JSONSchema
https://artifacts.apis.io/oracle-essbase/json-schema/oracle-essbase-filter-schema.json

Other Resources

🔗
Reference
https://docs.oracle.com/en/database/other-databases/essbase/21/essrt/rest-endpoints.html
🔗
JSONLDContext
https://artifacts.apis.io/oracle-essbase/json-ld/oracle-essbase-context.jsonld

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API 
curl "https://apis.io/api/v1/apis/oracle-essbase:oracle-essbase-scripts-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

oracle-essbase-scripts-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: Oracle Essbase REST Scripts API
  description: RESTful API for managing and interacting with Oracle Essbase applications, databases, and performing analytical operations. Enables automation of Essbase resource management with endpoints for applications, databases, calculations, data loads, user management, sessions, jobs, files, scripts, filters, partitions, connections, datasources, dimensions, outline viewer, locks, scenarios, server properties, and more. All communication occurs over secured HTTP.
  version: 21.0.0
  contact:
    name: Oracle Support
    url: https://support.oracle.com
  license:
    name: Oracle Technology Network License
    url: https://www.oracle.com/legal/terms/
  x-provider: oracle-essbase
servers:
- url: https://{host}:{port}/essbase/rest/v1
  description: Oracle Essbase REST API server
  variables:
    host:
      default: localhost
      description: Essbase server hostname
    port:
      default: '9001'
      description: Essbase server port
security:
- basicAuth: []
- bearerAuth: []
tags:
- name: Scripts
  description: Manage calculation and MDX scripts
paths:
  /applications/{applicationName}/databases/{databaseName}/scripts:
    get:
      operationId: listScripts
      summary: Oracle Essbase List Scripts
      description: Returns a list of calculation and MDX scripts for the specified database.
      tags:
      - Scripts
      parameters:
      - $ref: '#/components/parameters/applicationName'
      - $ref: '#/components/parameters/databaseName'
      responses:
        '200':
          description: Script list returned successfully.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ScriptList'
        '400':
          description: Bad request.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
    post:
      operationId: createScript
      summary: Oracle Essbase Create Script
      description: Creates a new calculation or MDX script for the specified database.
      tags:
      - Scripts
      parameters:
      - $ref: '#/components/parameters/applicationName'
      - $ref: '#/components/parameters/databaseName'
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ScriptInput'
      responses:
        '200':
          description: Script created successfully.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Script'
        '400':
          description: Failed to create script.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
  /applications/{applicationName}/databases/{databaseName}/scripts/{scriptName}:
    get:
      operationId: getScript
      summary: Oracle Essbase Get Script
      description: Returns the content and details of the specified calculation or MDX script.
      tags:
      - Scripts
      parameters:
      - $ref: '#/components/parameters/applicationName'
      - $ref: '#/components/parameters/databaseName'
      - name: scriptName
        in: path
        required: true
        description: Script name.
        schema:
          type: string
      responses:
        '200':
          description: Script details returned successfully.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Script'
        '400':
          description: Bad request.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
    put:
      operationId: updateScript
      summary: Oracle Essbase Update Script
      description: Updates the content of an existing calculation or MDX script.
      tags:
      - Scripts
      parameters:
      - $ref: '#/components/parameters/applicationName'
      - $ref: '#/components/parameters/databaseName'
      - name: scriptName
        in: path
        required: true
        description: Script name.
        schema:
          type: string
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ScriptInput'
      responses:
        '200':
          description: Script updated successfully.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Script'
        '400':
          description: Failed to update script.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
    delete:
      operationId: deleteScript
      summary: Oracle Essbase Delete Script
      description: Deletes the specified calculation or MDX script from the database.
      tags:
      - Scripts
      parameters:
      - $ref: '#/components/parameters/applicationName'
      - $ref: '#/components/parameters/databaseName'
      - name: scriptName
        in: path
        required: true
        description: Script name.
        schema:
          type: string
      responses:
        '200':
          description: Script deleted successfully.
        '400':
          description: Failed to delete script.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
components:
  parameters:
    applicationName:
      name: applicationName
      in: path
      required: true
      description: Essbase application name.
      schema:
        type: string
    databaseName:
      name: databaseName
      in: path
      required: true
      description: Essbase database (cube) name.
      schema:
        type: string
  schemas:
    ScriptList:
      type: object
      description: List of scripts.
      properties:
        items:
          type: array
          items:
            $ref: '#/components/schemas/Script'
    Link:
      type: object
      description: HATEOAS navigation link.
      properties:
        rel:
          type: string
          description: Link relation type.
        href:
          type: string
          format: uri
          description: Link URL.
        method:
          type: string
          description: HTTP method for this link.
        type:
          type: string
          description: Media type of the linked resource.
    ScriptInput:
      type: object
      description: Input for creating or updating a script.
      required:
      - name
      - content
      properties:
        name:
          type: string
          description: Script name.
        content:
          type: string
          description: Script content (calculation or MDX statements).
    Error:
      type: object
      description: Error response from the Essbase REST API.
      properties:
        message:
          type: string
          description: Human-readable error message.
        errorCode:
          type: string
          description: Machine-readable error code.
        details:
          type: string
          description: Additional error details.
    Script:
      type: object
      description: A calculation or MDX script associated with a database.
      properties:
        name:
          type: string
          description: Script name.
        content:
          type: string
          description: Script content (calculation or MDX statements).
        modifiedBy:
          type: string
          description: User who last modified the script.
        modifiedTime:
          type: integer
          format: int64
          description: Last modification timestamp in milliseconds since epoch.
        links:
          type: array
          items:
            $ref: '#/components/schemas/Link'
  securitySchemes:
    basicAuth:
      type: http
      scheme: basic
      description: HTTP Basic Authentication using Essbase username and password.
    bearerAuth:
      type: http
      scheme: bearer
      bearerFormat: JWT
      description: OAuth 2.0 Bearer token authentication for cloud deployments on Oracle Cloud Infrastructure.