---
title: "Projects (Bouw7)"
description: "Projects"
language: en
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/es/datamodels/exactonlinebouw/Bouw7.Project.Projects
original: https://documentation.invantive.eu/en/datamodels/exactonlinebouw/Bouw7.Project.Projects
updated: 2026-11-01T17:44:22Z
license: https://documentation.invantive.eu/es/
---

# Projects: Bouw7 Projects

`popular` `read only` `REST`

- Catalog: `Bouw7`
- Schema: `Project`
- Label: Projects

Returns a list of projects associated with the organization.
Returns a list of projects associated with the organization

Can only retrieve data.

## Summary

Returns a list of projects associated with the organization

## API Source

- Endpoint: `/list/projects`
- Operation: `get /list/projects`

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 192 |
| Full scan rows per minute | 320,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](https://heimdall.bouw7.nl/docs/query-language) string |

## Table Columns

The columns of the table `Projects` 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 |
|---|---|---|:---:|---|---|
| `additionalWork` | `varchar2` | Additional Work | [ ] | filters on the platform, writable, `additionalWork` | Additional work for the project. |
| `branch_id` | `int64` | Branch ID | [ ] | filters on the platform, writable, `branch.id` | The ID of the branch. |
| `branch_name` | `varchar2` | Branch Name | [ ] | filters on the platform, writable, `branch.name` | The name of the branch. |
| `caC100` | `varchar2` | C100 | [ ] | filters on the platform, writable, `caC100` |  |
| `caC101` | `varchar2` | C101 | [ ] | filters on the platform, writable, `caC101` |  |
| `caC102` | `varchar2` | C102 | [ ] | filters on the platform, writable, `caC102` |  |
| `caC15` | `varchar2` | C15 | [ ] | filters on the platform, writable, `caC15` |  |
| `caC16` | `varchar2` | C16 | [ ] | filters on the platform, writable, `caC16` |  |
| `caC17` | `varchar2` | C17 | [ ] | filters on the platform, writable, `caC17` |  |
| `caC18` | `varchar2` | C18 | [ ] | filters on the platform, writable, `caC18` |  |
| `caC19` | `varchar2` | C19 | [ ] | filters on the platform, writable, `caC19` |  |
| `caC20` | `varchar2` | C20 | [ ] | filters on the platform, writable, `caC20` |  |
| `caC21` | `varchar2` | C21 | [ ] | filters on the platform, writable, `caC21` |  |
| `caC22` | `varchar2` | C22 | [ ] | filters on the platform, writable, `caC22` |  |
| `caC23` | `varchar2` | C23 | [ ] | filters on the platform, writable, `caC23` |  |
| `caC24` | `varchar2` | C24 | [ ] | filters on the platform, writable, `caC24` |  |
| `caC25` | `varchar2` | C25 | [ ] | filters on the platform, writable, `caC25` |  |
| `caC26` | `varchar2` | C26 | [ ] | filters on the platform, writable, `caC26` |  |
| `caC27` | `varchar2` | C27 | [ ] | filters on the platform, writable, `caC27` |  |
| `caC28` | `varchar2` | C28 | [ ] | filters on the platform, writable, `caC28` |  |
| `caC29` | `varchar2` | C29 | [ ] | filters on the platform, writable, `caC29` |  |
| `caC30` | `varchar2` | C30 | [ ] | filters on the platform, writable, `caC30` |  |
| `caC31` | `varchar2` | C31 | [ ] | filters on the platform, writable, `caC31` |  |
| `caC32` | `varchar2` | C32 | [ ] | filters on the platform, writable, `caC32` |  |
| `caC33` | `varchar2` | C33 | [ ] | filters on the platform, writable, `caC33` |  |
| `caC34` | `varchar2` | C34 | [ ] | filters on the platform, writable, `caC34` |  |
| `caC35` | `varchar2` | C35 | [ ] | filters on the platform, writable, `caC35` |  |
| `caC36` | `varchar2` | C36 | [ ] | filters on the platform, writable, `caC36` |  |
| `caC37` | `varchar2` | C37 | [ ] | filters on the platform, writable, `caC37` |  |
| `caC38` | `varchar2` | C38 | [ ] | filters on the platform, writable, `caC38` |  |
| `caC39` | `varchar2` | C39 | [ ] | filters on the platform, writable, `caC39` |  |
| `caC40` | `varchar2` | C40 | [ ] | filters on the platform, writable, `caC40` |  |
| `caC41` | `varchar2` | C41 | [ ] | filters on the platform, writable, `caC41` |  |
| `caC42` | `varchar2` | C42 | [ ] | filters on the platform, writable, `caC42` |  |
| `caC43` | `varchar2` | C43 | [ ] | filters on the platform, writable, `caC43` |  |
| `caC44` | `varchar2` | C44 | [ ] | filters on the platform, writable, `caC44` |  |
| `caC45` | `varchar2` | C45 | [ ] | filters on the platform, writable, `caC45` |  |
| `caC46` | `varchar2` | C46 | [ ] | filters on the platform, writable, `caC46` |  |
| `caC47` | `varchar2` | C47 | [ ] | filters on the platform, writable, `caC47` |  |
| `caC48` | `varchar2` | C48 | [ ] | filters on the platform, writable, `caC48` |  |
| `caC49` | `varchar2` | C49 | [ ] | filters on the platform, writable, `caC49` |  |
| `caC50` | `varchar2` | C50 | [ ] | filters on the platform, writable, `caC50` |  |
| `caC51` | `varchar2` | C51 | [ ] | filters on the platform, writable, `caC51` |  |
| `caC52` | `varchar2` | C52 | [ ] | filters on the platform, writable, `caC52` |  |
| `caC53` | `varchar2` | C53 | [ ] | filters on the platform, writable, `caC53` |  |
| `caC54` | `varchar2` | C54 | [ ] | filters on the platform, writable, `caC54` |  |
| `caC55` | `varchar2` | C55 | [ ] | filters on the platform, writable, `caC55` |  |
| `caC56` | `varchar2` | C56 | [ ] | filters on the platform, writable, `caC56` |  |
| `caC57` | `varchar2` | C57 | [ ] | filters on the platform, writable, `caC57` |  |
| `caC58` | `varchar2` | C58 | [ ] | filters on the platform, writable, `caC58` |  |
| `caC59` | `varchar2` | C59 | [ ] | filters on the platform, writable, `caC59` |  |
| `caC60` | `varchar2` | C60 | [ ] | filters on the platform, writable, `caC60` |  |
| `caC61` | `varchar2` | C61 | [ ] | filters on the platform, writable, `caC61` |  |
| `caC62` | `varchar2` | C62 | [ ] | filters on the platform, writable, `caC62` |  |
| `caC63` | `varchar2` | C63 | [ ] | filters on the platform, writable, `caC63` |  |
| `caC64` | `varchar2` | C64 | [ ] | filters on the platform, writable, `caC64` |  |
| `caC65` | `varchar2` | C65 | [ ] | filters on the platform, writable, `caC65` |  |
| `caC66` | `varchar2` | C66 | [ ] | filters on the platform, writable, `caC66` |  |
| `caC67` | `varchar2` | C67 | [ ] | filters on the platform, writable, `caC67` |  |
| `caC68` | `varchar2` | C68 | [ ] | filters on the platform, writable, `caC68` |  |
| `caC69` | `varchar2` | C69 | [ ] | filters on the platform, writable, `caC69` |  |
| `caC70` | `varchar2` | C70 | [ ] | filters on the platform, writable, `caC70` |  |
| `caC71` | `varchar2` | C71 | [ ] | filters on the platform, writable, `caC71` |  |
| `caC72` | `varchar2` | C72 | [ ] | filters on the platform, writable, `caC72` |  |
| `caC73` | `varchar2` | C73 | [ ] | filters on the platform, writable, `caC73` |  |
| `caC74` | `varchar2` | C74 | [ ] | filters on the platform, writable, `caC74` |  |
| `caC75` | `varchar2` | C75 | [ ] | filters on the platform, writable, `caC75` |  |
| `caC76` | `varchar2` | C76 | [ ] | filters on the platform, writable, `caC76` |  |
| `caC77` | `varchar2` | C77 | [ ] | filters on the platform, writable, `caC77` |  |
| `caC78` | `varchar2` | C78 | [ ] | filters on the platform, writable, `caC78` |  |
| `caC79` | `varchar2` | C79 | [ ] | filters on the platform, writable, `caC79` |  |
| `caC80` | `varchar2` | C80 | [ ] | filters on the platform, writable, `caC80` |  |
| `caC81` | `varchar2` | C81 | [ ] | filters on the platform, writable, `caC81` |  |
| `caC82` | `varchar2` | C82 | [ ] | filters on the platform, writable, `caC82` |  |
| `caC83` | `varchar2` | C83 | [ ] | filters on the platform, writable, `caC83` |  |
| `caC84` | `varchar2` | C84 | [ ] | filters on the platform, writable, `caC84` |  |
| `caC85` | `varchar2` | C85 | [ ] | filters on the platform, writable, `caC85` |  |
| `caC86` | `varchar2` | C86 | [ ] | filters on the platform, writable, `caC86` |  |
| `caC87` | `varchar2` | C87 | [ ] | filters on the platform, writable, `caC87` |  |
| `caC88` | `varchar2` | C88 | [ ] | filters on the platform, writable, `caC88` |  |
| `caC89` | `varchar2` | C89 | [ ] | filters on the platform, writable, `caC89` |  |
| `caC90` | `varchar2` | C90 | [ ] | filters on the platform, writable, `caC90` |  |
| `caC91` | `varchar2` | C91 | [ ] | filters on the platform, writable, `caC91` |  |
| `caC92` | `varchar2` | C92 | [ ] | filters on the platform, writable, `caC92` |  |
| `caC93` | `varchar2` | C93 | [ ] | filters on the platform, writable, `caC93` |  |
| `caC94` | `varchar2` | C94 | [ ] | filters on the platform, writable, `caC94` |  |
| `caC95` | `varchar2` | C95 | [ ] | filters on the platform, writable, `caC95` |  |
| `caC96` | `varchar2` | C96 | [ ] | filters on the platform, writable, `caC96` |  |
| `caC97` | `varchar2` | C97 | [ ] | filters on the platform, writable, `caC97` |  |
| `caC98` | `varchar2` | C98 | [ ] | filters on the platform, writable, `caC98` |  |
| `caC99` | `varchar2` | C99 | [ ] | filters on the platform, writable, `caC99` |  |
| `caCaProjectCheckbox` | `char` | CA Project Checkbox | [ ] | filters on the platform, writable, `caCaProjectCheckbox` |  |
| `caCaProjectContact` | `varchar2` | CA Project Contact | [ ] | filters on the platform, writable, `caCaProjectContact` |  |
| `caCaProjectDatum` | `datetime` | CA Project Datum | [ ] | filters on the platform, writable, `caCaProjectDatum` |  |
| `caCaProjectDatumtijd` | `datetime` | CA Project Datumtijd | [ ] | filters on the platform, writable, `caCaProjectDatumtijd` |  |
| `caCaProjectDropdown` | `varchar2` | CA Project Dropdown | [ ] | filters on the platform, writable, `caCaProjectDropdown` |  |
| `caCaProjectMedewerker` | `varchar2` | CA Project Medewerker | [ ] | filters on the platform, writable, `caCaProjectMedewerker` |  |
| `caCaProjectTekstgebied` | `varchar2` | CA Project Tekstgebied | [ ] | filters on the platform, writable, `caCaProjectTekstgebied` |  |
| `caCaProjectTekstveld` | `varchar2` | CA Project Tekstveld | [ ] | filters on the platform, writable, `caCaProjectTekstveld` |  |
| `category_code` | `varchar2` | Category Code | [ ] | filters on the platform, writable, `category.code` | The code for the category. |
| `category_id` | `int64` | Category ID | [ ] | filters on the platform, writable, `category.id` | The ID of the category. |
| `category_name` | `varchar2` | Category Name | [ ] | filters on the platform, writable, `category.name` | The name of the category. |
| `city` | `varchar2` | City | [ ] | filters on the platform, writable, `city` | The city of the project. |
| `contactPerson_emailAddress` | `varchar2` | Contact Person Email Address | [ ] | filters on the platform, writable, `contactPerson.emailAddress` | The email address of the contact. |
| `contactPerson_id` | `int64` | Contact Person ID | [ ] | filters on the platform, writable, `contactPerson.id` | The ID of the contact. |
| `contactPerson_name` | `varchar2` | itgen_bouw7_contactperson_name | [ ] | filters on the platform, writable, `contactPerson.name` | The name of this contact. |
| `contactPerson_type` | `varchar2` | itgen_bouw7_contactperson_type | [ ] | filters on the platform, writable, `contactPerson.type` | The type of this contact. |
| `contactPerson_typeId` | `int64` | itgen_bouw7_contactperson_typeid | [ ] | filters on the platform, writable, `contactPerson.typeId` | The type ID of this contact. |
| `contact_emailAddress` | `varchar2` | Contact Email Address | [ ] | filters on the platform, writable, `contact.emailAddress` | The email address of the contact. |
| `contact_id` | `int64` | Contact ID | [ ] | filters on the platform, writable, `contact.id` | The ID of the contact. |
| `contact_name` | `varchar2` | Contact Name | [ ] | filters on the platform, writable, `contact.name` | The name of this contact. |
| `contact_type` | `varchar2` | Contact Type | [ ] | filters on the platform, writable, `contact.type` | The type of this contact. |
| `contact_typeId` | `int64` | Contact Type ID | [ ] | filters on the platform, writable, `contact.typeId` | The type ID of this contact. |
| `countryCode` | `varchar2` | Country Code | [ ] | filters on the platform, writable, `countryCode` | An ISO 3166-2 representation of the country. |
| `createdAt` | `datetime` | Created at | [ ] | filters on the platform, writable, `createdAt` | The creation date of the object in ATOM/ISO-8601 format |
| `createdBy_id` | `int64` | Created by ID | [ ] | filters on the platform, writable, `createdBy.id` | The ID of the user. |
| `createdBy_username` | `varchar2` | Created by User Name | [ ] | filters on the platform, writable, `createdBy.username` | The username of the user. |
| `deliveryDate` | `datetime` | Delivery Date | [ ] | filters on the platform, writable, `deliveryDate` | Delivery date for the project. |
| `division_description` | `varchar2` | Division Description | [ ] | filters on the platform, writable, `division.description` | The description of the division. |
| `division_exactDivisionId` | `varchar2` | Division Exact Division ID | [ ] | filters on the platform, writable, `division.exactDivisionId` | The division ID of an Exact Online environment. |
| `division_glAccountCode` | `varchar2` | Division General Ledger Account Code | [ ] | filters on the platform, writable, `division.glAccountCode` | A default general ledger account code to use for sales related items. |
| `division_glAccountCodePurchase` | `varchar2` | Division General Ledger Account Code Purchase | [ ] | filters on the platform, writable, `division.glAccountCodePurchase` | A default general ledger account code to use for purchase related items. |
| `division_id` | `int64` | Division ID | [ ] | filters on the platform, writable, `division.id` | The ID of the division. |
| `division_journalCode` | `varchar2` | Division Journal Code | [ ] | filters on the platform, writable, `division.journalCode` | A default journal code to use for sales related items. |
| `division_journalCodePurchase` | `varchar2` | Division Journal Code Purchase | [ ] | filters on the platform, writable, `division.journalCodePurchase` | A default journal code to use for purchase related items. |
| `endDate` | `datetime` | End Date | [ ] | filters on the platform, writable, `endDate` | End date for the project. |
| `executor_departmentId` | `int64` | Executor Department ID | [ ] | filters on the platform, writable, `executor.departmentId` | The ID of the department this employee is enrolled in. |
| `executor_exactSalaryFrequency` | `int64` | Executor Exact Salary Frequency | [ ] | filters on the platform, writable, `executor.exactSalaryFrequency` | The exact salary frequency of this employee. |
| `executor_firstName` | `varchar2` | Executor First Name | [ ] | filters on the platform, writable, `executor.firstName` | The given name of this employee. |
| `executor_id` | `int64` | Executor ID | [ ] | filters on the platform, writable, `executor.id` | The ID of the employee. |
| `executor_lastName` | `varchar2` | Executor Last Name | [ ] | filters on the platform, writable, `executor.lastName` | The family name of this employee. |
| `fixedPrice` | `varchar2` | Fixed Price | [ ] | filters on the platform, writable, `fixedPrice` | The fixed price of the project. |
| `fullProjectNumber` | `varchar2` | Full Project Number | [ ] | filters on the platform, writable, `fullProjectNumber` | The full project number including year. |
| `houseNumber` | `varchar2` | House Number | [ ] | filters on the platform, writable, `houseNumber` | The house number for the project. |
| `id` | `int64` | ID | [ ] | filters on the platform, writable, `id` | The ID of the project. |
| `information` | `varchar2` | Information | [ ] | filters on the platform, writable, `information` | The information about the project. |
| `name` | `varchar2` | Name | [ ] | filters on the platform, writable, `name` | The name of the project. |
| `parentId` | `int64` | Parent ID | [ ] | filters on the platform, writable, `parentId` | The ID of the parent Project if this Project is a Subproject. |
| `projectLeader_departmentId` | `int64` | Project Leader Department ID | [ ] | filters on the platform, writable, `projectLeader.departmentId` | The ID of the department this employee is enrolled in. |
| `projectLeader_exactSalaryFrequency` | `int64` | Project Leader Exact Salary Frequency | [ ] | filters on the platform, writable, `projectLeader.exactSalaryFrequency` | The exact salary frequency of this employee. |
| `projectLeader_firstName` | `varchar2` | Project Leader First Name | [ ] | filters on the platform, writable, `projectLeader.firstName` | The given name of this employee. |
| `projectLeader_id` | `int64` | Project Leader ID | [ ] | filters on the platform, writable, `projectLeader.id` | The ID of the employee. |
| `projectLeader_lastName` | `varchar2` | Project Leader Last Name | [ ] | filters on the platform, writable, `projectLeader.lastName` | The family name of this employee. |
| `projectNumber` | `varchar2` | Project Number | [ ] | filters on the platform, writable, `projectNumber` | The project number. |
| `propertyAsset_id` | `int64` | Property Asset ID | [ ] | filters on the platform, writable, `propertyAsset.id` | The ID of the property asset. |
| `propertyAsset_name` | `varchar2` | Property Asset Name | [ ] | filters on the platform, writable, `propertyAsset.name` | The name of the property asset. |
| `reference` | `varchar2` | Reference | [ ] | filters on the platform, writable, `reference` | The reference of the project. |
| `startDate` | `datetime` | Start Date | [ ] | filters on the platform, writable, `startDate` | Start date for the project. |
| `status_closesPlanning` | `char` | Status Closes Planning | [ ] | filters on the platform, writable, `status.closesPlanning` | Whether the project planning is closed. |
| `status_closesProject` | `char` | Status Closes Project | [ ] | filters on the platform, writable, `status.closesProject` | Whether this status denotes a closed-state of the project. |
| `status_id` | `int64` | Status ID | [ ] | filters on the platform, writable, `status.id` | The ID of the status. |
| `status_invoicesProject` | `char` | Status Invoices Project | [ ] | filters on the platform, writable, `status.invoicesProject` | Whether this status denotes an invoiced-state of the project. |
| `status_name` | `varchar2` | Status Name | [ ] | filters on the platform, writable, `status.name` | The name of the status. |
| `status_plansProject` | `char` | Status Plans Project | [ ] | filters on the platform, writable, `status.plansProject` | Whether this status denotes a planned-state of the project. |
| `streetName` | `varchar2` | Street Name | [ ] | filters on the platform, writable, `streetName` | The street name for the project. |
| `updatedAt` | `datetime` | Updated At | [ ] | filters on the platform, writable, `updatedAt` | The creation date of the object in ATOM/ISO-8601 format |
| `updatedBy_id` | `int64` | Updated by ID | [ ] | filters on the platform, writable, `updatedBy.id` | The ID of the user. |
| `updatedBy_username` | `varchar2` | Updated by User Name | [ ] | filters on the platform, writable, `updatedBy.username` | The username of the user. |
| `workPlanner_departmentId` | `int64` | Work Planner Department ID | [ ] | filters on the platform, writable, `workPlanner.departmentId` | The ID of the department this employee is enrolled in. |
| `workPlanner_exactSalaryFrequency` | `int64` | Work Planner Exact Salary Frequency | [ ] | filters on the platform, writable, `workPlanner.exactSalaryFrequency` | The exact salary frequency of this employee. |
| `workPlanner_firstName` | `varchar2` | Work Planner First Name | [ ] | filters on the platform, writable, `workPlanner.firstName` | The given name of this employee. |
| `workPlanner_id` | `int64` | Work Planner ID | [ ] | filters on the platform, writable, `workPlanner.id` | The ID of the employee. |
| `workPlanner_lastName` | `varchar2` | Work Planner Last Name | [ ] | filters on the platform, writable, `workPlanner.lastName` | The family name of this employee. |
| `zipCode` | `varchar2` | ZIP Code | [ ] | filters on the platform, writable, `zipCode` | The zip code for the project. |

## Sample Queries

```sql
--
-- Retrieve list of all Bouw7 projects.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/bouw7-data-model/webhelp/bouw7-connector-project-projects.html
--
select *
from   Bouw7.Project.Projects@bow
limit  100
```



## Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador:

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