ApprovalTemplateWorkflowById: Bouw7 Approval Template Workflow by ID
read only REST
- Catalog:
Bouw7 - Schema:
Approval - Label: Approval Template Workflow by ID
Returns a single approval template workflow based on the given ID, duplicate approvers are not filtered out! Returns a single approval template workflow based on the given ID.
Can only retrieve data.
Summary
Returns a single approval template workflow based on the given ID.
API Source
- Endpoint:
/approval-template/workflow/{id} - Operation:
get /approval-template/workflow/{id}
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 90 |
| Full scan rows per minute | 241,000 |
| Point query rows per minute | 666 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
id |
`` | |||
project |
`` | |||
remove |
`` |
Table Columns
The columns of the table ApprovalTemplateWorkflowById are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
approver1_ |
datetime |
itgen_bouw7_approver1_createdat | filters on the platform, writable, approver1. |
The creation time of the entity. | |
approver1_ |
varchar2 |
itgen_bouw7_approver1_createdby | filters on the platform, writable, approver1. |
The user that created the entity. | |
approver1_ |
int64 |
Approver 1 ID | filters on the platform, writable, approver1. |
ID of the approver. | |
approver1_ |
varchar2 |
itgen_bouw7_approver1_reference_firstname | filters on the platform, writable, approver1. |
First name of the employee. | |
approver1_ |
int64 |
itgen_bouw7_approver1_reference_id | filters on the platform, writable, approver1. |
ID of the employee. | |
approver1_ |
varchar2 |
itgen_bouw7_approver1_reference_lastname | filters on the platform, writable, approver1. |
Last name of the employee. | |
approver1_ |
int64 |
Approver 1 Type | filters on the platform, writable, approver1. |
Approver type. | |
approver1_ |
datetime |
itgen_bouw7_approver1_updatedat | filters on the platform, writable, approver1. |
The last updated time of the entity. | |
approver1_ |
varchar2 |
itgen_bouw7_approver1_updatedby | filters on the platform, writable, approver1. |
The user that last updated the entity. | |
approver2_ |
datetime |
itgen_bouw7_approver2_createdat | filters on the platform, writable, approver2. |
The creation time of the entity. | |
approver2_ |
varchar2 |
itgen_bouw7_approver2_createdby | filters on the platform, writable, approver2. |
The user that created the entity. | |
approver2_ |
int64 |
Approver 2 ID | filters on the platform, writable, approver2. |
ID of the approver. | |
approver2_ |
varchar2 |
itgen_bouw7_approver2_reference_firstname | filters on the platform, writable, approver2. |
First name of the employee. | |
approver2_ |
int64 |
itgen_bouw7_approver2_reference_id | filters on the platform, writable, approver2. |
ID of the employee. | |
approver2_ |
varchar2 |
itgen_bouw7_approver2_reference_lastname | filters on the platform, writable, approver2. |
Last name of the employee. | |
approver2_ |
int64 |
Approver 2 Type | filters on the platform, writable, approver2. |
Approver type. | |
approver2_ |
datetime |
itgen_bouw7_approver2_updatedat | filters on the platform, writable, approver2. |
The last updated time of the entity. | |
approver2_ |
varchar2 |
itgen_bouw7_approver2_updatedby | filters on the platform, writable, approver2. |
The user that last updated the entity. | |
approver3_ |
datetime |
itgen_bouw7_approver3_createdat | filters on the platform, writable, approver3. |
The creation time of the entity. | |
approver3_ |
varchar2 |
itgen_bouw7_approver3_createdby | filters on the platform, writable, approver3. |
The user that created the entity. | |
approver3_ |
int64 |
Approver 3 ID | filters on the platform, writable, approver3. |
ID of the approver. | |
approver3_ |
varchar2 |
itgen_bouw7_approver3_reference_firstname | filters on the platform, writable, approver3. |
First name of the employee. | |
approver3_ |
int64 |
itgen_bouw7_approver3_reference_id | filters on the platform, writable, approver3. |
ID of the employee. | |
approver3_ |
varchar2 |
itgen_bouw7_approver3_reference_lastname | filters on the platform, writable, approver3. |
Last name of the employee. | |
approver3_ |
int64 |
Approver 3 Type | filters on the platform, writable, approver3. |
Approver type. | |
approver3_ |
datetime |
itgen_bouw7_approver3_updatedat | filters on the platform, writable, approver3. |
The last updated time of the entity. | |
approver3_ |
varchar2 |
itgen_bouw7_approver3_updatedby | filters on the platform, writable, approver3. |
The user that last updated the entity. | |
approver4_ |
datetime |
itgen_bouw7_approver4_createdat | filters on the platform, writable, approver4. |
The creation time of the entity. | |
approver4_ |
varchar2 |
itgen_bouw7_approver4_createdby | filters on the platform, writable, approver4. |
The user that created the entity. | |
approver4_ |
int64 |
Approver 4 ID | filters on the platform, writable, approver4. |
ID of the approver. | |
approver4_ |
varchar2 |
itgen_bouw7_approver4_reference_firstname | filters on the platform, writable, approver4. |
First name of the employee. | |
approver4_ |
int64 |
itgen_bouw7_approver4_reference_id | filters on the platform, writable, approver4. |
ID of the employee. | |
approver4_ |
varchar2 |
itgen_bouw7_approver4_reference_lastname | filters on the platform, writable, approver4. |
Last name of the employee. | |
approver4_ |
int64 |
Approver 4 Type | filters on the platform, writable, approver4. |
Approver type. | |
approver4_ |
datetime |
itgen_bouw7_approver4_updatedat | filters on the platform, writable, approver4. |
The last updated time of the entity. | |
approver4_ |
varchar2 |
itgen_bouw7_approver4_updatedby | filters on the platform, writable, approver4. |
The user that last updated the entity. | |
approver5_ |
datetime |
itgen_bouw7_approver5_createdat | filters on the platform, writable, approver5. |
The creation time of the entity. | |
approver5_ |
varchar2 |
itgen_bouw7_approver5_createdby | filters on the platform, writable, approver5. |
The user that created the entity. | |
approver5_ |
int64 |
Approver 5 ID | filters on the platform, writable, approver5. |
ID of the approver. | |
approver5_ |
varchar2 |
itgen_bouw7_approver5_reference_firstname | filters on the platform, writable, approver5. |
First name of the employee. | |
approver5_ |
int64 |
itgen_bouw7_approver5_reference_id | filters on the platform, writable, approver5. |
ID of the employee. | |
approver5_ |
varchar2 |
itgen_bouw7_approver5_reference_lastname | filters on the platform, writable, approver5. |
Last name of the employee. | |
approver5_ |
int64 |
Approver 5 Type | filters on the platform, writable, approver5. |
Approver type. | |
approver5_ |
datetime |
itgen_bouw7_approver5_updatedat | filters on the platform, writable, approver5. |
The last updated time of the entity. | |
approver5_ |
varchar2 |
itgen_bouw7_approver5_updatedby | filters on the platform, writable, approver5. |
The user that last updated the entity. | |
approvers |
char |
Approvers | filters on the platform, writable, approvers |
||
created |
datetime |
Created at | filters on the platform, writable, created |
The creation time of the entity. | |
created |
varchar2 |
Created by | filters on the platform, writable, created |
The user that created the entity. | |
id |
int64 |
ID | filters on the platform, writable, id |
ID of the approval workflow. | |
is |
char |
Is Deduplicated | filters on the platform, writable, is |
Whether the criteria has been deduplicated. | |
is |
char |
Is Restricted | filters on the platform, writable, is |
Whether the criteria is restricted. | |
name |
varchar2 |
Name | filters on the platform, writable, name |
Name of the approval workflow. | |
updated |
datetime |
Updated At | filters on the platform, writable, updated |
The last updated time of the entity. | |
updated |
varchar2 |
Updated by | filters on the platform, writable, updated |
The user that last updated the entity. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: