Power BI Connector for Zoho Books

Build 20.0.7654

Tasks

Retrieves list of tasks added to a project. Also, get the details of a task.

Table Specific Information

Select

The {i 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 {i.

  • ProjectId supports the '=' comparison.
  • TaskId supports the '=' comparison.
For example:
    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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654