invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

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
additionalWork varchar2 Travaux supplémentaires filters on the platform, writable, additionalWork Additional work for the project.
branch_id int64 Identifiant de la succursale filters on the platform, writable, branch.id The ID of the branch.
branch_name varchar2 Nom de la branche 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 Code de catégorie filters on the platform, writable, category.code The code for the category.
category_id int64 ID de catégorie filters on the platform, writable, category.id The ID of the category.
category_name varchar2 Nom de la catégorie 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 Adresse e-mail de la personne à contacter filters on the platform, writable, contactPerson.emailAddress The email address of the contact.
contactPerson_id int64 Identifiant de la personne à contacter 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 Adresse e-mail filters on the platform, writable, contact.emailAddress The email address of the contact.
contact_id int64 ID de contact filters on the platform, writable, contact.id The ID of the contact.
contact_name varchar2 Nom du Contact filters on the platform, writable, contact.name The name of this contact.
contact_type varchar2 Type de contact filters on the platform, writable, contact.type The type of this contact.
contact_typeId int64 Identifiant du type de contact filters on the platform, writable, contact.typeId The type ID of this contact.
countryCode varchar2 code du pays filters on the platform, writable, countryCode An ISO 3166-2 representation of the country.
createdAt datetime Créé le filters on the platform, writable, createdAt The creation date of the object in ATOM/ISO-8601 format
createdBy_id int64 Créé par ID filters on the platform, writable, createdBy.id The ID of the user.
createdBy_username varchar2 Créé par Nom d'utilisateur filters on the platform, writable, createdBy.username The username of the user.
deliveryDate datetime Date de livraison filters on the platform, writable, deliveryDate Delivery date for the project.
division_description varchar2 Description de la division filters on the platform, writable, division.description The description of the division.
division_exactDivisionId varchar2 Division : ID exact de la division filters on the platform, writable, division.exactDivisionId The division ID of an Exact Online environment.
division_glAccountCode varchar2 Code de compte du grand livre général de la division filters on the platform, writable, division.glAccountCode A default general ledger account code to use for sales related items.
division_glAccountCodePurchase varchar2 Division - Code de compte du grand livre général - Achats filters on the platform, writable, division.glAccountCodePurchase A default general ledger account code to use for purchase related items.
division_id int64 ID de l'entreprise filters on the platform, writable, division.id The ID of the division.
division_journalCode varchar2 Code du journal de division filters on the platform, writable, division.journalCode A default journal code to use for sales related items.
division_journalCodePurchase varchar2 Code du journal de la division : Achat filters on the platform, writable, division.journalCodePurchase A default journal code to use for purchase related items.
endDate datetime Date de fin filters on the platform, writable, endDate End date for the project.
executor_departmentId int64 Identifiant du service chargé de l'exécution testamentaire filters on the platform, writable, executor.departmentId The ID of the department this employee is enrolled in.
executor_exactSalaryFrequency int64 Fréquence exacte du versement du salaire de l'exécuteur testamentaire filters on the platform, writable, executor.exactSalaryFrequency The exact salary frequency of this employee.
executor_firstName varchar2 Prénom de l'exécuteur testamentaire filters on the platform, writable, executor.firstName The given name of this employee.
executor_id int64 Identifiant de l'exécuteur testamentaire filters on the platform, writable, executor.id The ID of the employee.
executor_lastName varchar2 Nom de famille de l'exécuteur testamentaire filters on the platform, writable, executor.lastName The family name of this employee.
fixedPrice varchar2 Prix fixe filters on the platform, writable, fixedPrice The fixed price of the project.
fullProjectNumber varchar2 Numéro complet du projet filters on the platform, writable, fullProjectNumber The full project number including year.
houseNumber varchar2 Numéro de maison 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 Identifiant du parent filters on the platform, writable, parentId The ID of the parent Project if this Project is a Subproject.
projectLeader_departmentId int64 Responsable de projet - Référence du service filters on the platform, writable, projectLeader.departmentId The ID of the department this employee is enrolled in.
projectLeader_exactSalaryFrequency int64 Chef de projet : salaire exact et fréquence de paiement filters on the platform, writable, projectLeader.exactSalaryFrequency The exact salary frequency of this employee.
projectLeader_firstName varchar2 Prénom du chef de projet filters on the platform, writable, projectLeader.firstName The given name of this employee.
projectLeader_id int64 Identifiant du chef de projet filters on the platform, writable, projectLeader.id The ID of the employee.
projectLeader_lastName varchar2 Nom de famille du chef de projet filters on the platform, writable, projectLeader.lastName The family name of this employee.
projectNumber varchar2 Numéro de Projet filters on the platform, writable, projectNumber The project number.
propertyAsset_id int64 Référence du bien immobilier filters on the platform, writable, propertyAsset.id The ID of the property asset.
propertyAsset_name varchar2 Nom du bien immobilier 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 Date de début filters on the platform, writable, startDate Start date for the project.
status_closesPlanning char Statut : Clôture de la planification filters on the platform, writable, status.closesPlanning Whether the project planning is closed.
status_closesProject char Statut : projet clôturé filters on the platform, writable, status.closesProject Whether this status denotes a closed-state of the project.
status_id int64 Identifiant d'état filters on the platform, writable, status.id The ID of the status.
status_invoicesProject char État d'avancement du projet « Factures » filters on the platform, writable, status.invoicesProject Whether this status denotes an invoiced-state of the project.
status_name varchar2 Nom du statut filters on the platform, writable, status.name The name of the status.
status_plansProject char Projet « Status Plans » filters on the platform, writable, status.plansProject Whether this status denotes a planned-state of the project.
streetName varchar2 Nom de la rue filters on the platform, writable, streetName The street name for the project.
updatedAt datetime Mise à jour à filters on the platform, writable, updatedAt The creation date of the object in ATOM/ISO-8601 format
updatedBy_id int64 Mis à jour par ID filters on the platform, writable, updatedBy.id The ID of the user.
updatedBy_username varchar2 Mis à jour par Nom d'utilisateur filters on the platform, writable, updatedBy.username The username of the user.
workPlanner_departmentId int64 Identifiant du service « Work Planner » filters on the platform, writable, workPlanner.departmentId The ID of the department this employee is enrolled in.
workPlanner_exactSalaryFrequency int64 Planificateur de travail : fréquence exacte de versement du salaire filters on the platform, writable, workPlanner.exactSalaryFrequency The exact salary frequency of this employee.
workPlanner_firstName varchar2 Prénom du planificateur de travail filters on the platform, writable, workPlanner.firstName The given name of this employee.
workPlanner_id int64 Identifiant du planificateur de tâches filters on the platform, writable, workPlanner.id The ID of the employee.
workPlanner_lastName varchar2 Nom de famille du responsable de la planification des travaux filters on the platform, writable, workPlanner.lastName The family name of this employee.
zipCode varchar2 Code postal filters on the platform, writable, zipCode 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 :