insert_table_record
Inserts a single record into a Caspio table. The payload is a flat JSON object of field name/value pairs (e.g., {'Name': 'John', 'Age': 30}). Only include editable fields -- 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 (a system-generated unique identifier present on every Caspio table record). IMPORTANT: field names are case-insensitive and must come from discover_tables' field list -- never guess. Call discover_tables first for any table not already discovered earlier in this conversation to get its tableId and confirm which fields exist and which are editable.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| payload | Yes | A JSON object of field name/value pairs for the new record. Keys are field names, values are the data to insert. Example: {'LibraryName': 'Main Library', 'City': 'Portland', 'State': 'Oregon'} | |
| tableId | Yes | Table Id (obtained from discover_tables, e.g. 'd99357') -- the table's name has no meaning for API calls; only the Id can be used here. |