ProjectFileById: Bouw7 Project File by ID
read only REST
- Catalogus:
Bouw7 - Schema:
Project - Label: Project File by ID
Returns a project file associated with the given id. Returns a project file associated with the given id.
Kan alleen gegevens ophalen.
Samenvatting
Returns a project file associated with the given id.
API-bron
- Eindpunt:
/project/file/{projectFile} - Operatie:
get /project/file/{projectFile}
Prestatiekenmerken
| Characteristic | Value |
|---|---|
| Gemiddelde toegangsvertraging (ms) | 90 |
| Aantal rijen per minuut bij volledige scan | 241,000 |
| Aantal rijen per minuut in een Query | 666 |
Het resultaat kan op de client in de Cache worden opgeslagen.
Parameters
| Name | Datatype | Required | Default | Documentation |
|---|---|---|---|---|
project |
`` | Project ID |
Tabelkolommen
De kolommen van de tabel ProjectFileById worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
contact_ |
int64 |
Contact Soort ID | filters on the platform, writable, contact. |
The ID of contact type. | |
contact_ |
varchar2 |
Contact Soort Naam | filters on the platform, writable, contact. |
The name of contact type. | |
contact_ |
varchar2 |
Contact E-mail | filters on the platform, writable, contact. |
The email address. | |
contact_ |
int64 |
Contactpersoon ID | filters on the platform, writable, contact. |
ID of contact. | |
contact_ |
char |
Contact is BTW Verlegd | filters on the platform, writable, contact. |
Whether VAT is shifted for the contact. | |
contact_ |
varchar2 |
Contactpersoon Naam | filters on the platform, writable, contact. |
Name of contact. | |
contact_ |
varchar2 |
Contact Telefoonnummer | filters on the platform, writable, contact. |
The phone number of the contact. | |
created |
datetime |
Aangemaakt op | filters on the platform, writable, created |
The creation time of the entity. | |
created |
varchar2 |
Gemaakt door | filters on the platform, writable, created |
The user that created the entity. | |
file_ |
datetime |
Bestand Gemaakt op | filters on the platform, writable, file. |
The creation time of the entity. | |
file_ |
varchar2 |
Bestand Gemaakt door | filters on the platform, writable, file. |
The user that created the entity. | |
file_ |
varchar2 |
Bestandsextensie | filters on the platform, writable, file. |
The extension of the file. | |
file_ |
int64 |
Bestands-ID | filters on the platform, writable, file. |
The ID of this file | |
file_ |
int64 |
Bestandsmodel-ID | filters on the platform, writable, file. |
The ID of the associated type. | |
file_ |
varchar2 |
Bestandsmodelsoort | filters on the platform, writable, file. |
The category of the file. | |
file_ |
varchar2 |
Bestandsnaam | filters on the platform, writable, file. |
The public name of the file. | |
file_ |
varchar2 |
itgen_bouw7_file_securehash | filters on the platform, writable, file. |
A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication. | |
file_ |
int64 |
Bestandsgrootte | filters on the platform, writable, file. |
The size of the file in bytes. | |
file_ |
datetime |
Bestand Bijgewerkt op | filters on the platform, writable, file. |
The last updated time of the entity. | |
file_ |
varchar2 |
Bestand Bijgewerkt door | filters on the platform, writable, file. |
The user that last updated the entity. | |
file_ |
varchar2 |
Bestand URI | filters on the platform, writable, file. |
The URI of the file, used to fetch the contents. | |
id |
int64 |
ID | filters on the platform, writable, id |
The ID of this project file metadata. | |
information |
varchar2 |
Information | filters on the platform, writable, information |
The information of this project file metadata. | |
name |
varchar2 |
Name | filters on the platform, writable, name |
The name of this project file metadata. | |
project |
int64 |
Project Bestandscategorie-ID | filters on the platform, writable, project |
The ID of the file category. | |
project |
varchar2 |
Project Bestandscategorienaam | filters on the platform, writable, project |
The name of the file category. | |
project_ |
varchar2 |
itgen_bouw7_project_branch_code | filters on the platform, writable, project. |
The code for this branch | |
project_ |
int64 |
itgen_bouw7_project_branch_id | filters on the platform, writable, project. |
The ID of the branch. | |
project_ |
varchar2 |
itgen_bouw7_project_branch_name | filters on the platform, writable, project. |
The name of this branch | |
project_ |
varchar2 |
itgen_bouw7_project_category_code | filters on the platform, writable, project. |
The code for the category. | |
project_ |
datetime |
itgen_bouw7_project_category_createdat | filters on the platform, writable, project. |
The creation time of the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_createdby | filters on the platform, writable, project. |
The user that created the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_generalcostsorprofit | filters on the platform, writable, project. |
The general costs or profit for the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_generalcostspercentage | filters on the platform, writable, project. |
The general costs percentage for the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_grossprofitmargin | filters on the platform, writable, project. |
The gross profit margin for the category. | |
project_ |
int64 |
itgen_bouw7_project_category_id | filters on the platform, writable, project. |
The ID of the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_name | filters on the platform, writable, project. |
The name of the category. | |
project_ |
datetime |
itgen_bouw7_project_category_updatedat | filters on the platform, writable, project. |
The last updated time of the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_updatedby | filters on the platform, writable, project. |
The user that last updated the entity. | |
project_ |
varchar2 |
Project Stad | filters on the platform, writable, project. |
The city of the project. | |
project_ |
varchar2 |
Projectcontactpersoon E-mail | filters on the platform, writable, project. |
The email address. | |
project_ |
int64 |
Projectcontactpersoon-ID | filters on the platform, writable, project. |
ID of contact. | |
project_ |
char |
itgen_bouw7_project_contact_isvatshifted | filters on the platform, writable, project. |
Whether VAT is shifted for the contact. | |
project_ |
varchar2 |
Project Contactnaam | filters on the platform, writable, project. |
Name of contact. | |
project_ |
varchar2 |
itgen_bouw7_project_contact_phonenumber | filters on the platform, writable, project. |
The phone number of the contact. | |
project_ |
datetime |
Project Gemaakt op | filters on the platform, writable, project. |
The creation time of the entity. | |
project_ |
varchar2 |
Project Gemaakt door | filters on the platform, writable, project. |
The user that created the entity. | |
project_ |
datetime |
Project Opleverdatum | filters on the platform, writable, project. |
Delivery date for the project. | |
project_ |
datetime |
Project Einddatum | filters on the platform, writable, project. |
End date for the project. | |
project_ |
varchar2 |
Volledig Projectnummer | filters on the platform, writable, project. |
The full project number including year. | |
project_ |
varchar2 |
Project Huisnummer | filters on the platform, writable, project. |
The house number for the project. | |
project_ |
int64 |
Project ID | filters on the platform, writable, project. |
The ID of the project. | |
project_ |
varchar2 |
Projectgegevens | filters on the platform, writable, project. |
The information of the project. | |
project_ |
varchar2 |
Projectnaam | filters on the platform, writable, project. |
The name of the project. | |
project_ |
varchar2 |
Projectnummer | filters on the platform, writable, project. |
The project number. | |
project_ |
varchar2 |
Projectreferentie | filters on the platform, writable, project. |
The reference of the project. | |
project_ |
datetime |
Project Startdatum | filters on the platform, writable, project. |
Start date for the project. | |
project_ |
char |
Projectstatus Sluit Project af | filters on the platform, writable, project. |
Whether or not this status closes a project. | |
project_ |
datetime |
Projectstatus Gemaakt op | filters on the platform, writable, project. |
The creation time of the entity. | |
project_ |
varchar2 |
Projectstatus Gemaakt door | filters on the platform, writable, project. |
The user that created the entity. | |
project_ |
int64 |
Projectstatus-ID | filters on the platform, writable, project. |
The ID of the status. | |
project_ |
char |
Projectstatus Projectfacturen | filters on the platform, writable, project. |
Whether or not this status invoices a project. | |
project_ |
varchar2 |
Projectstatusnaam | filters on the platform, writable, project. |
The name of the status. | |
project_ |
char |
Projectstatus Plannen Project | filters on the platform, writable, project. |
Whether or not this status plans a project. | |
project_ |
datetime |
Projectstatus Bijgewerkt op | filters on the platform, writable, project. |
The last updated time of the entity. | |
project_ |
varchar2 |
Projectstatus Bijgewerkt door | filters on the platform, writable, project. |
The user that last updated the entity. | |
project_ |
varchar2 |
Projectstraatnaam | filters on the platform, writable, project. |
The street name for the project. | |
project_ |
datetime |
Project Bijgewerkt op | filters on the platform, writable, project. |
The last updated time of the entity. | |
project_ |
varchar2 |
Project Bijgewerkt door | filters on the platform, writable, project. |
The user that last updated the entity. | |
project_ |
varchar2 |
Project Postcode | filters on the platform, writable, project. |
The zip code for the project. | |
updated |
datetime |
Bijgewerkt op | filters on the platform, writable, updated |
The last updated time of the entity. | |
updated |
varchar2 |
Bijgewerkt door | filters on the platform, writable, updated |
The user that last updated the entity. |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: