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

ProjectFileById: Bouw7 Project File by ID

read only REST

  • Catalogue : Bouw7
  • Schéma : Project
  • Label: Project File by 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 `` Identifiant du projet

Colonnes de table

Les colonnes de la table ProjectFileById 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, contact.contactType.id The ID of contact type.
contact_contactType_name varchar2 Contact Type de contact Nom filters on the platform, writable, contact.contactType.name The name of contact type.
contact_email varchar2 Email du contact filters on the platform, writable, contact.email The email address.
contact_id int64 ID de contact filters on the platform, writable, contact.id ID of contact.
contact_isVatShifted char Contact : la TVA est-elle répercutée ? filters on the platform, writable, contact.isVatShifted Whether VAT is shifted for the contact.
contact_name varchar2 Nom du Contact filters on the platform, writable, contact.name Name of contact.
contact_phoneNumber varchar2 Numéro de téléphone filters on the platform, writable, contact.phoneNumber The phone number of the contact.
createdAt datetime Créé le filters on the platform, writable, createdAt The creation time of the entity.
createdBy varchar2 Crée par filters on the platform, writable, createdBy The user that created the entity.
file_createdAt datetime Fichier créé le filters on the platform, writable, file.createdAt The creation time of the entity.
file_createdBy varchar2 Fichier créé par filters on the platform, writable, file.createdBy The user that created the entity.
file_extension varchar2 Extension de fichier filters on the platform, writable, file.extension The extension of the file.
file_id int64 ID de fichier filters on the platform, writable, file.id The ID of this file
file_modelId int64 ID du modèle de fichier filters on the platform, writable, file.modelId The ID of the associated type.
file_modelType varchar2 Type de modèle de fichier filters on the platform, writable, file.modelType The category of the file.
file_name varchar2 Nom de fichier filters on the platform, writable, file.name The public name of the file.
file_secureHash varchar2 itgen_bouw7_file_securehash filters on the platform, writable, 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, file.size The size of the file in bytes.
file_updatedAt datetime Fichier mis à jour le filters on the platform, writable, file.updatedAt The last updated time of the entity.
file_updatedBy varchar2 Fichier mis à jour par filters on the platform, writable, file.updatedBy The user that last updated the entity.
file_uri varchar2 URI du fichier filters on the platform, writable, file.uri 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(255) Name filters on the platform, writable, name The name of this project file metadata.
projectFileCategory_id int64 Identifiant de catégorie du fichier de projet filters on the platform, writable, 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, projectFileCategory.name The name of the file category.
project_branch_code varchar2 itgen_bouw7_project_branch_code filters on the platform, writable, project.branch.code The code for this branch
project_branch_id int64 itgen_bouw7_project_branch_id filters on the platform, writable, project.branch.id The ID of the branch.
project_branch_name varchar2 itgen_bouw7_project_branch_name filters on the platform, writable, project.branch.name The name of this branch
project_category_code varchar2 itgen_bouw7_project_category_code filters on the platform, writable, project.category.code The code for the category.
project_category_createdAt datetime itgen_bouw7_project_category_createdat filters on the platform, writable, project.category.createdAt The creation time of the entity.
project_category_createdBy varchar2 itgen_bouw7_project_category_createdby filters on the platform, writable, project.category.createdBy The user that created the entity.
project_category_generalCostsOrProfit varchar2 itgen_bouw7_project_category_generalcostsorprofit filters on the platform, writable, 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, project.category.generalCostsPercentage The general costs percentage for the category.
project_category_grossProfitMargin varchar2 itgen_bouw7_project_category_grossprofitmargin filters on the platform, writable, project.category.grossProfitMargin The gross profit margin for the category.
project_category_id int64 itgen_bouw7_project_category_id filters on the platform, writable, project.category.id The ID of the category.
project_category_name varchar2 itgen_bouw7_project_category_name filters on the platform, writable, project.category.name The name of the category.
project_category_updatedAt datetime itgen_bouw7_project_category_updatedat filters on the platform, writable, project.category.updatedAt The last updated time of the entity.
project_category_updatedBy varchar2 itgen_bouw7_project_category_updatedby filters on the platform, writable, project.category.updatedBy The user that last updated the entity.
project_city varchar2 Ville du projet filters on the platform, writable, project.city The city of the project.
project_contact_email varchar2 Adresse e-mail de contact pour le projet filters on the platform, writable, project.contact.email The email address.
project_contact_id int64 Référence du projet filters on the platform, writable, project.contact.id ID of contact.
project_contact_isVatShifted char itgen_bouw7_project_contact_isvatshifted filters on the platform, writable, project.contact.isVatShifted Whether VAT is shifted for the contact.
project_contact_name varchar2 Nom du responsable du projet filters on the platform, writable, project.contact.name Name of contact.
project_contact_phoneNumber varchar2 itgen_bouw7_project_contact_phonenumber filters on the platform, writable, project.contact.phoneNumber The phone number of the contact.
project_createdAt datetime Projet créé le filters on the platform, writable, project.createdAt The creation time of the entity.
project_createdBy varchar2 Projet créé par filters on the platform, writable, project.createdBy The user that created the entity.
project_deliveryDate datetime Date de livraison du projet filters on the platform, writable, project.deliveryDate Delivery date for the project.
project_endDate datetime Date de fin du projet filters on the platform, writable, project.endDate End date for the project.
project_fullProjectNumber varchar2 Numéro complet du projet filters on the platform, writable, project.fullProjectNumber The full project number including year.
project_houseNumber varchar2 Numéro du projet filters on the platform, writable, project.houseNumber The house number for the project.
project_id int64 Identifiant du projet filters on the platform, writable, project.id The ID of the project.
project_information varchar2 Informations du projet filters on the platform, writable, project.information The information of the project.
project_name varchar2 Nom de projet filters on the platform, writable, project.name The name of the project.
project_projectNumber varchar2 Projet Numéro de projet filters on the platform, writable, project.projectNumber The project number.
project_reference varchar2 Référence du projet filters on the platform, writable, project.reference The reference of the project.
project_startDate datetime Date de début du projet filters on the platform, writable, project.startDate Start date for the project.
project_status_closesProject char Statut du projet : Clôture du projet filters on the platform, writable, 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, project.status.createdAt The creation time of the entity.
project_status_createdBy varchar2 Statut du projet Créé par filters on the platform, writable, project.status.createdBy The user that created the entity.
project_status_id int64 Identifiant de l'état du projet filters on the platform, writable, project.status.id The ID of the status.
project_status_invoicesProject char État d'avancement du projet Factures Projet filters on the platform, writable, 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, project.status.name The name of the status.
project_status_plansProject char État d'avancement du projet Plans Projet filters on the platform, writable, 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, 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, project.status.updatedBy The user that last updated the entity.
project_streetName varchar2 Nom du projet « Street » filters on the platform, writable, project.streetName The street name for the project.
project_updatedAt datetime Mise à jour du projet le filters on the platform, writable, project.updatedAt The last updated time of the entity.
project_updatedBy varchar2 Projet mis à jour par filters on the platform, writable, project.updatedBy The user that last updated the entity.
project_zipCode varchar2 Code postal du projet filters on the platform, writable, project.zipCode The zip code for the project.
updatedAt datetime Mise à jour à filters on the platform, writable, updatedAt The last updated time of the entity.
updatedBy varchar2 Mise à jour par filters on the platform, writable, 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 :