Tasks
To list, add, update and delete tasks added to a project. Also, get the details of a task.
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 本製品.
- ProjectId supports the '=' comparison.
- TaskId supports the '=' comparison.
SELECT * FROM Tasks WHERE ProjectId = '1894553000000078367' AND TaskId = '1894553000000085708'
Columns
Name | Type | ReadOnly | References | SupportedOperators | Description |
TaskId [KEY] | String | True |
ID of a task. | ||
ProjectId | String | True |
Projects.ProjectId |
ID of the project. | |
CurrencyId | String | True |
Currencies.CurrencyId |
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 |
Contacts.ContactId |
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. |