Tasks
To list, add, update and delete tasks added to a project. Also, get the details of a task.
Table Specific Information
Select
The 本製品 uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:
- ProjectId supports the '=' comparison.
- TaskId supports the '=' comparison.
The rest of the filter is executed client-side in the 本製品.
For example:
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. |