---
title: "ProjectFileDepartmentsByProjectId (Bouw7)"
description: "Project File Departments by Project ID"
language: fr
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/fr/datamodels/exactonlinebouw/Bouw7.Project.ProjectFileDepartmentsByProjectId
original: https://documentation.invantive.eu/en/datamodels/exactonlinebouw/Bouw7.Project.ProjectFileDepartmentsByProjectId
updated: 2026-11-16T13:15:24Z
license: https://documentation.invantive.eu/fr/
---

# ProjectFileDepartmentsByProjectId: Bouw7 Project File Departments by Project ID

`read only` `REST`

- Catalogue : `Bouw7`
- Schéma : `Project`
- Label: Project File Departments by Project ID

Returns a project file associated with the given id. Returns a project file associated with the given id.

Permet uniquement de récupérer des données.

## Résumé

Returns a project file associated with the given id.

## Source de l'API

- Point de terminaison : `/project/file/{projectFile}`
- Opération : `get /project/file/{projectFile}`

## Caractéristiques de performance

| Characteristic | Value |
|---|---:|
| Latence moyenne d'accès (ms) | 90 |
| Nombre de lignes par minute en mode de balayage complet | 241,000 |
| Nombre de lignes de requêtes ponctuelles par minute | 666 |

Le résultat peut être mis en cache côté client.

## Paramètres

| Name | Type de données | Required | Default | Documentation |
|---|---|:---:|---|---|
| `projectFile` | `` | [x] |  | Identifiant du projet |

## Colonnes de table

