Oracle Partitioning Oracle APEX API
Services related to Oracle APEX. The product must be installed in the Oracle database that ORDS is configured to use.
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.
Call it yourself
curl for this page
This API
curl "https://apis.io/api/v1/apis/oracle-partitioning-oracle-apex-api"
All apis
curl "https://apis.io/api/v1/apis?limit=25"Discovery needs no key. Ratings and market analysis are Pro.
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.
A second provider on the same verified email joins the account you already have.
OpenAPI Specification
openapi: 3.2.0
info:
description: '<p>Provides the Oracle REST Data Services (ORDS) users the ability to perform Oracle Database management and monitoring operations through a user-friendly REST API. Depending on the database version and configuration, ORDS database APIs provide services such as manage pluggable databases, export data, and review database performance.</p><p>To install and configure Oracle REST Data Services refer to the <a href=https://docs.oracle.com/pls/topic/lookup?ctx=ords-latest&id=ORDIG> Oracle® REST Data Services Installation and Configuration Guide</a>.</p>
<p>An OpenAPI V3 document that describes the available ORDS database API services can be retrieved from a running ORDS instance. The API document can be imported into compatible development tools and invoked from there. The URL to retrieve the API document depends on the your configuration. <p><p>The pattern for the API document URL is: </p>
<code>https://<server>/<context root>/<my database>/<my schema>/_/db-api/stable/<service path> </code>
<p>Where, the <code><my database></code> and <code><my schema></code> variables can be optional, depending on the ORDS configuration and the service invoked.'
version: 2026.03.26
title: Oracle REST Data Services Oracle APEX API
contact:
name: Oracle REST Data Services
url: https://www.oracle.com/database/technologies/appdev/rest.html
x-summary: Provides the Oracle REST Data Services (ORDS) users the ability to perform Oracle Database management and monitoring operations through a user-friendly REST API.
tags:
- name: Oracle APEX
description: Services related to Oracle APEX. The product must be installed in the Oracle database that ORDS is configured to use.
paths:
/apex/statistics/overview:
get:
tags:
- Oracle APEX
summary: Get instance overview
description: This service returns aggregated overview data for an Application Express instance. If number_of_days parameter is not specified the response is for upto 30 days of aggregated data. A client requires SQL Administrator role to invoke this service.
parameters:
- name: number_of_days
in: query
description: Specifies the number of days into the past to aggregate data for.
required: false
schema:
type: integer
responses:
'200':
description: All APEX workspaces in the instance.
content:
application/json:
schema:
$ref: '#/components/schemas/APEXInstanceOverview'
x-internal-id: apex-statistics-overview-get
x-filename-id: apex-statistics-overview-get
/apex/statistics/application/{application_id}/:
get:
tags:
- Oracle APEX
summary: Get application statistics
description: This service returns usage statistics for a specific Oracle APEX application. A client requires SQL Administrator role to invoke this service.
parameters:
- name: application_id
in: path
description: Identifier of the application.
required: true
schema:
type: string
- $ref: '#/components/parameters/Limit'
- $ref: '#/components/parameters/Filter'
responses:
'200':
description: All Oracle APEX application usage statistics.
content:
application/json:
schema:
$ref: '#/components/schemas/APEXUsageStatistics'
x-internal-id: apex-statistics-application-{application_id}--get
x-filename-id: apex-statistics-application-application_id-get
/apex/statistics/instance/:
get:
tags:
- Oracle APEX
summary: Get instance statistics
description: This service returns usage statistics for the whole Oracle APEX instance. A client requires SQL Administrator role to invoke this service.
parameters:
- $ref: '#/components/parameters/Limit'
- $ref: '#/components/parameters/Filter'
responses:
'200':
description: All usage statistics for the Oracle APEX instance.
content:
application/json:
schema:
$ref: '#/components/schemas/APEXUsageStatistics'
x-internal-id: apex-statistics-instance--get
x-filename-id: apex-statistics-instance-get
/apex/statistics/workspace/{workspace_name}/:
get:
tags:
- Oracle APEX
summary: Get application statistics
description: This service returns usage statistics for a specific Oracle APEX workspace. A client requires SQL Administrator role to invoke this service.
parameters:
- name: workspace_name
in: path
description: Display name of the workspace.
required: true
schema:
type: string
- $ref: '#/components/parameters/Limit'
- $ref: '#/components/parameters/Filter'
responses:
'200':
description: Statistics for all Oracle APEX workspaces in the instance.
content:
application/json:
schema:
$ref: '#/components/schemas/APEXUsageStatistics'
x-internal-id: apex-statistics-workspace-{workspace_name}--get
x-filename-id: apex-statistics-workspace-workspace_name-get
/apex/workspaces/:
get:
tags:
- Oracle APEX
summary: Get all workspaces
description: Returns information about the Oracle APEX workspaces available. A client requires SQL Administrator role to invoke this service.
parameters:
- $ref: '#/components/parameters/Limit'
- $ref: '#/components/parameters/Filter'
responses:
'200':
description: All Oracle APEX workspaces in the instance.
content:
application/json:
schema:
$ref: '#/components/schemas/APEXWorkspaces'
examples:
all_workspaces_in_schema:
summary: An example of a list of all workspaces that the user has access to.
value:
count: 1
hasMore: false
items:
- workspace_id: '2499355381608110'
workspace_name: WORK120
workspace_display_name: WORK120
workspace_description: null
schemas: 1
created_on: '2022-11-24T01:54:20Z'
last_login: null
allow_app_building_yn: Y
allow_packaged_app_ins_yn: null
allow_sql_workshop_yn: Y
allow_websheet_dev_yn: null
allow_team_development_yn: Y
allow_team_dev_files_yn: N
allow_issue_files_yn: Y
allow_to_be_purged_yn: Y
allow_restful_services_yn: Y
applications: 0
application_pages: 0
apex_users: 1
links:
- rel: self
href: http://localhost:8080/ords/_/db-api/stable/apex/workspaces/WORK120/
- rel: related
href: http://localhost:8080/ords/_/db-api/stable/apex/workspaces/WORK120/applications/
- rel: related
href: http://localhost:8080/ords/_/db-api/stable/apex/statistics/workspace/WORK120/
title: Workspace Statistics
limit: 25
links:
- href: https://myserver/ords/myschema/_/db-api/stable/apex/workspaces/example_workspace/applications/
rel: self
- href: https://myserver/ords/myschema/_/db-api/stable/metadata-catalog/
rel: describedby
offset: 0
x-internal-id: apex-workspaces--get
x-filename-id: apex-workspaces-get
/apex/workspaces/{workspace_name}/:
get:
tags:
- Oracle APEX
summary: Get workspace
description: This service returns a specific Oracle APEX workspace. A client requires SQL Administrator role to invoke this service.
parameters:
- name: workspace_name
in: path
description: Display name of the workspace.
required: true
schema:
type: string
- $ref: '#/components/parameters/Limit'
- $ref: '#/components/parameters/Filter'
responses:
'200':
description: A specific Oracle APEX workspace.
content:
application/json:
schema:
$ref: '#/components/schemas/APEXWorkspacesItem'
x-internal-id: apex-workspaces-{workspace_name}--get
x-filename-id: apex-workspaces-workspace_name-get
/apex/workspaces/{workspace_name}/datasets/:
get:
tags:
- Oracle APEX
summary: Get all datasets in the specified workspace
description: Returns information about the datasets available in the specified workspace. A client requires SQL Administrator role to invoke this service.
parameters:
- name: workspace_name
in: path
description: Display name of the workspace.
required: true
schema:
type: string
- $ref: '#/components/parameters/Limit'
- $ref: '#/components/parameters/Filter'
responses:
'200':
description: All datasets in the workspace.
content:
application/json:
schema:
$ref: '#/components/schemas/APEXDatasets'
examples:
all_datasets_in_workspace:
summary: An example of a list of all the datasets in the workspace that the user has access to.
value:
count: 1
hasMore: false
items:
- dataset_id: '2066291953340216'
dataset_name: Simple-Dataset
dataset_description: Description of dataset
static_id: SIMPLE_DATASET
workspace_display_name: ORDS
workspace: ORDS
workspace_id: '2063824650324169'
last_updated_by: PAIGE
last_updated_on: '2022-04-06T07:37:17Z'
links:
- href: https://myserver/ords/myschema/_/db-api/stable/apex/datasets/Simple-Dataset
rel: self
limit: 25
links:
- href: https://myserver/ords/myschema/_/db-api/stable/apex/workspaces/example_workspace/datasets/
rel: self
- href: https://myserver/ords/myschema/_/db-api/stable/metadata-catalog/
rel: describedby
offset: 0
x-internal-id: apex-workspaces-{workspace_name}-datasets--get
x-filename-id: apex-workspaces-workspace_name-datasets-get
/apex/workspaces/{workspace_name}/datasets/{dataset_name}:
get:
tags:
- Oracle APEX
summary: Get a specific Oracle APEX Dataset
description: This service returns a representation of the specified Oracle APEX Dataset. The representation data will be a metadata about the Oracle APEX Dataset from APEX_DR_DATASETS view. See APEX documentation for more information. A client requires SQL Developer or SQL Administrator role.
parameters:
- name: workspace_name
in: path
description: Display name of the workspace.
required: true
schema:
type: string
- name: dataset_name
in: path
description: Display name of the dataset.
required: true
schema:
type: string
responses:
'200':
description: The specified Oracle APEX Dataset.
content:
application/json:
schema:
$ref: '#/components/schemas/DatasetItem'
examples:
dataset_example:
summary: An example of the details returned for the specified Oracle APEX Dataset.
value:
dataset_id: '2066291953340216'
dataset_name: Simple-Dataset
dataset_description: Description of dataset
static_id: SIMPLE_DATASET
workspace_display_name: ORDS
workspace: ORDS
workspace_id: '2063824650324169'
last_updated_by: PAIGE
last_updated_on: '2022-04-06T07:37:17Z'
links:
- rel: collection
href: https://myserver/ords/myschema/_/db-api/stable/apex/workspaces/example_workspace/datasets/
'400':
description: Bad Request - The dataset does not exist.
x-internal-id: apex-workspaces-{workspace_name}-datasets-{dataset_name}-get
x-filename-id: apex-workspaces-workspace_name-datasets-dataset_name-get
/apex/workspaces/{workspace_name}/applications/:
get:
tags:
- Oracle APEX
summary: Get all applications in the specified workspace
description: Returns information about the Oracle APEX applications available in the specified workspace. This endpoint is a convenience. The same information can be retreived using /apex/applications/?q={"workspace_display_name":"EXAMPLE_WORKSPACE"} endpoint. A client requires SQL Administrator role to invoke this service.
parameters:
- name: workspace_name
in: path
description: Display name of the workspace.
required: true
schema:
type: string
- $ref: '#/components/parameters/Limit'
- $ref: '#/components/parameters/Filter'
responses:
'200':
description: All Oracle APEX applications in the workspace.
content:
application/json:
schema:
$ref: '#/components/schemas/APEXApplications'
examples:
all_applications_in_workspace:
summary: An example of a list of all applications in the workspace that the user has access to.
value:
count: 1
hasMore: false
items:
- application_id: 400
application_name: Sample Calendar
application_alias: A782020211201055214947
application_group: 22.1 Sample Apps
application_owner: HR
page_count: 37
application_type: STANDARD
workspace: ORDS
availability_status: Available with Edit Links
last_updated_by: PAIGE
last_updated_on: '2022-04-06T07:37:17Z'
links:
- href: https://myserver/ords/myschema/_/db-api/stable/apex/applications/101
rel: self
limit: 25
links:
- href: https://myserver/ords/myschema/_/db-api/stable/apex/workspaces/example_workspace/applications/
rel: self
- href: https://myserver/ords/myschema/_/db-api/stable/metadata-catalog/
rel: describedby
offset: 0
x-internal-id: apex-workspaces-{workspace_name}-applications--get
x-filename-id: apex-workspaces-workspace_name-applications-get
/apex/applications/{application_id}:
get:
tags:
- Oracle APEX
summary: Get or export a specific APEX application
description: This service returns a representation of the specified APEX Application. The representation data will be a metadata about the APEX Application from APEX_APPLICATIONS view or an export of the entire application using APEX GET_APPLICATION.EXPORT database procedure. See APEX documentation for more information. A client requires SQL Developer or SQL Administrator role.
parameters:
- name: application_id
in: path
description: Application Primary Key, Unique over all workspaces.
required: true
schema:
type: string
- name: export_format
in: query
description: Indicates the file format to return the entire application components. Valid values SQL_SCRIPT | SQL_ZIP
schema:
type: string
enum:
- SQL_SCRIPT
- SQL_ZIP
- name: export_type
in: query
description: Parameter for APEX Export function. Comma-delimited list of export types to perform APPLICATION_SOURCE,EMBEDDED_CODE, CHECKSUM-SH1
schema:
type: string
examples:
export_type_src:
summary: Export application source
value: APPLICATION_SOURCE
- name: with_date
in: query
description: Parameter for APEX Export function. If true include export date and time in the result. Only valid if export_format query parameter is also specified.
schema:
type: boolean
- name: with_ir_public_reports
in: query
description: Parameter for APEX Export function. If true, include public reports that a user saved. Only valid if export_format query parameter is also specified.
schema:
type: boolean
- name: with_ir_private_reports
in: query
description: Parameter for APEX Export function. If true, include private reports that a user saved. Only valid if export_format query parameter is also specified.
schema:
type: boolean
- name: with_ir_notifications
in: query
description: Parameter for APEX Export function. If true, include report notifications. Only valid if export_format query parameter is also specified.
schema:
type: boolean
- name: with_translations
in: query
description: Parameter for APEX Export function. If true, include application translation mappings and all text from the translation repository. Only valid if export_format query parameter is also specified.
schema:
type: boolean
- name: with_pkg_app_mapping
in: query
description: If true, export installed packaged applications with references to the packaged application definition. If false, export them as normal applications.
schema:
type: boolean
- name: with_original_ids
in: query
description: Parameter for APEX Export function. If true, export with the IDs as they were when the application was imported. Only valid if export_format query parameter is also specified.
schema:
type: boolean
- name: with_no_subscriptions
in: query
description: Parameter for APEX Export function. If true, components contain subscription references. Only valid if export_format query parameter is also specified.
schema:
type: boolean
- name: with_comments
in: query
description: Parameter for APEX Export function. If true, include developer comments. Only valid if export_format query parameter is also specified.
schema:
type: boolean
- name: with_supporting_objects
in: query
description: Parameter for APEX Export function. If 'Y', export supporting objects. If 'I',automatically install on import. If 'N', do not export supporting objects. If null, the application's include in export deployment value is used. Only valid if export_format query parameter is also specified.
schema:
type: string
enum:
- Y
- I
- N
- name: with_acl_assignments
in: query
description: Parameter for APEX Export function. If true, export ACL user role assignments. Only valid if export_format query parameter is also specified.
schema:
type: boolean
- name: with_audit_info
in: query
description: 'Parameter for the APEX Export function. If "NULL", export excludes all audit information. If "NAMES_AND_DATES", export includes Created On, Created By, Updated On, and Updated By values if they exist. If "DATES_ONLY", export includes Created On and Updated On values only; user names are excluded. Only valid if the export_format query parameter is also specified. Enum: "NAMES_AND_DATES", "DATES_ONLY".'
schema:
type: string
enum:
- NAMES_AND-DATES
- DATES_ONLY
responses:
'200':
description: The specified Oracle APEX application.
content:
application/json:
schema:
$ref: '#/components/schemas/APEXApplicationsItem'
examples:
application_example:
summary: An example of the details returned for the specified application. Returned when export_format query parameter is not specified in the request.
value:
application_id: 103
application_name: Sample Cards
application_alias: SAMPLE-CARDS103
application_group: null
application_owner: HR
page_count: 25
application_type: STANDARD
workspace: ORDS
availability_status: Available with Edit Links
last_updated_by: TIM
last_updated_on: '2022-04-06T12:31:05Z'
links:
- href: https://myserver/ords/myschema/_/db-api/stable/apex/applications/101
rel: self
- href: https://myserver/ords/myschema/_/db-api/stable/apex/statistics/application/101/
rel: related
title: Application Statistics
- href: https://myserver/ords/myschema/_/db-api/stable/apex/workspaces/example_workspace/
rel: related
title: Workspace
- href: https://myserver/ords/myschema/_/db-api/stable/apex/applications/101?export_format=SQL_SCRIPT&with_date=true
rel: enclosure
type: application/sql
title: Export Application as SQL file
- href: https://myserver/ords/myschema/_/db-api/stable/apex/applications/101?export_format=SQL_ZIP&with_date=true&with_supporting_objects=false
rel: enclosure
type: application/zip
title: Export Application as ZIP file
application/sql:
schema:
type: string
format: binary
examples:
sqlExample:
summary: The APEX application source exported in single SQL script. Returned when export_format query parameter is SQL_SCRIPT in the request.
value: "--begin SQL script snippet sample\n ...\n wwv_flow_imp.import_begin (p_version_yyyy_mm_dd=>'2022.10.07'\n ,p_release=>'22.2.0'\n ,p_default_workspace_id=>7586151564871204\n ,p_default_application_id=>101\n ,p_default_id_offset=>7587564257891170\n ,p_default_owner=>'EXAMPLEWS'\n );\n ...\n--end SQL script snippet sample"
application/zip:
schema:
type: string
format: binary
examples:
zipExample:
summary: The APEX application source exported in ZIP format. Returned when export_format query parameter is SQL_ZIP in the request.
value: --begin zip snippet sample UEsDBBQAAAgIAG5aYlUY6d2blwAAAL0AAAASAAAAZjEwNi9jb3B5cmlnaHQudHh0LY3LCsIwEEX3/Yq7VJCk7bJbFyKICuIHDOnUBtIkZKYV/9762NzVOfecaeION5pyYByjciGnfmEciu+l2q --end zip snippet sample
'400':
description: Bad Request - The export related query parameters provided without specifying export_format.
x-internal-id: apex-applications-{application_id}-get
x-filename-id: apex-applications-application_id-get
post:
tags:
- Oracle APEX
summary: Export APEX application components and/or runtime instance data
description: Exports selected components of a specified APEX application and/or runtime instance data.
parameters:
- name: application_id
in: path
description: Application Primary Key, Unique over all workspaces.
required: true
schema:
type: string
- name: export_format
in: query
description: Indicates the file format to return the entire application components. Valid values SQL_SCRIPT | SQL_ZIP
schema:
type: string
enum:
- SQL_SCRIPT
- SQL_ZIP
- name: export_type
in: query
description: Parameter for APEX Export function. Comma-delimited list of export types to perform APPLICATION_SOURCE,EMBEDDED_CODE, CHECKSUM-SH1
schema:
type: string
examples:
export_type_src:
summary: Export application source
value: APPLICATION_SOURCE
- name: with_date
in: query
description: Parameter for APEX Export function. If true include export date and time in the result. Only valid if export_format query parameter is also specified.
schema:
type: boolean
- name: with_ir_public_reports
in: query
description: Parameter for APEX Export function. If true, include public reports that a user saved. Only valid if export_format query parameter is also specified.
schema:
type: boolean
- name: with_ir_private_reports
in: query
description: Parameter for APEX Export function. If true, include private reports that a user saved. Only valid if export_format query parameter is also specified.
schema:
type: boolean
- name: with_ir_notifications
in: query
description: Parameter for APEX Export function. If true, include report notifications. Only valid if export_format query parameter is also specified.
schema:
type: boolean
- name: with_translations
in: query
description: Parameter for APEX Export function. If true, include application translation mappings and all text from the translation repository. Only valid if export_format query parameter is also specified.
schema:
type: boolean
- name: with_pkg_app_mapping
in: query
description: If true, export installed packaged applications with references to the packaged application definition. If false, export them as normal applications.
schema:
type: boolean
- name: with_original_ids
in: query
description: Parameter for APEX Export function. If true, export with the IDs as they were when the application was imported. Only valid if export_format query parameter is also specified.
schema:
type: boolean
- name: with_no_subscriptions
in: query
description: Parameter for APEX Export function. If true, components contain subscription references. Only valid if export_format query parameter is also specified.
schema:
type: boolean
- name: with_comments
in: query
description: Parameter for APEX Export function. If true, include developer comments. Only valid if export_format query parameter is also specified.
schema:
type: boolean
- name: with_supporting_objects
in: query
description: 'Parameter for the APEX Export function. If "NULL", export excludes all audit information. If "NAMES_AND_DATES", export includes Created On, Created By, Updated On, and Updated By values if they exist. If "DATES_ONLY", export includes Created On and Updated On values only; user names are excluded. Only valid if the export_format query parameter is also specified. Enum: "NAMES_AND_DATES", "DATES_ONLY".'
schema:
type: string
enum:
- Y
- I
- N
- name: with_acl_assignments
in: query
description: Parameter for APEX Export function. If true, export ACL user role assignments. Only valid if export_format query parameter is also specified.
schema:
type: boolean
- name: with_audit_info
in: query
description: Parameter for APEX Export function. If 'NULL', export excludes all audit information. if 'NAMES_AND_DATES', export includes Created On, Created By, Updated On, Updated By values if they exist. If 'DATES_ONLY', export includes Created On and Updated On values if they exist. User names are excluded. Only valid if export_format query parameter is also specified.
schema:
type: string
enum:
- NAMES_AND-DATES
- DATES_ONLY
requestBody:
description: Defines what should be exported from the APEX application. You can export application components, runtime instance data, or both.
required: true
content:
application/json:
schema:
type: object
description: This object represents an export request for APEX application components and/or runtime instance data.
required:
- export_format
properties:
components:
description: Parameter for APEX Export function. The list of components in the specified APEX Application to export.
type: array
items:
description: Alias of the component. Format is TYPE:IDENTIFIER.
type: string
withRuntimeInstances:
description: Parameter for APEX Export function. An array with components for which to export runtime instance data
type: array
items:
description: If "WORKFLOW", exports workflow instances and their associated task instances. If "TASK", exports task instances that are not associated with any workflow. If "WORKFLOW, TASK", exports both workflow instances with their associated tasks and task instances not associated with any workflow.
type: string
enum:
- WORKFLOW
- TASK
examples:
export_specific_components:
summary: Listing two specific APEX Applications components to export. The query parameter export_format MUST be specified.
value:
components:
- LOV:123
- PAGE:321
export_runtime_instances:
summary: Setting the runtime instance to WORKFLOW, in order to export workflow instances and their associated task instances. The query parameter export_format MUST be specified.
value:
withRuntimeInstances:
- WORKFLOW
responses:
'200':
description: The current state of the specified Oracle APEX application components.
content:
application/sql:
schema:
type: string
format: binary
examples:
sqlExample:
summary: The APEX application components source exported in single SQL script
value: "--begin SQL script snippet sample\n ...\n wwv_flow_imp.import_begin (p_version_yyyy_mm_dd=>'2022.10.07'\n ,p_release=>'22.2.0'\n ,p_default_workspace_id=>7586151564871204\n ,p_default_application_id=>101\n ,p_default_id_offset=>7587564257891170\n ,p_default_owner=>'EXAMPLEWS'\n );\n ...\n--end SQL script snippet sample"
application/zip:
schema:
type: string
format: binary
examples:
zipExample:
summary: The APEX application components source exported in ZIP format
value: --begin zip snippet sample UEsDBBQAAAgIAG5aYlUY6d2blwAAAL0AAAASAAAAZjEwNi9jb3B5cmlnaHQudHh0LY3LCsIwEEX3/Yq7VJCk7bJbFyKICuIHDOnUBtIkZKYV/9762NzVOfecaeION5pyYByjciGnfmEciu+l2q --end zip snippet sample
'400':
description: Bad Request - The service requested requires a body in the request.
x-internal-id: apex-applications-{application
# --- truncated at 32 KB (49 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/oracle-partitioning/refs/heads/main/openapi/oracle-partitioning-oracle-apex-api-openapi.yml