Datasource Execute

Impure

Executes a SQL INSERT, UPDATE, or DELETE statement and returns the number of rows affected. If INSERT, returns generated key if available.

Pure Function

No

Execute Inputs

Execution

INPUT

Execution Input.

Execute Outputs

Complete

OUTPUT

Fires when the data is successfully inserted into the cube.

Data Inputs

Datasource

INPUT

Name of the datasource to use.

SQL Query

INPUT

The SQL INSERT, UPDATE, or DELETE statement to execute.

Parameters

INPUT

Optional list of parameters to substitute for ? placeholders.

Data Outputs

Rows Affected

OUTPUTinteger

Number of rows affected by the statement.

Multiple

Generated Key

OUTPUTany

Primary key generated by the INSERT statement, if available.

Multiple

Settings

Throw on SQL Error

BOOLEAN

If true, will throw an error if a SQL error occurs during query.

Default: true

Debug

STRING

Break on node when executing.

Default: No

Options:

NoBeforeInputsBeforeProcessingAfterProcessing