For the complete documentation index, see llms.txt. Any page on this site can be fetched as Markdown by appending .md to its URL.

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

FieldTypeRequiredDescription
Table
table
dynamicDropdownRequiredThe table to insert to.
Fields
fields
dynamicDropdownOptionalThe columns to insert data into. The values field must provide a value for each selected column.
Values
values
objectOptionalField-value pairs to insert into the row. Keys must match the selected field names.
Variables
variables
array of objectsOptionalSave variables from the data returned.
Timeout
timeout
numberOptionalNot 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.

On this page