View Records

Updates view records that match a condition.

Only the fields included in the request body are modified; unspecified fields are left unchanged.
In multi-table views, only fields from the primary table can be updated (check Editable=true in the view's field definitions).
To clear a field value, pass null for that field.
where is required and supports Microsoft SQL Server syntax. A broad WHERE clause will update all matching records. To update a single record, filter by PK_ID.
If echo is true, the affected records are returned in the response (limited to the first 1000 records regardless of how many were actually updated).
If echo is false (default), only the count of affected records is returned.
Note: bulk PATCH by WHERE clause is a Caspio extension; RFC 5789 targets a single identified resource.

patch/v4/views/{viewId}/records/bulk

Request

Base URL: https://demo.caspio.com/integrations/rest
URL: https://demo.caspio.com/integrations/rest/v4/views/{viewId}/records/bulk
Auth: API key in header Authorization

Path parameters

viewIdstring required

The view identifier (6-character alphanumeric code).

Query parameters

echoboolean

When true, returns the updated records in the response. Default: false.

Request body

wherestring required

WHERE clause (required, Microsoft SQL Server syntax). Determines which records are updated. A broad clause updates all matching records. To update a single record, filter by PK_ID or another unique field. Examples: 'PK_ID=42', 'Status=N'Open' AND AssignedTo=N'John''.

recordValuesobject required

Field name/value pairs to update. Only include fields that should change; unspecified fields remain unchanged. Only include editable fields — do not include auto-generated fields (Autonumber, Timestamp, Random ID, GUID, Formula). Example: {"Status": "Closed", "Notes": "Resolved by admin"}.

Response

recordsAffectedinteger

dataobject[] nullable

Response payload

Changes

No recorded changes to this operation across all 1 revision of this API.