Create Record
AI-generatedSummary
Creates one or more records in an AppSheet table.
Inputs
- region — The AppSheet region domain to use in the API URL.
- tableName (required) — Name of the AppSheet table (URL-encoded if needed).
- records — Record must include the key field values required by your table.
- batchSize — Number of records per request. Set to 0 to disable batching.
- locale — Locale used for formatting dates and numbers (e.g., en-US)
- location — Geographical coordinates (e.g., 47.623098, -122.330184)
- timezone — Timezone used for date/time formatting
- actionProperties — Optional: Enter additional properties for the action as a JSON object
- runAsUserEmail — The user email address of the person taking the action. If empty, the action runs as the application owner
- userSettings — User settings to use when performing the action. Leave empty to use no user settings
Output shape
array of created record objects (or empty if no records)
The API response for each batch is returned; errors are thrown rather than wrapped.
Examples
Example 1: Add a new row to a Contacts table
region: www.appsheet.com, tableName: Contacts, records: [{key: 'Name', value: 'John Doe'}], batchSize: 100
Example 2: Create 150 rows in Orders with custom locale
tableName: Orders, records: [{key: 'OrderID', value: '1001'}, {key: 'Status', value: 'Pending'}], batchSize: 50, locale: 'fr-FR'
Example 3: Invoke a custom action after creating a record
tableName: Projects, records: [{key: 'ProjectID', value: 'P001'}], actionName: 'UpdateStatus', actionProperties: '{"status":"in progress"}', runAsUserEmail: 'admin@example.com'