app.builder.run
Home
First seen 2026-11-05 · Last seen 2026-11-05 · Source: webmcp.com
Answer 5 · Act 12 · Transact 2 · Score: Not yet scored
Tool inspector
upsert_view
Create or update a named view (a stored query: filter, sort, limit, columns, or live grouped measures). For a normal view, include fields in the order people should see them, such as fields: ["name", "status", "client.name"]. If fields is omitted while creating a normal view, builder.run chooses up to six useful source fields automatically; an empty fields array is invalid. Omitting fields while updating preserves the existing selection. For a grouped view, omit fields to derive them from group_by and measure aliases. group_by accepts one source field. measures supports count, sum, avg, min, and max; avg accepts field or fields. Sort aggregate aliases with order_by. Run it with query_view. Example: upsert_view({ key: "scores", source: "review", group_by: "submission", measures: { review_count: { op: "count" }, overall_score: { op: "avg", fields: ["quality", "impact"] } }, order_by: { overall_score: "desc" } }).
Input schema
| Property | Type | Required | Description |
|---|---|---|---|
key |
string | yes | — |
label |
string | no | — |
source |
string | yes | — |
fields |
array | no | Ordered visible columns for a normal view. Reference labels may use paths such as client.name. Omit on creation to infer useful defaults; omit on update to preserve existing columns; omit for grouped views to derive aggregate columns. |
where |
object | no | — |
expose |
array | no | — |
limit |
number | no | — |
order_by |
object | no | — |
group_by |
string | no | — |
measures |
object | no | Named live aggregates for a grouped view |
Raw JSON schema
{
"type": "object",
"properties": {
"key": {
"type": "string"
},
"label": {
"type": "string"
},
"source": {
"type": "string"
},
"fields": {
"type": "array",
"minItems": 1,
"items": {
"type": "string"
},
"description": "Ordered visible columns for a normal view. Reference labels may use paths such as client.name. Omit on creation to infer useful defaults; omit on update to preserve existing columns; omit for grouped views to derive aggregate columns."
},
"where": {
"type": "object"
},
"expose": {
"type": "array",
"items": {
"type": "string"
}
},
"limit": {
"type": "number"
},
"order_by": {
"type": "object"
},
"group_by": {
"type": "string"
},
"measures": {
"type": "object",
"description": "Named live aggregates for a grouped view",
"additionalProperties": {
"type": "object",
"properties": {
"op": {
"type": "string",
"enum": [
"count",
"sum",
"avg",
"min",
"max"
]
},
"field": {
"type": "string"
},
"fields": {
"type": "array",
"items": {
"type": "string"
}
}
},
"required": [
"op"
],
"additionalProperties": false
}
}
},
"required": [
"key",
"source"
],
"additionalProperties": false
}
Similar websites
morphus.myles4miles.chatgpt.site
Morphus is an AI-native workspace for designing worlds and generating playable game experiences.
damnpdfs.com
Install the DamnPDFs Codex plugin, pair a browser workspace and use PDF, image and file tools from your coding agent. Includes setup and privacy limits.
insignifi4nt.github.io
broCAD/M: local-first CAD and CAM for parametric design, wire EDM planning, simulation and controller export.
cabinet.varera.studio
The Cartographer's Cabinet