SQL Node
Retrieve SQL query results in your Flow
Description

The SQL Node lets you run queries, transactions or stored procedures on MS-SQL Server.
Operation
Choose an Operation from the dropdown:
Connection
Select the database connection configured in the Project Dashboard, see Database Connections .
Context Store
The SQL Node executes the configured operation on the database. The query response from the database will be stored in the Context. Specify the store location here.
Run Query

Runs a single SQL query statement. Enter a valid SQL query in the Query field.
Run Transaction

Runs a transaction. Enter a valid SQL transaction query in the Query field. You do not need to add the "BEGIN TRANSACTION" and "COMMIT" fields, since this will be done implicitly. If you want to work with Try / catch blocks and do more advanced transactions with rollbacks, then you might want to use the Run Query instead
Run Stored Procedure

Runs a stored procedure. The stored procedure must exist in the database specified under Connection.
Stored Procedure Name
The name of the stored procedure
Inputs
Enter an array of input parameters of your stored procedure as defined in the database. You can forward parameters from the Context to the database, for example. Parameters must be specified in an array of objects that define the input parameter in the following format: {name,value,type}
Outputs
Enter an array of output parameters of your stored procedure as defined in the database. You can forward parameters from the database to the Context, for example. Parameters must be specified in an array of objects that define the output parameter in the following format: {name,value,type}
Updated over 3 years ago