Skip to main content
Glama

insert_view_record

Inserts a single record through a Caspio view. The payload is a flat JSON object of field name/value pairs (e.g., {'SaleStatus': 'Open', 'SaleAmount': 500}). Only include editable fields -- in multi-table views, only fields from the primary table are editable (check Editable=true in the view's field definitions). Do not include auto-generated fields (Autonumber, Timestamp, Random ID, GUID, Prefixed Autonumber, Formula, or PK_ID). Returns the full created record including PK_ID. IMPORTANT: field names are case-insensitive and must come from discover_views' field list -- never guess. Call discover_views first for any view not already discovered earlier in this conversation to get its viewId and confirm which fields exist and which are editable.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
viewIdYesView Id (obtained from discover_views, e.g. 'v12345') -- the view's name has no meaning for API calls; only the Id can be used here.
payloadYesA JSON object of field name/value pairs for the new record. Keys are field names, values are the data to insert. Example: {'SaleStatus': 'Open', 'SaleAmount': 500, 'ContactID': 12}

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observed

TDQS

A4.6/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations only state readOnlyHint=false and destructiveHint=false, so the description carries much of the behavioral burden. It exceeds that burden by disclosing the return value ('Returns the full created record including PK_ID'), case-insensitivity of field names, the editable-field restriction, and the prohibition on auto-generated fields. It does not cover auth or failure behavior, but it does not contradict the annotations.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is longer than average, but every sentence carries operational value: purpose, payload shape, editable-field constraints, exclusions, return behavior, and discovery prerequisite. The main action is front-loaded, and the density is justified by the complexity of Caspio view insertion. There is no filler or redundancy.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a write tool with no output schema and a nested payload parameter, this description is remarkably complete. It explains what the tool returns, how to obtain the viewId, what field names are valid, which fields must be omitted, and how editable fields are determined in multi-table views. An agent has all the information needed to invoke the tool successfully in the normal flow.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters5/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100%, so the baseline is 3, but the description significantly extends the schema. It clarifies that the payload must be a flat JSON object, gives an explicit example, warns to only include editable fields, lists the auto-generated field types to exclude, and states that field names are case-insensitive and must come from discover_views. This materially improves an agent's ability to construct a valid payload.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description opens with a clear verb-resource pair: 'Inserts a single record through a Caspio view.' It distinguishes itself from sibling insert_table_record by emphasizing view-specific behavior, and it reinforces the view context with viewId sourced from discover_views. This is specific enough for an agent to know exactly what the tool does and how it differs from nearby tools.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description gives explicit prerequisites and workflow: call discover_views first for any undiscovered view, obtain viewId, and confirm editable fields. It also states what not to include (auto-generated fields) and which fields are editable in multi-table views. It does not explicitly name insert_table_record as the alternative for table targets, but the 'through a Caspio view' wording and sibling list make the context clear without exclusion guidance.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.

Resources