SQL Generic Command

Configurations

Name	Description	Sample
database_server	JDBC connection that specifies the database location.
database_port
database_password	The password of the user that this handler will use to connect to the database.	*********
database_username	The username of the user that this handler will use to connect to the database.
kinetic_api_location	API Location (https://acme.kinops.io/app/api/v1).
kinetic_api_username	The username for impersonated user.
kinetic_api_password	The impersonated user's password.	*********
space_form	The form slug for the space form where the query template is saved.
enable_debug_logging	Enable debug logging if the value is set to 'Yes'.	No

Parameters

Name	Description	Sample
Error Handling	Determine what to return if an error is encountered.
Database	Database to Access for example sqlserver, oracle or postgresql.
Database Name	Database Name
SQL Action	SQL Action Type. Use fetch for a SELECT statement or run for an UPDATE query.
Template Name	A query to search the Kinetic Form to find the saved procedure.
Query Values	A JSON object used to do variable binding with the saved procedure.

Results

Name	Description
Result
Handler Error Message