---
title: "ApprovalTemplateWorkflowById (Bouw7)"
description: "Approval Template Workflow by ID"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/exactonlinebouw/Bouw7.Approval.ApprovalTemplateWorkflowById
original: https://documentation.invantive.eu/en/datamodels/exactonlinebouw/Bouw7.Approval.ApprovalTemplateWorkflowById
updated: 2026-11-01T17:44:22Z
license: https://documentation.invantive.eu/en/
---

# 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` | `` | [x] |  |  |
| `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:

- [Bouw7](/en/release-notes/drivers?driver=bouw7)

