Projects: Bouw7 Projects
popular read only REST
- Catalogue :
Bouw7 - Schéma :
Project - Label: Projects
Returns a list of projects associated with the organization. Returns a list of projects associated with the organization
Permet uniquement de récupérer des données.
Résumé
Returns a list of projects associated with the organization
Source de l'API
- Point de terminaison :
/list/projects - Opération :
get /list/projects
Caractéristiques de performance
| Characteristic | Value |
|---|---|
| Latence moyenne d'accès (ms) | 192 |
| Nombre de lignes par minute en mode de balayage complet | 320,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 |
|---|---|---|---|---|
q |
`` | A Heimdall Query Language string |
Colonnes de table
Les colonnes de la table Projects 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 |
|---|---|---|---|---|---|
additional |
varchar2 |
Travaux supplémentaires | filters on the platform, writable, additional |
Additional work for the project. | |
branch_ |
int64 |
Identifiant de la succursale | filters on the platform, writable, branch. |
The ID of the branch. | |
branch_ |
varchar2 |
Nom de la branche | filters on the platform, writable, branch. |
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 |
||
ca |
char |
CA Project Checkbox | filters on the platform, writable, ca |
||
ca |
varchar2 |
CA Project Contact | filters on the platform, writable, ca |
||
ca |
datetime |
CA Project Datum | filters on the platform, writable, ca |
||
ca |
datetime |
CA Project Datumtijd | filters on the platform, writable, ca |
||
ca |
varchar2 |
CA Project Dropdown | filters on the platform, writable, ca |
||
ca |
varchar2 |
CA Project Medewerker | filters on the platform, writable, ca |
||
ca |
varchar2 |
CA Project Tekstgebied | filters on the platform, writable, ca |
||
ca |
varchar2 |
CA Project Tekstveld | filters on the platform, writable, ca |
||
category_ |
varchar2 |
Code de catégorie | filters on the platform, writable, category. |
The code for the category. | |
category_ |
int64 |
ID de catégorie | filters on the platform, writable, category. |
The ID of the category. | |
category_ |
varchar2 |
Nom de la catégorie | filters on the platform, writable, category. |
The name of the category. | |
city |
varchar2 |
City | filters on the platform, writable, city |
The city of the project. | |
contact |
varchar2 |
Adresse e-mail de la personne à contacter | filters on the platform, writable, contact |
The email address of the contact. | |
contact |
int64 |
Identifiant de la personne à contacter | filters on the platform, writable, contact |
The ID of the contact. | |
contact |
varchar2 |
itgen_bouw7_contactperson_name | filters on the platform, writable, contact |
The name of this contact. | |
contact |
varchar2 |
itgen_bouw7_contactperson_type | filters on the platform, writable, contact |
The type of this contact. | |
contact |
int64 |
itgen_bouw7_contactperson_typeid | filters on the platform, writable, contact |
The type ID of this contact. | |
contact_ |
varchar2 |
Adresse e-mail | filters on the platform, writable, contact. |
The email address of the contact. | |
contact_ |
int64 |
ID de contact | filters on the platform, writable, contact. |
The ID of the contact. | |
contact_ |
varchar2 |
Nom du Contact | filters on the platform, writable, contact. |
The name of this contact. | |
contact_ |
varchar2 |
Type de contact | filters on the platform, writable, contact. |
The type of this contact. | |
contact_ |
int64 |
Identifiant du type de contact | filters on the platform, writable, contact. |
The type ID of this contact. | |
country |
varchar2 |
code du pays | filters on the platform, writable, country |
An ISO 3166-2 representation of the country. | |
created |
datetime |
Créé le | filters on the platform, writable, created |
The creation date of the object in ATOM/ISO-8601 format | |
created |
int64 |
Créé par ID | filters on the platform, writable, created |
The ID of the user. | |
created |
varchar2 |
Créé par Nom d'utilisateur | filters on the platform, writable, created |
The username of the user. | |
delivery |
datetime |
Date de livraison | filters on the platform, writable, delivery |
Delivery date for the project. | |
division_ |
varchar2 |
Description de la division | filters on the platform, writable, division. |
The description of the division. | |
division_ |
varchar2 |
Division : ID exact de la division | filters on the platform, writable, division. |
The division ID of an Exact Online environment. | |
division_ |
varchar2 |
Code de compte du grand livre général de la division | filters on the platform, writable, division. |
A default general ledger account code to use for sales related items. | |
division_ |
varchar2 |
Division - Code de compte du grand livre général - Achats | filters on the platform, writable, division. |
A default general ledger account code to use for purchase related items. | |
division_ |
int64 |
ID de l'entreprise | filters on the platform, writable, division. |
The ID of the division. | |
division_ |
varchar2 |
Code du journal de division | filters on the platform, writable, division. |
A default journal code to use for sales related items. | |
division_ |
varchar2 |
Code du journal de la division : Achat | filters on the platform, writable, division. |
A default journal code to use for purchase related items. | |
end |
datetime |
Date de fin | filters on the platform, writable, end |
End date for the project. | |
executor_ |
int64 |
Identifiant du service chargé de l'exécution testamentaire | filters on the platform, writable, executor. |
The ID of the department this employee is enrolled in. | |
executor_ |
int64 |
Fréquence exacte du versement du salaire de l'exécuteur testamentaire | filters on the platform, writable, executor. |
The exact salary frequency of this employee. | |
executor_ |
varchar2 |
Prénom de l'exécuteur testamentaire | filters on the platform, writable, executor. |
The given name of this employee. | |
executor_ |
int64 |
Identifiant de l'exécuteur testamentaire | filters on the platform, writable, executor. |
The ID of the employee. | |
executor_ |
varchar2 |
Nom de famille de l'exécuteur testamentaire | filters on the platform, writable, executor. |
The family name of this employee. | |
fixed |
varchar2 |
Prix fixe | filters on the platform, writable, fixed |
The fixed price of the project. | |
full |
varchar2 |
Numéro complet du projet | filters on the platform, writable, full |
The full project number including year. | |
house |
varchar2 |
Numéro de maison | filters on the platform, writable, house |
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. | |
parent |
int64 |
Identifiant du parent | filters on the platform, writable, parent |
The ID of the parent Project if this Project is a Subproject. | |
project |
int64 |
Responsable de projet - Référence du service | filters on the platform, writable, project |
The ID of the department this employee is enrolled in. | |
project |
int64 |
Chef de projet : salaire exact et fréquence de paiement | filters on the platform, writable, project |
The exact salary frequency of this employee. | |
project |
varchar2 |
Prénom du chef de projet | filters on the platform, writable, project |
The given name of this employee. | |
project |
int64 |
Identifiant du chef de projet | filters on the platform, writable, project |
The ID of the employee. | |
project |
varchar2 |
Nom de famille du chef de projet | filters on the platform, writable, project |
The family name of this employee. | |
project |
varchar2 |
Numéro de Projet | filters on the platform, writable, project |
The project number. | |
property |
int64 |
Référence du bien immobilier | filters on the platform, writable, property |
The ID of the property asset. | |
property |
varchar2 |
Nom du bien immobilier | filters on the platform, writable, property |
The name of the property asset. | |
reference |
varchar2 |
Reference | filters on the platform, writable, reference |
The reference of the project. | |
start |
datetime |
Date de début | filters on the platform, writable, start |
Start date for the project. | |
status_ |
char |
Statut : Clôture de la planification | filters on the platform, writable, status. |
Whether the project planning is closed. | |
status_ |
char |
Statut : projet clôturé | filters on the platform, writable, status. |
Whether this status denotes a closed-state of the project. | |
status_ |
int64 |
Identifiant d'état | filters on the platform, writable, status. |
The ID of the status. | |
status_ |
char |
État d'avancement du projet « Factures » | filters on the platform, writable, status. |
Whether this status denotes an invoiced-state of the project. | |
status_ |
varchar2 |
Nom du statut | filters on the platform, writable, status. |
The name of the status. | |
status_ |
char |
Projet « Status Plans » | filters on the platform, writable, status. |
Whether this status denotes a planned-state of the project. | |
street |
varchar2 |
Nom de la rue | filters on the platform, writable, street |
The street name for the project. | |
updated |
datetime |
Mise à jour à | filters on the platform, writable, updated |
The creation date of the object in ATOM/ISO-8601 format | |
updated |
int64 |
Mis à jour par ID | filters on the platform, writable, updated |
The ID of the user. | |
updated |
varchar2 |
Mis à jour par Nom d'utilisateur | filters on the platform, writable, updated |
The username of the user. | |
work |
int64 |
Identifiant du service « Work Planner » | filters on the platform, writable, work |
The ID of the department this employee is enrolled in. | |
work |
int64 |
Planificateur de travail : fréquence exacte de versement du salaire | filters on the platform, writable, work |
The exact salary frequency of this employee. | |
work |
varchar2 |
Prénom du planificateur de travail | filters on the platform, writable, work |
The given name of this employee. | |
work |
int64 |
Identifiant du planificateur de tâches | filters on the platform, writable, work |
The ID of the employee. | |
work |
varchar2 |
Nom de famille du responsable de la planification des travaux | filters on the platform, writable, work |
The family name of this employee. | |
zip |
varchar2 |
Code postal | filters on the platform, writable, zip |
The zip code for the project. |
Exemples de Queries
--
-- 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
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 :