Back to Kinetic Platform Integrations
Kinetic Request CE Submission Database Insert
Handler
·
Version 1
Kinetic Request CE Submission Database Insert
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 |
| enable_trace_logging | Enable trace 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.
Kinetic Request CE Submission DB Insert V1.4 (2022-07-03)
- KP-5616 fixed issues with limit field creation. Limited fields were being created on the kapp > form table but the fields were normal text not limited varchar 4000 fields.
Kinetic Request CE Submission DB Insert V1.5 (2022-08-15)
- KD8W-104 added enable debug logging info value. Updated the SQL logger to log to engine logs. Removed submission value logging.
Kinetic Request CE Submission DB Insert (2023-09-06)
- bug fixes to create kapp table if it doesn't exist
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