CData Python Connector for Zoho Books

Build 20.0.7740

TimeEntries

Retrieves list of all time entries.

Table Specific Information

Select

The 本製品 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 本製品. 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.
For example:
    SELECT * FROM TimeEntries WHERE TimeEntryId = '1894553000000085710' AND UserId = '1894553000000068001'

    SELECT * FROM TimeEntries WHERE TimeEntryFilter = 'Date.All'

Columns

Name Type References SupportedOperators Description
TimeEntryId [KEY] String Id of time entry.
TimerDurationInMinutes Integer Timer duration in minutes.
TimerDurationInSeconds Integer Timer duration in seconds.
TimerStartedAt String Time when the timer started.
BeginTime String Time the user started working on this task.
BilledStatus String Status which are billed.
CanBeInvoiced Boolean Check if the entry can be invoiced.
CanContinueTimer Boolean Check if the entry can continue the timer.
CanCreateClientApproval Boolean Check if the entry can create client approval.
CanCreateUserApproval Boolean Check if the entry can create user approval.
CreatedTime Datetime Time at which the time entry was created.
CustomerId String

Contacts.ContactId

ID of the customer or vendor.
CustomerName String Name of the customer or vendor.
EndTime String Time the user stopped working on this task.
InvoiceId String

Invoices.InvoiceId

ID of an invoice.
InvoiceNumber String Number of an invoice.
IsBillable Boolean Check if time entries is billable.
IsClientApprovalNeeded Boolean Check if the client approval is needed in time entries.
IsCurrentUser Boolean Check if it is a current user of time entries.
IsPaused Boolean Check if time entries is paused.
LogDate Date Log of date.
LogTime String Log of time.
Notes String Notes for this time entry.
ProjectHeadId String ID of project head.
ProjectHeadName String Name of project head.
ProjectId String

Projects.ProjectId

Id of a project.
ProjectName String Name of the project.
TaskId String

Tasks.TaskId

ID of task.
TaskName String Name of the task.
UserId String

Users.UserId

Id of a user.
UserName String 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

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7740