Oracle Essbase User Session API

User login, logout, and password management

Documentation

Specifications

Schemas & Data

Other Resources

OpenAPI Specification

oracle-essbase-user-session-api-openapi.yml Raw ↑
openapi: 3.1.0
info:
  title: Oracle Essbase REST Application Configuration User Session 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: User Session
  description: User login, logout, and password management
paths:
  /session/login:
    post:
      operationId: login
      summary: Oracle Essbase Login
      description: Authenticates a user and creates a new session. Returns session information upon successful login.
      tags:
      - User Session
      requestBody:
        required: true
        content:
          application/json:
            schema:
              type: object
              required:
              - username
              - password
              properties:
                username:
                  type: string
                  description: User login name.
                password:
                  type: string
                  format: password
                  description: User password.
      responses:
        '200':
          description: Login successful.
          content:
            application/json:
              schema:
                type: object
                properties:
                  token:
                    type: string
                    description: Session token for subsequent requests.
        '400':
          description: Invalid credentials.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
  /session/logout:
    post:
      operationId: logout
      summary: Oracle Essbase Logout
      description: Terminates the current user session and invalidates the session token.
      tags:
      - User Session
      responses:
        '200':
          description: Logout successful.
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
  /session/password:
    put:
      operationId: changePassword
      summary: Oracle Essbase Change Password
      description: Changes the password for the currently authenticated user.
      tags:
      - User Session
      requestBody:
        required: true
        content:
          application/json:
            schema:
              type: object
              required:
              - oldPassword
              - newPassword
              properties:
                oldPassword:
                  type: string
                  format: password
                  description: Current password.
                newPassword:
                  type: string
                  format: password
                  description: New password.
      responses:
        '200':
          description: Password changed successfully.
        '400':
          description: Bad request or invalid current password.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
components:
  schemas:
    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.
  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.