Update Record
AI-generatedSummary
Update records in an AppSheet table
Inputs
- region — AppSheet region domain to use in the API URL; defaults to Global (www.appsheet.com)
- tableName (required) — Name of the AppSheet table (URL-encoded if needed)
- records (required) — Collection of records to update; each record must include the key field and the new value for the fields to update
- batchSize — Number of records to send per request; set to 0 to disable batching; defaults to 100
- options — Optional settings that affect the request, such as locale, location, timezone, action properties, run as user email, and user settings
Output shape
a JSON array of response objects; the exact structure varies by operation but generally includes success information and any returned records
Batch processing may cause multiple responses to be returned; optional fields such as batchSize control grouping; existence checks return a separate object with exists, count, and records fields; errors are propagated as node errors
Examples
Example 1: Update a single row using default batch size
Set Operation to Update Record, provide Table Name and Region, add one Record with the key column and value, leave Batch Size at default 100, and optionally configure Options such as Locale.
Example 2: Batch update multiple rows
Provide multiple Records, optionally set Batch Size to a custom value (e.g., 200) to control grouping, and optionally set locale or other options in the Options collection.