add_rows
Add rows to a data table (up to 500 a call): each row is { "": value }. Values are checked against each column's type: numbers, dates as YYYY-MM-DD (or YYYY-MM-DDTHH:MM), true/false for checkboxes, select and status values must be one of the column's options (by name), multi-select takes a list. The call is all or nothing: if any row is wrong nothing is added and the error says which row and why. A value already in the table's unique column is rejected: use upsert_rows to update-or-add by that column.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | ||
| table | Yes | the data table's id or name (list_data_tables) | |
| workspace | No | Which Caddie: leave it out for the user's personal one, or give a team workspace's name or id (list_workspaces). Use the same one you found the item in. |