Tableau Connector for Zoho Books

Build 22.0.8479

Tasks

To list, add, update and delete tasks added to a project. Also, get the details of a task.

Table Specific Information

Select

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

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479