AppSheet icon

AppSheet

Interact with the AppSheet API to add, read, update, delete records, or invoke a custom action on table records.

Actions7

Create Record

AI-generated

Summary

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'

Links

Discussion