Les colonnes de la table `ProjectFileDepartmentsByProjectId` sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `contact_contactType_id` | `int64` | Contact - Type de contact - ID | [ ] | filters on the platform, writable, `::ancestor.contact.contactType.id` | The ID of contact type. |
| `contact_contactType_name` | `varchar2` | Contact Type de contact Nom | [ ] | filters on the platform, writable, `::ancestor.contact.contactType.name` | The name of contact type. |
| `contact_email` | `varchar2` | Email du contact | [ ] | filters on the platform, writable, `::ancestor.contact.email` | The email address. |
| `contact_id` | `int64` | ID de contact | [ ] | filters on the platform, writable, `::ancestor.contact.id` | ID of contact. |
| `contact_isVatShifted` | `char` | Contact : la TVA est-elle répercutée ? | [ ] | filters on the platform, writable, `::ancestor.contact.isVatShifted` | Whether VAT is shifted for the contact. |
| `contact_name` | `varchar2` | Nom du Contact | [ ] | filters on the platform, writable, `::ancestor.contact.name` | Name of contact. |
| `contact_phoneNumber` | `varchar2` | Numéro de téléphone | [ ] | filters on the platform, writable, `::ancestor.contact.phoneNumber` | The phone number of the contact. |
| `createdAt` | `datetime` | Créé le | [ ] | filters on the platform, writable, `::ancestor.createdAt` | The creation time of the entity. |
| `createdBy` | `varchar2` | Crée par | [ ] | filters on the platform, writable, `::ancestor.createdBy` | The user that created the entity. |
| `file_createdAt` | `datetime` | Fichier créé le | [ ] | filters on the platform, writable, `::ancestor.file.createdAt` | The creation time of the entity. |
| `file_createdBy` | `varchar2` | Fichier créé par | [ ] | filters on the platform, writable, `::ancestor.file.createdBy` | The user that created the entity. |
| `file_extension` | `varchar2` | Extension de fichier | [ ] | filters on the platform, writable, `::ancestor.file.extension` | The extension of the file. |
| `file_id` | `int64` | ID de fichier | [ ] | filters on the platform, writable, `::ancestor.file.id` | The ID of this file |
| `file_modelId` | `int64` | ID du modèle de fichier | [ ] | filters on the platform, writable, `::ancestor.file.modelId` | The ID of the associated type. |
| `file_modelType` | `varchar2` | Type de modèle de fichier | [ ] | filters on the platform, writable, `::ancestor.file.modelType` | The category of the file. |
| `file_name` | `varchar2` | Nom de fichier | [ ] | filters on the platform, writable, `::ancestor.file.name` | The public name of the file. |
| `file_secureHash` | `varchar2` | itgen_bouw7_file_securehash | [ ] | filters on the platform, writable, `::ancestor.file.secureHash` | A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication. |
| `file_size` | `int64` | Taille du fichier | [ ] | filters on the platform, writable, `::ancestor.file.size` | The size of the file in bytes. |
| `file_updatedAt` | `datetime` | Fichier mis à jour le | [ ] | filters on the platform, writable, `::ancestor.file.updatedAt` | The last updated time of the entity. |
| `file_updatedBy` | `varchar2` | Fichier mis à jour par | [ ] | filters on the platform, writable, `::ancestor.file.updatedBy` | The user that last updated the entity. |
| `file_uri` | `varchar2` | URI du fichier | [ ] | filters on the platform, writable, `::ancestor.file.uri` | The URI of the file, used to fetch the contents. |
| `id` | `int64` | ID | [ ] | writable, `id` | ID of the department. |
| `id_2` | `int64` | ID | [ ] | filters on the platform, writable, `::ancestor.id` | The ID of this project file metadata. |
| `information` | `varchar2` | Information | [ ] | filters on the platform, writable, `::ancestor.information` | The information of this project file metadata. |
| `name` | `varchar2` | Name | [ ] | writable, `name` | Name of the department. |
| `name_2` | `varchar2(255)` | itgen_bouw7_name_2 | [ ] | filters on the platform, writable, `::ancestor.name` | The name of this project file metadata. |
| `projectFileCategory_id` | `int64` | Identifiant de catégorie du fichier de projet | [ ] | filters on the platform, writable, `::ancestor.projectFileCategory.id` | The ID of the file category. |
| `projectFileCategory_name` | `varchar2` | Nom de la catégorie du fichier de projet | [ ] | filters on the platform, writable, `::ancestor.projectFileCategory.name` | The name of the file category. |
| `project_branch_code` | `varchar2` | itgen_bouw7_project_branch_code | [ ] | filters on the platform, writable, `::ancestor.project.branch.code` | The code for this branch |
| `project_branch_id` | `int64` | itgen_bouw7_project_branch_id | [ ] | filters on the platform, writable, `::ancestor.project.branch.id` | The ID of the branch. |
| `project_branch_name` | `varchar2` | itgen_bouw7_project_branch_name | [ ] | filters on the platform, writable, `::ancestor.project.branch.name` | The name of this branch |
| `project_category_code` | `varchar2` | itgen_bouw7_project_category_code | [ ] | filters on the platform, writable, `::ancestor.project.category.code` | The code for the category. |
| `project_category_createdAt` | `datetime` | itgen_bouw7_project_category_createdat | [ ] | filters on the platform, writable, `::ancestor.project.category.createdAt` | The creation time of the entity. |
| `project_category_createdBy` | `varchar2` | itgen_bouw7_project_category_createdby | [ ] | filters on the platform, writable, `::ancestor.project.category.createdBy` | The user that created the entity. |
| `project_category_generalCostsOrProfit` | `varchar2` | itgen_bouw7_project_category_generalcostsorprofit | [ ] | filters on the platform, writable, `::ancestor.project.category.generalCostsOrProfit` | The general costs or profit for the category. |
| `project_category_generalCostsPercentage` | `varchar2` | itgen_bouw7_project_category_generalcostspercentage | [ ] | filters on the platform, writable, `::ancestor.project.category.generalCostsPercentage` | The general costs percentage for the category. |
| `project_category_grossProfitMargin` | `varchar2` | itgen_bouw7_project_category_grossprofitmargin | [ ] | filters on the platform, writable, `::ancestor.project.category.grossProfitMargin` | The gross profit margin for the category. |
| `project_category_id` | `int64` | itgen_bouw7_project_category_id | [ ] | filters on the platform, writable, `::ancestor.project.category.id` | The ID of the category. |
| `project_category_name` | `varchar2` | itgen_bouw7_project_category_name | [ ] | filters on the platform, writable, `::ancestor.project.category.name` | The name of the category. |
| `project_category_updatedAt` | `datetime` | itgen_bouw7_project_category_updatedat | [ ] | filters on the platform, writable, `::ancestor.project.category.updatedAt` | The last updated time of the entity. |
| `project_category_updatedBy` | `varchar2` | itgen_bouw7_project_category_updatedby | [ ] | filters on the platform, writable, `::ancestor.project.category.updatedBy` | The user that last updated the entity. |
| `project_city` | `varchar2` | Ville du projet | [ ] | filters on the platform, writable, `::ancestor.project.city` | The city of the project. |
| `project_contact_email` | `varchar2` | Adresse e-mail de contact pour le projet | [ ] | filters on the platform, writable, `::ancestor.project.contact.email` | The email address. |
| `project_contact_id` | `int64` | Référence du projet | [ ] | filters on the platform, writable, `::ancestor.project.contact.id` | ID of contact. |
| `project_contact_isVatShifted` | `char` | itgen_bouw7_project_contact_isvatshifted | [ ] | filters on the platform, writable, `::ancestor.project.contact.isVatShifted` | Whether VAT is shifted for the contact. |
| `project_contact_name` | `varchar2` | Nom du responsable du projet | [ ] | filters on the platform, writable, `::ancestor.project.contact.name` | Name of contact. |
| `project_contact_phoneNumber` | `varchar2` | itgen_bouw7_project_contact_phonenumber | [ ] | filters on the platform, writable, `::ancestor.project.contact.phoneNumber` | The phone number of the contact. |
| `project_createdAt` | `datetime` | Projet créé le | [ ] | filters on the platform, writable, `::ancestor.project.createdAt` | The creation time of the entity. |
| `project_createdBy` | `varchar2` | Projet créé par | [ ] | filters on the platform, writable, `::ancestor.project.createdBy` | The user that created the entity. |
| `project_deliveryDate` | `datetime` | Date de livraison du projet | [ ] | filters on the platform, writable, `::ancestor.project.deliveryDate` | Delivery date for the project. |
| `project_endDate` | `datetime` | Date de fin du projet | [ ] | filters on the platform, writable, `::ancestor.project.endDate` | End date for the project. |
| `project_fullProjectNumber` | `varchar2` | Numéro complet du projet | [ ] | filters on the platform, writable, `::ancestor.project.fullProjectNumber` | The full project number including year. |
| `project_houseNumber` | `varchar2` | Numéro du projet | [ ] | filters on the platform, writable, `::ancestor.project.houseNumber` | The house number for the project. |
| `project_id` | `int64` | Identifiant du projet | [ ] | filters on the platform, writable, `::ancestor.project.id` | The ID of the project. |
| `project_information` | `varchar2` | Informations du projet | [ ] | filters on the platform, writable, `::ancestor.project.information` | The information of the project. |
| `project_name` | `varchar2` | Nom de projet | [ ] | filters on the platform, writable, `::ancestor.project.name` | The name of the project. |
| `project_projectNumber` | `varchar2` | Projet  Numéro de projet | [ ] | filters on the platform, writable, `::ancestor.project.projectNumber` | The project number. |
| `project_reference` | `varchar2` | Référence du projet | [ ] | filters on the platform, writable, `::ancestor.project.reference` | The reference of the project. |
| `project_startDate` | `datetime` | Date de début du projet | [ ] | filters on the platform, writable, `::ancestor.project.startDate` | Start date for the project. |
| `project_status_closesProject` | `char` | Statut du projet : Clôture du projet | [ ] | filters on the platform, writable, `::ancestor.project.status.closesProject` | Whether or not this status closes a project. |
| `project_status_createdAt` | `datetime` | Statut du projet Créé le | [ ] | filters on the platform, writable, `::ancestor.project.status.createdAt` | The creation time of the entity. |
| `project_status_createdBy` | `varchar2` | Statut du projet Créé par | [ ] | filters on the platform, writable, `::ancestor.project.status.createdBy` | The user that created the entity. |
| `project_status_id` | `int64` | Identifiant de l'état du projet | [ ] | filters on the platform, writable, `::ancestor.project.status.id` | The ID of the status. |
| `project_status_invoicesProject` | `char` | État d'avancement du projet Factures Projet | [ ] | filters on the platform, writable, `::ancestor.project.status.invoicesProject` | Whether or not this status invoices a project. |
| `project_status_name` | `varchar2` | Nom de l'état d'avancement du projet | [ ] | filters on the platform, writable, `::ancestor.project.status.name` | The name of the status. |
| `project_status_plansProject` | `char` | État d'avancement du projet Plans Projet | [ ] | filters on the platform, writable, `::ancestor.project.status.plansProject` | Whether or not this status plans a project. |
| `project_status_updatedAt` | `datetime` | État d'avancement du projet mis à jour le | [ ] | filters on the platform, writable, `::ancestor.project.status.updatedAt` | The last updated time of the entity. |
| `project_status_updatedBy` | `varchar2` | État du projet mis à jour par | [ ] | filters on the platform, writable, `::ancestor.project.status.updatedBy` | The user that last updated the entity. |
| `project_streetName` | `varchar2` | Nom du projet « Street » | [ ] | filters on the platform, writable, `::ancestor.project.streetName` | The street name for the project. |
| `project_updatedAt` | `datetime` | Mise à jour du projet le | [ ] | filters on the platform, writable, `::ancestor.project.updatedAt` | The last updated time of the entity. |
| `project_updatedBy` | `varchar2` | Projet mis à jour par | [ ] | filters on the platform, writable, `::ancestor.project.updatedBy` | The user that last updated the entity. |
| `project_zipCode` | `varchar2` | Code postal du projet | [ ] | filters on the platform, writable, `::ancestor.project.zipCode` | The zip code for the project. |
| `updatedAt` | `datetime` | Mise à jour à | [ ] | filters on the platform, writable, `::ancestor.updatedAt` | The last updated time of the entity. |
| `updatedBy` | `varchar2` | Mise à jour par | [ ] | filters on the platform, writable, `::ancestor.updatedBy` | The user that last updated the entity. |


## Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :

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