Get all applications in the specified workspace
get
/apex/workspaces/{workspace_name}/applications/
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.
Request
Path Parameters
-
workspace_name(required): string
Display name of the workspace.
Query Parameters
-
limit: integer(int32)
The maximum number of records to return.
-
q:
Filtering is the process of limiting a collection resource by using a per-request dynamic filter definition across multiple page resources, where each page contains a subset of items found in the complete collection. Filtering enables efficient traversal of large collections.Examples
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
200 Response
All Oracle APEX applications in the workspace.
Root Schema : APEXWorkspaces
Type:
Show Source
object
-
count: integer
Total number of records in the current response.
-
hasMore: boolean
Indicates if there are more records to be retrieved.
-
items: array
items
-
limit: integer
The actual page size limit on number of records applied by the server.
-
links: array
links
-
offset: integer
The actual index from which the item resources are returned.
Nested Schema : items
Type:
Show Source
array
-
Array of:
object APEXWorkspacesItem
This object represents a single row on APEX_WORKSPACES.
Nested Schema : APEXWorkspacesItem
Type:
object
This object represents a single row on APEX_WORKSPACES.
Show Source
-
allow_app_building_yn: string
Controls availability of application building component.
-
allow_issue_files_yn: string
Controls availability of issue files component.
-
allow_packaged_app_ins_yn: string
Controls availability of packaged application installation component.
-
allow_restful_services_yn: string
Controls availability of RESTful services component.
-
allow_sql_workshop_yn: string
Controls availability of SQL workshop component.
-
allow_team_dev_files_yn: string
Controls availability of team development files component.
-
allow_team_development_yn: string
Controls availability of team development component.
-
allow_to_be_purged_yn: string
Controls availability of purge component.
-
allow_websheet_dev_yn: string
Controls availability of websheet development component.
-
apex_users: integer
Number of APEX users created in this workspace.
-
application_pages: integer
Number of application pages created in this workspace.
-
applications: integer
Number of applications created in this workspace.
-
created_on: string
The date the workspace was created.
-
last_login: string
Creation date of the most recently purged session. Used to track last login for workspaces who no longer have entries in the activity log.
-
links: array
links
-
workspace_description: string
The description for the workspace.
-
workspace_display_name: string
Display name for the workspace.
-
workspace_id: integer
Primary key that identifies the workspace.
-
workspace_name: string
A work area mapped to one or more database schemas.
Examples