Tasks
Retrieves list of 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 | References | SupportedOperators | Description |
| TaskId [KEY] | String | ID of a task. | ||
| ProjectId | String |
Projects.ProjectId | ID of the project. | |
| CurrencyId | String |
Currencies.CurrencyId | Currency ID of the customer's currency. | |
| TaskName | String | Name of the task. | ||
| Description | String | Description of the task. | ||
| ProjectName | String | Name of the project. | ||
| CustomerId | String |
Contacts.ContactId | ID of the customer or vendor. | |
| CustomerName | String | Name of the customer or vendor. | ||
| BilledHours | String | Total number of billed hours for a task. | ||
| LogTime | String | Time logs for the task. | ||
| UnBilledHours | String | Total number of hours which was un-billed. | ||
| Rate | Decimal | Rate for task. | ||
| Status | String | Status of the task. | ||
| IsBillable | Boolean | Check if tasks is billable or not. |