JDBC Driver for Zoho Books

Build 22.0.8479


To list, add, update and delete tasks added to a project. Also, get the details of a task.

Table Specific Information


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 本製品.

  • ProjectId supports the '=' comparison.
  • TaskId supports the '=' comparison.
For example:
    SELECT * FROM Tasks WHERE ProjectId = '1894553000000078367' AND TaskId = '1894553000000085708'


Name Type ReadOnly References SupportedOperators Description
TaskId [KEY] String True

ID of a task.

ProjectId String True


ID of the project.

CurrencyId String True


Currency ID of the customer's currency.

TaskName String False

Name of the task.

Description String False

Description of the task.

ProjectName String True

Name of the project.

CustomerId String True


ID of the customer or vendor.

CustomerName String True

Name of the customer or vendor.

BilledHours String True

Total number of billed hours for a task.

BudgetHours Integer False

A project comprises of a single or multiple tasks that need to be completed.

LogTime String True

Time logs for the task.

UnBilledHours String True

Total number of hours which was un-billed.

Rate Decimal False

Rate for task.

Status String True

Status of the task.

IsBillable Boolean True

Check if tasks is billable or not.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479