Kinetic Reporting Database Upsert

Configurations

Name	Description	Sample
api_server	Kinetic Request CE API Web Application	http://server:port/kinetic
api_username	Name of user account that has permission to use the API
api_password	Password for the API user	*********
space_slug	Slug of the Space where the User will be created.
jdbc_database_id	The JDBC Id from the connection string for the database being used. ie. (oracle, sqlserver, postgresql, mysql).	sqlserver
jdbc_url_opts	Additional JDBC URL connection string options, such as ssl=true&sslmode=verify-full for Postgres.
host	IP address or hostname of the SQL reporting database server.
port	Port number the SQL server is listening on.
database_name	SQL database name used for storing CE submissions.
database_identifier_size	Max database identifier size. Not required to set for MSSQL, Oracle or PostgreSQL. Default for MSSQL is 128, Oracle 30, and PostgreSQL is 64.
user	Username used to authenticate to the SQL server. Must have table creation and modification rights.
password	Password for the SQL user account.	*********
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.
Space slug (info value override)
Updated at start time (ISO8601)
Updated at end time (ISO8601)
Submission page size
Task deferral token
Kapp slug (optional for narrow scope)	Kapp slug. Required if specifying specific form slugs to retrieve submissions from.
Form slugs (optional CSV for narrow scopep)	Form slugs (comma separated). Required if specifying specific form slugs to retrieve submissions from along with Kapp Slug parameter.

Results

Name	Description
Submission Database Id
Handler Error Message

Changelog

Update - v6 fieldKey hotfix (2024-12-10)

• Hotfix added to increase fieldKey column size to accomodate for GUIDs in v6 being the default entry of the field Kinetic Reporting DB Upsert V1 (2021-06-12)
• Initial version. See README for details.