invantive documentation
Invantive Support ForumsLog In / Sign Up

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 ``
projectId ``
removeDuplicates ``

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_createdAt datetime itgen_bouw7_approver1_createdat filters on the platform, writable, approver1.createdAt The creation time of the entity.
approver1_createdBy varchar2 itgen_bouw7_approver1_createdby filters on the platform, writable, approver1.createdBy The user that created the entity.
approver1_id int64 Approver 1 ID filters on the platform, writable, approver1.id ID of the approver.
approver1_reference_firstName varchar2 itgen_bouw7_approver1_reference_firstname filters on the platform, writable, approver1.reference.firstName First name of the employee.
approver1_reference_id int64 itgen_bouw7_approver1_reference_id filters on the platform, writable, approver1.reference.id ID of the employee.
approver1_reference_lastName varchar2 itgen_bouw7_approver1_reference_lastname filters on the platform, writable, approver1.reference.lastName Last name of the employee.
approver1_type int64 Approver 1 Type filters on the platform, writable, approver1.type Approver type.
approver1_updatedAt datetime itgen_bouw7_approver1_updatedat filters on the platform, writable, approver1.updatedAt The last updated time of the entity.
approver1_updatedBy varchar2 itgen_bouw7_approver1_updatedby filters on the platform, writable, approver1.updatedBy The user that last updated the entity.
approver2_createdAt datetime itgen_bouw7_approver2_createdat filters on the platform, writable, approver2.createdAt The creation time of the entity.
approver2_createdBy varchar2 itgen_bouw7_approver2_createdby filters on the platform, writable, approver2.createdBy The user that created the entity.
approver2_id int64 Approver 2 ID filters on the platform, writable, approver2.id ID of the approver.
approver2_reference_firstName varchar2 itgen_bouw7_approver2_reference_firstname filters on the platform, writable, approver2.reference.firstName First name of the employee.
approver2_reference_id int64 itgen_bouw7_approver2_reference_id filters on the platform, writable, approver2.reference.id ID of the employee.
approver2_reference_lastName varchar2 itgen_bouw7_approver2_reference_lastname filters on the platform, writable, approver2.reference.lastName Last name of the employee.
approver2_type int64 Approver 2 Type filters on the platform, writable, approver2.type Approver type.
approver2_updatedAt datetime itgen_bouw7_approver2_updatedat filters on the platform, writable, approver2.updatedAt The last updated time of the entity.
approver2_updatedBy varchar2 itgen_bouw7_approver2_updatedby filters on the platform, writable, approver2.updatedBy The user that last updated the entity.
approver3_createdAt datetime itgen_bouw7_approver3_createdat filters on the platform, writable, approver3.createdAt The creation time of the entity.
approver3_createdBy varchar2 itgen_bouw7_approver3_createdby filters on the platform, writable, approver3.createdBy The user that created the entity.
approver3_id int64 Approver 3 ID filters on the platform, writable, approver3.id ID of the approver.
approver3_reference_firstName varchar2 itgen_bouw7_approver3_reference_firstname filters on the platform, writable, approver3.reference.firstName First name of the employee.
approver3_reference_id int64 itgen_bouw7_approver3_reference_id filters on the platform, writable, approver3.reference.id ID of the employee.
approver3_reference_lastName varchar2 itgen_bouw7_approver3_reference_lastname filters on the platform, writable, approver3.reference.lastName Last name of the employee.
approver3_type int64 Approver 3 Type filters on the platform, writable, approver3.type Approver type.
approver3_updatedAt datetime itgen_bouw7_approver3_updatedat filters on the platform, writable, approver3.updatedAt The last updated time of the entity.
approver3_updatedBy varchar2 itgen_bouw7_approver3_updatedby filters on the platform, writable, approver3.updatedBy The user that last updated the entity.
approver4_createdAt datetime itgen_bouw7_approver4_createdat filters on the platform, writable, approver4.createdAt The creation time of the entity.
approver4_createdBy varchar2 itgen_bouw7_approver4_createdby filters on the platform, writable, approver4.createdBy The user that created the entity.
approver4_id int64 Approver 4 ID filters on the platform, writable, approver4.id ID of the approver.
approver4_reference_firstName varchar2 itgen_bouw7_approver4_reference_firstname filters on the platform, writable, approver4.reference.firstName First name of the employee.
approver4_reference_id int64 itgen_bouw7_approver4_reference_id filters on the platform, writable, approver4.reference.id ID of the employee.
approver4_reference_lastName varchar2 itgen_bouw7_approver4_reference_lastname filters on the platform, writable, approver4.reference.lastName Last name of the employee.
approver4_type int64 Approver 4 Type filters on the platform, writable, approver4.type Approver type.
approver4_updatedAt datetime itgen_bouw7_approver4_updatedat filters on the platform, writable, approver4.updatedAt The last updated time of the entity.
approver4_updatedBy varchar2 itgen_bouw7_approver4_updatedby filters on the platform, writable, approver4.updatedBy The user that last updated the entity.
approver5_createdAt datetime itgen_bouw7_approver5_createdat filters on the platform, writable, approver5.createdAt The creation time of the entity.
approver5_createdBy varchar2 itgen_bouw7_approver5_createdby filters on the platform, writable, approver5.createdBy The user that created the entity.
approver5_id int64 Approver 5 ID filters on the platform, writable, approver5.id ID of the approver.
approver5_reference_firstName varchar2 itgen_bouw7_approver5_reference_firstname filters on the platform, writable, approver5.reference.firstName First name of the employee.
approver5_reference_id int64 itgen_bouw7_approver5_reference_id filters on the platform, writable, approver5.reference.id ID of the employee.
approver5_reference_lastName varchar2 itgen_bouw7_approver5_reference_lastname filters on the platform, writable, approver5.reference.lastName Last name of the employee.
approver5_type int64 Approver 5 Type filters on the platform, writable, approver5.type Approver type.
approver5_updatedAt datetime itgen_bouw7_approver5_updatedat filters on the platform, writable, approver5.updatedAt The last updated time of the entity.
approver5_updatedBy varchar2 itgen_bouw7_approver5_updatedby filters on the platform, writable, approver5.updatedBy The user that last updated the entity.
approvers char Approvers filters on the platform, writable, approvers
createdAt datetime Created at filters on the platform, writable, createdAt The creation time of the entity.
createdBy varchar2 Created by filters on the platform, writable, createdBy The user that created the entity.
id int64 ID filters on the platform, writable, id ID of the approval workflow.
isDeduplicated char Is Deduplicated filters on the platform, writable, isDeduplicated Whether the criteria has been deduplicated.
isRestricted char Is Restricted filters on the platform, writable, isRestricted Whether the criteria is restricted.
name varchar2(255) Name filters on the platform, writable, name Name of the approval workflow.
updatedAt datetime Updated At filters on the platform, writable, updatedAt The last updated time of the entity.
updatedBy varchar2 Updated by filters on the platform, writable, updatedBy The user that last updated the entity.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: