Function

The gooAgent SQL Command activity allows to send SQL commands to a configured gooAgent. The SQL servers response, be it data or errors, will be transferred back to gooflow.

Input

All input fields can be populated via script or variable for this activity.

gooAgent	Select the desired gooAgent from a dropdown list.
SQL Statement	The SQL statement to be executed as a string.
Database Type	Choose between MS SQL Server, MySQL and Oracle SQL.
Timeout	Seconds until timeout is forced.
Retries	How many retries to gooAgent should attempt for a failed exeution before an error is thrown.

Output

Tables	Choose an object variable to store the resulting data if one or more table is returned.
Rows Affected	An integer variable to store the amount of affected rows is needed in the workflow.
Execution Time	Stores the execution time in a TimeSpan variable.
JSON Result	Choose an object variable to store the result in a JSON format.
Error Message	String variable to store error messages from the gooAgent.