TimeEntries
To list, add, update and delete time entries.
Table Specific Information
Select
The connector will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector. By default, response will be showing the time entries of current month only.
- TimeEntryId supports the '=' comparison.
- ProjectId supports the '=' comparison.
- UserId supports the '=' comparison.
- FromDate supports the '=' comparison.
- ToDate supports the '=' comparison.
- TimeEntryFilter supports the '=' comparison.
SELECT * FROM TimeEntries WHERE TimeEntryId = '1894553000000085710' AND UserId = '1894553000000068001' SELECT * FROM TimeEntries WHERE TimeEntryFilter = 'Date.All'
Columns
Name | Type | ReadOnly | References | SupportedOperators | Description |
TimeEntryId [KEY] | String | True |
Id of time entry. | ||
TimerDurationInMinutes | Integer | True |
Timer duration in minutes. | ||
TimerDurationInSeconds | Integer | True |
Timer duration in seconds. | ||
TimerStartedAt | String | True |
Time when the timer started. | ||
BeginTime | String | False |
Time the user started working on this task. | ||
BilledStatus | String | True |
Status which are billed. | ||
CostRate | Decimal | False |
Hourly cost rate. | ||
CanBeInvoiced | Boolean | True |
Check if the entry can be invoiced. | ||
CanContinueTimer | Boolean | True |
Check if the entry can continue the timer. | ||
CanCreateClientApproval | Boolean | True |
Check if the entry can create client approval. | ||
CanCreateUserApproval | Boolean | True |
Check if the entry can create user approval. | ||
CreatedTime | Datetime | True |
Time at which the time entry was created. | ||
CustomerId | String | True |
Contacts.ContactId |
ID of the customer or vendor. | |
CustomerName | String | True |
Name of the customer or vendor. | ||
EndTime | String | False |
Time the user stopped working on this task. | ||
InvoiceId | String | True |
Invoices.InvoiceId |
ID of an invoice. | |
InvoiceNumber | String | True |
Number of an invoice. | ||
IsBillable | Boolean | False |
Check if time entries is billable. | ||
IsClientApprovalNeeded | Boolean | True |
Check if the client approval is needed in time entries. | ||
IsCurrentUser | Boolean | True |
Check if it is a current user of time entries. | ||
IsPaused | Boolean | True |
Check if time entries is paused. | ||
LogDate | Date | False |
Log of date. | ||
LogTime | String | False |
Log of time. | ||
Notes | String | False |
Notes for this time entry. | ||
ProjectHeadId | String | True |
ID of project head. | ||
ProjectHeadName | String | True |
Name of project head. | ||
ProjectId | String | False |
Projects.ProjectId |
Id of a project. | |
ProjectName | String | True |
Name of the project. | ||
StartTimer | String | False |
Start Timer. | ||
TaskId | String | False |
Tasks.TaskId |
ID of task. | |
TaskName | String | True |
Name of the task. | ||
UserId | String | False |
Users.UserId |
Id of a user. | |
UserName | String | True |
Name of user for time entries. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
FromDate | Date |
Date from which the time entries logged to be fetched. |
ToDate | Date |
Date up to which the time entries logged to be fetched. |
TimeEntryFilter | String |
Filter time entries by date and status. 使用できる値は次のとおりです。Date.All, Date.Today, Date.ThisWeek, Date.ThisMonth, Date.ThisQuarter, Date.ThisYear, Date.PreviousDay, Date.PreviousWeek, Date.PreviousMonth, Date.PreviousQuarter, Date.PreviousYear, Date.CustomDate, Status.Unbilled, Status.Invoiced |