Oracle APEX · Schema
TemplateCreate
Request body for creating a REST module template
APEXCloudDatabaseDevelopment PlatformEnterpriseGenerative AILow-CodeOracleORDSPL/SQLREST APIWeb ApplicationsWorkflows
Properties
| Name | Type | Description |
|---|---|---|
| module_id | integer | ID of the parent REST module |
| uri_prefix | string | URI pattern for the template. Supports path parameters using :name syntax and optional parameters using :name? suffix. |
| priority | integer | Priority for evaluating the template when multiple templates match. 0 is lowest, 9 is highest. |
| etag_type | string | Type of entity tag generation for cache validation and optimistic locking |
| etag_query | string | SQL query used to generate the entity tag when etag_type is QUERY |
| comments | string | Descriptive comment for the template |
| 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/TemplateCreate",
"title": "TemplateCreate",
"type": "object",
"description": "Request body for creating a REST module template",
"required": [
"module_id",
"uri_prefix"
],
"properties": {
"module_id": {
"type": "integer",
"description": "ID of the parent REST module"
},
"uri_prefix": {
"type": "string",
"description": "URI pattern for the template. Supports path parameters using :name syntax and optional parameters using :name? suffix.",
"examples": [
"/objects/:object/:id?",
"/employees/",
"/departments/:dept_id"
]
},
"priority": {
"type": "integer",
"description": "Priority for evaluating the template when multiple templates match. 0 is lowest, 9 is highest.",
"minimum": 0,
"maximum": 9,
"default": 0
},
"etag_type": {
"type": "string",
"description": "Type of entity tag generation for cache validation and optimistic locking",
"enum": [
"HASH",
"QUERY",
"NONE"
]
},
"etag_query": {
"type": "string",
"description": "SQL query used to generate the entity tag when etag_type is QUERY"
},
"comments": {
"type": "string",
"description": "Descriptive comment for the template"
},
"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-templatecreate"
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.