Reference
willo_db_insert
Insert rows into one table of the business's backend database.
- Act
- Needs approval
- Secret scan
On this page
Insert rows. ALWAYS needs a person's approval (pending_approval + link; call again after). While the business is drafting it runs on the draft backend, and the rows stay there: Publish does not copy them to live. To carry rows to live, use willo_execute_sql (Publish replays approved SQL) or repeat the write after publishing. With drafting off it runs on the LIVE backend. The result's [Backend: …] line says which. Willo's own tables and auth tables are refused.
Access
- Token: read + act, and editor access or higher on the business.
- Approval: Always. Every call raises a card a person approves on the dashboard.
- Secret scan: refused if the new content holds a value shaped like an API key or token.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
table | string | yes | Table name. |
rows | object[] | yes | Rows as {column: value} objects. |