SharpenDB INSERTDataSharpensharpenDbInsert· Version 1.0.0
Run an INSERT query on a table in SharpenDB.
Adds a new row to a SharpenDB table. Choose the table and set each field's value — values can reference $(name) variables to store data gathered during the run. Any data returned by the insert can be captured into variables by JSONPath. The flow takes default when the insert succeeds. A query SharpenDB does not answer within 20 seconds takes timeout, or fallback when timeout is not wired. The node's Timeout field is not applied: it does not change that 20-second limit.
Integration required
Connect the Sharpen integration before using this node.
Fields
| Field | Type | Required | Description |
|---|---|---|---|
Tabletable | dynamicDropdown | Required | The table to insert to. |
Fieldsfields | dynamicDropdown | Optional | The columns to insert data into. The values field must provide a value for each selected column. |
Valuesvalues | object | Optional | Field-value pairs to insert into the row. Keys must match the selected field names. |
Variablesvariables | array of objects | Optional | Save variables from the data returned. |
Timeouttimeout | number | Optional | Not applied yet: SharpenDB queries always wait up to 20 seconds, whatever this is set to. |
Exits
defaulttimeout
System exits (auto-injected, hidden when unwired): invalidInput, fallback.