Oracle APEX · Schema
HandlerCreate
Request body for creating or updating a REST template handler
APEXCloudDatabaseDevelopment PlatformEnterpriseGenerative AILow-CodeOracleORDSPL/SQLREST APIWeb ApplicationsWorkflows
Properties
| Name | Type | Description |
|---|---|---|
| template_id | integer | ID of the parent REST template |
| source | string | The source code implementation (SQL query or PL/SQL block) executed when this handler processes a request |
| source_type | string | The type of source code that determines how the source is executed |
| method | string | HTTP method this handler responds to |
| items_per_page | integernull | Pagination size for GET handlers. NULL defers to the module-level setting. |
| mimes_allowed | string | Comma-separated list of MIME types accepted by PUT and POST handlers |
| comments | string | Descriptive comment for the handler |
| run_mode | string | Set to 'codePreview' to return the PL/SQL code instead of executing it |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"$id": "#/components/schemas/HandlerCreate",
"title": "HandlerCreate",
"type": "object",
"description": "Request body for creating or updating a REST template handler",
"required": [
"template_id",
"source"
],
"properties": {
"template_id": {
"type": "integer",
"description": "ID of the parent REST template"
},
"source": {
"type": "string",
"description": "The source code implementation (SQL query or PL/SQL block) executed when this handler processes a request"
},
"source_type": {
"type": "string",
"description": "The type of source code that determines how the source is executed",
"enum": [
"source_type_collection_feed",
"source_type_collection_item",
"source_type_media",
"source_type_plsql",
"source_type_query",
"source_type_csv_query",
"source_type_query_one_row",
"source_type_feed"
]
},
"method": {
"type": "string",
"description": "HTTP method this handler responds to",
"enum": [
"GET",
"POST",
"PUT",
"DELETE"
]
},
"items_per_page": {
"type": [
"integer",
"null"
],
"description": "Pagination size for GET handlers. NULL defers to the module-level setting.",
"minimum": 1
},
"mimes_allowed": {
"type": "string",
"description": "Comma-separated list of MIME types accepted by PUT and POST handlers"
},
"comments": {
"type": "string",
"description": "Descriptive comment for the handler"
},
"run_mode": {
"type": "string",
"description": "Set to 'codePreview' to return the PL/SQL code instead of executing it",
"enum": [
"codePreview"
]
}
}
}
Work with this as data
Every JSON Schema 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 schemas
4 MCP tools reach this
find_json_schemasBrowse and filter every JSON Schema in the catalog.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 JSON Schema
curl "https://apis.io/api/v1/json-schemas/oracle-apex-handlercreate"
All schemas
curl "https://apis.io/api/v1/json-schemas?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.