invantive documentation
Forum di supporto InvantiveAccedi / Registrati

DeletedProjects: Bouw7 Deleted Projects

Questa pagina non è ancora disponibile nella tua lingua; viene visualizzata la versione originale.

read only REST

  • Catalog: Bouw7
  • Schema: Project
  • Label: Deleted Projects

Returns a list of deleted projects associated with the organization. Returns a list of deleted projects associated with the organization.

Can only retrieve data.

Summary

Returns a list of deleted projects associated with the organization.

API Source

  • Endpoint: /deleted-projects
  • Operation: get /deleted-projects

Performance Characteristics

Characteristic Value
Average access latency (ms) 90
Full scan rows per minute 20,800
Point query rows per minute 666

The result can be cached on the client.

Table Columns

The columns of the table DeletedProjects 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
contact_email varchar2 Contact Email filters on the platform, writable, contact.email The email address.
contact_id int64 Contact ID filters on the platform, writable, contact.id ID of contact.
contact_isVatShifted char Contact Is VAT Shifted filters on the platform, writable, contact.isVatShifted Whether VAT is shifted for the contact.
contact_name varchar2 Contact Name filters on the platform, writable, contact.name Name of contact.
contact_phoneNumber varchar2 Contact Phone Number filters on the platform, writable, contact.phoneNumber The phone number of the contact.
deletedAt varchar2 Deleted at filters on the platform, writable, deletedAt The date the project was deleted in ATOM format.
deletedBy_id int64 Deleted by ID filters on the platform, writable, deletedBy.id ID of the user.
deletedBy_username varchar2 Deleted by User Name filters on the platform, writable, deletedBy.username The username of the user.
fullProjectNumber varchar2 Full Project Number filters on the platform, writable, fullProjectNumber The full project number including year.
id int64 ID filters on the platform, writable, id The ID of the project.
name varchar2 Name filters on the platform, writable, name The name of the project.
status_closesProject char Status Closes Project filters on the platform, writable, status.closesProject Whether or not this status closes a project.
status_createdAt datetime Status Created at filters on the platform, writable, status.createdAt The creation time of the entity.
status_createdBy varchar2 Status Created by filters on the platform, writable, status.createdBy The user that created the entity.
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 or not this status invoices a 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 or not this status plans a project.
status_updatedAt datetime Status Updated at filters on the platform, writable, status.updatedAt The last updated time of the entity.
status_updatedBy varchar2 Status Updated by filters on the platform, writable, status.updatedBy The user that last updated the entity.

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: