apex_add_kpi_row
Add a horizontal row of KPI cards to an Oracle APEX page, each card showing a scalar metric from SQL with custom label, icon, and color.
Instructions
Add a horizontal row of KPI cards. Each: {label, sql, icon, color}.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"page_id": "<page_id>",
"region_name": "<region_name>",
"metrics": "<metrics>"
},
"name": "apex_add_kpi_row"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| metrics | Yes | List of metric dicts (3–6 items): - "label": Display label - "sql": SQL returning a single scalar value - "suffix": Optional unit suffix ("%" , " dias", etc.) - "color": Accent color for the value text | |
| page_id | Yes | Target page ID. | |
| sequence | No | ||
| custom_css | No | Additional CSS rules injected into the style block. | |
| value_size | No | CSS font-size for metric values (default "1.4rem"). | 1.4rem |
| region_name | Yes | Internal region name. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |