ApprovalWorkflows: Bouw7 Approval Workflows
read only REST
- Catalog:
Bouw7 - Schema:
Approval - Label: Approval Workflows
Returns a list of approval workflows for the organization of the current authenticated user. Use HQL to filter for specific items. Returns a list of approval workflows. Use HQL to filter for specific items.
Can only retrieve data.
Summary
Returns a list of approval workflows. Use HQL to filter for specific items.
API Source
- Endpoint:
/list/approval-template/workflows - Operation:
get /list/approval-template/workflows
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 90 |
| Full scan rows per minute | 12,000 |
| Point query rows per minute | 666 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
q |
`` | A Heimdall Query Language string |
Table Columns
The columns of the table ApprovalWorkflows 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_ |
int64 |
Approver 1 ID | filters on the platform, writable, approver1. |
The ID of the approver. | |
approver1_ |
varchar2 |
Approver 1 Reference | filters on the platform, writable, approver1. |
The full name of the referenced employee. | |
approver1_ |
int64 |
Approver 1 Type | filters on the platform, writable, approver1. |
The type of approver. 0 = Employee, 1 = Project executor, 2 = Project team member, 3 = Project leader, 4 = Free to pick | |
approver2_ |
int64 |
Approver 2 ID | filters on the platform, writable, approver2. |
The ID of the approver. | |
approver2_ |
varchar2 |
Approver 2 Reference | filters on the platform, writable, approver2. |
The full name of the referenced employee. | |
approver2_ |
int64 |
Approver 2 Type | filters on the platform, writable, approver2. |
The type of approver. 0 = Employee, 1 = Project executor, 2 = Project team member, 3 = Project leader, 4 = Free to pick | |
approver3_ |
int64 |
Approver 3 ID | filters on the platform, writable, approver3. |
The ID of the approver. | |
approver3_ |
varchar2 |
Approver 3 Reference | filters on the platform, writable, approver3. |
The full name of the referenced employee. | |
approver3_ |
int64 |
Approver 3 Type | filters on the platform, writable, approver3. |
The type of approver. 0 = Employee, 1 = Project executor, 2 = Project team member, 3 = Project leader, 4 = Free to pick | |
approver4_ |
int64 |
Approver 4 ID | filters on the platform, writable, approver4. |
The ID of the approver. | |
approver4_ |
varchar2 |
Approver 4 Reference | filters on the platform, writable, approver4. |
The full name of the referenced employee. | |
approver4_ |
int64 |
Approver 4 Type | filters on the platform, writable, approver4. |
The type of approver. 0 = Employee, 1 = Project executor, 2 = Project team member, 3 = Project leader, 4 = Free to pick | |
approver5_ |
int64 |
Approver 5 ID | filters on the platform, writable, approver5. |
The ID of the approver. | |
approver5_ |
varchar2 |
Approver 5 Reference | filters on the platform, writable, approver5. |
The full name of the referenced employee. | |
approver5_ |
int64 |
Approver 5 Type | filters on the platform, writable, approver5. |
The type of approver. 0 = Employee, 1 = Project executor, 2 = Project team member, 3 = Project leader, 4 = Free to pick | |
created |
datetime |
Created at | filters on the platform, writable, created |
The creation date of the object in ATOM/ISO-8601 format | |
created |
int64 |
Created by ID | filters on the platform, writable, created |
The ID of the user. | |
created |
varchar2 |
Created by User Name | filters on the platform, writable, created |
The username of the user. | |
id |
int64 |
ID | filters on the platform, writable, id |
The ID of this workflow. | |
is |
char |
Is Restricted | filters on the platform, writable, is |
Whether the workflow is restricted. | |
name |
varchar2 |
Name | filters on the platform, writable, name |
Name of this workflow. | |
updated |
datetime |
Updated At | filters on the platform, writable, updated |
The creation date of the object in ATOM/ISO-8601 format | |
updated |
int64 |
Updated by ID | filters on the platform, writable, updated |
The ID of the user. | |
updated |
varchar2 |
Updated by User Name | filters on the platform, writable, updated |
The username of the user. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: