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. |