Back to Kinetic Platform Integrations
Handler · Version 1

Kinetic Request CE Submission Database Insert

Download GitHub

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 Space slug of the submission.
Kapp Slug Kapp slug of the submission. Needed for delete updates
Form Slug Form slug of the submission. Needed for delete updates
Datastore Submission? Is this a datastore submission?
Submission ID The submission id to store in the relational database.
Submission deletion timestamp. If set to a timestamp, the c_deletedAt database column will be set.
Results
Name Description
Submission Database Id
Handler Error Message
Changelog

Kinetic Request CE Submission DB Insert V1 (2017-04-12)

  • Initial version. See README for details.

Kinetic Request CE Submission DB Insert V1.1 (2018-06-05)

  • API Server Info Value changed to allow ${space} in the url for subdomain support (ie. https://${space}.localhost:8080/kinetic)

Kinetic Request CE Submission DB Insert V1.2 (2020-10-29)

  • Fixed bug for datastore submission deletions not working.
  • Added info value for providing custom JDBC connection options

Kinetic Request CE Submission DB Insert V1.3 (2021-03-10)

  • Fixed bug submissions not getting updated in the database.

Kinetic Request CE Submission DB Insert V1.4 (2022-04-01)

  • PER-268 fixed unique key constraint bug.
Download GitHub

On This Page

Looking for a workflow engine? Learn more about the Kinetic Data Enterprise Workflow Platform. Check it out
Return to Top