invantive documentation
Invantive Support ForumsLog In / Sign Up

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 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

--
-- 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

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: