invantive documentation
Invantive Support ForumsLog In / Sign Up

HourLogs: Bouw7 Hour Logs

read only REST

  • Catalog: Bouw7
  • Schema: HourLog
  • Label: Hour Logs

Returns a list of hour logs associated with the given project. Returns a list of hour logs associated with the given project.

Can only retrieve data.

Summary

Returns a list of hour logs associated with the given project.

API Source

  • Endpoint: /project/{project}/hour-logs
  • Operation: get /project/{project}/hour-logs

Performance Characteristics

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

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
project `` Project ID
q `` Filter collections with the Heimdall Query Language

Table Columns

The columns of the table HourLogs 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
approved char Approved filters on the platform, writable, approved Whether this hour log has been approved.
comments varchar2 Comments filters on the platform, writable, comments The comments for this hour log.
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.
createdAt datetime Created at filters on the platform, writable, createdAt The creation time of the entity.
createdBy varchar2 Created by filters on the platform, writable, createdBy The user that created the entity.
employee_firstName varchar2 Employee First Name filters on the platform, writable, employee.firstName First name of the employee.
employee_id int64 Employee ID filters on the platform, writable, employee.id ID of the employee.
employee_lastName varchar2 Employee Last Name filters on the platform, writable, employee.lastName Last name of the employee.
endTime varchar2 End Time filters on the platform, writable, endTime The end time of the workday. Only available if enabled for your organization.
exactUpdatedAt varchar2 itgen_bouw7_exactupdatedat filters on the platform, writable, exactUpdatedAt The last time the entity was updated in Exact Online in ATOM format.
hourType_id int64 Hour Type ID filters on the platform, writable, hourType.id The ID of HourType.
hourType_name varchar2 Hour Type Name filters on the platform, writable, hourType.name The name of the HourType.
hourlyRate varchar2 Hourly Rate filters on the platform, writable, hourlyRate The hourly rate.
id int64 ID filters on the platform, writable, id The ID of the hour log.
invoiceAmount varchar2 Invoice Amount filters on the platform, writable, invoiceAmount The amount that will be shown on the invoice.
isEditable char itgen_bouw7_iseditable filters on the platform, writable, isEditable Whether this hour log is editable and deletable.
isMutable char itgen_bouw7_ismutable filters on the platform, writable, isMutable Whether the hour log booking is mutable. Applicable only if this hour log belongs to a employee, otherwise null.
logDate datetime Log Date filters on the platform, writable, logDate The date for which the hours were logged.
logHours varchar2 Log Hours filters on the platform, writable, logHours The amount of hours logged.
paidOff char Paid Off filters on the platform, writable, paidOff Whether this hour log has been paid off.
projectSecurityLink_code varchar2 Project Security Link Code filters on the platform, writable, projectSecurityLink.code The code of the security code.
projectSecurityLink_id int64 Project Security Link ID filters on the platform, writable, projectSecurityLink.id The unique identifier of the project security link.
projectSecurityLink_name varchar2 Project Security Link Name filters on the platform, writable, projectSecurityLink.name The name of the project security link.
project_city varchar2 Project City filters on the platform, writable, project.city The city of the project.
project_createdAt datetime Project Created at filters on the platform, writable, project.createdAt The creation time of the entity.
project_createdBy varchar2 Project Created by filters on the platform, writable, project.createdBy The user that created the entity.
project_deliveryDate datetime Project Delivery Date filters on the platform, writable, project.deliveryDate Delivery date for the project.
project_endDate datetime Project End Date filters on the platform, writable, project.endDate End date for the project.
project_fullProjectNumber varchar2 Project Full Project Number filters on the platform, writable, project.fullProjectNumber The full project number including year.
project_houseNumber varchar2 Project House Number filters on the platform, writable, project.houseNumber The house number for the project.
project_id int64 Project ID filters on the platform, writable, project.id The ID of the project.
project_information varchar2 Project Information filters on the platform, writable, project.information The information of the project.
project_name varchar2 Project Name filters on the platform, writable, project.name The name of the project.
project_projectNumber varchar2 Project Project Number filters on the platform, writable, project.projectNumber The project number.
project_reference varchar2 Project Reference filters on the platform, writable, project.reference The reference of the project.
project_startDate datetime Project Start Date filters on the platform, writable, project.startDate Start date for the project.
project_streetName varchar2 Project Street Name filters on the platform, writable, project.streetName The street name for the project.
project_updatedAt datetime Project Updated at filters on the platform, writable, project.updatedAt The last updated time of the entity.
project_updatedBy varchar2 Project Updated by filters on the platform, writable, project.updatedBy The user that last updated the entity.
project_zipCode varchar2 Project ZIP Code filters on the platform, writable, project.zipCode The zip code for the project.
startTime varchar2 Start Time filters on the platform, writable, startTime The start time of the workday. Only available if enabled for your organization.
updatedAt datetime Updated At filters on the platform, writable, updatedAt The last updated time of the entity.
updatedBy varchar2 Updated by filters on the platform, writable, updatedBy The user that last updated the entity.

Release Notes

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