SQL Generic Command

Configurations

Name	Description	Sample
database_server	JDBC connection that specifies the database location.
database_port
encrypt	Encrypt connection
integrated_security	Integrated Security will leverage Windows Authentication and ignore any username entered
trust_server_cert_ssl_require	Trust Server Certificate flag
database_username	The username of the user that this handler will use to connect to the database.
database_password	The password 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.	*********
kapp_slug	The kapp slug where the form that holds the query templates is located.
kapp_form_slug	The form slug for the form where query templates are 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