Cmdlets for Zoho Books

Build 24.0.8963

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'

Insert

INSERT can be executed by specifying TaskName and ProjectId. The columns that are not read-only can be inserted optionally. The following is an example of how to insert into this table.

INSERT INTO Tasks(ProjectId, TaskName) values ('1484772000000068020','Test1')

Update

UPDATE can be executed by specifying the TaskId and ProjectId in the WHERE Clause. The columns that are not read-only can be updated. For example:

UPDATE Tasks set Description = 'test' where TaskId = '1484772000000147005' and ProjectId = '1484772000000068020'

Delete

DELETE can be executed by specifying the TaskId and ProjectId in the WHERE Clause For example:

DELETE FROM Tasks where TaskId = '1484772000000147005' and ProjectId = '1484772000000068020'

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963