JDBC Driver for Zoho Projects

Build 22.0.8462

Tasks

Gets all the tasks in the given project. It fetches only the main tasks and not the subtasks.

Select

Columns that support the = operator:
  • Id
  • CreatedBy
  • MilestoneId
  • Priority
  • TasklistId
  • Owner
  • Status
  • Time
  • LastModifiedTime
  • ViewId

  • CreatedDate and LastModifiedTime support: ORDER
For example, the following query is processed server side:
SELECT * FROM Tasks WHERE MilestoneId = '12345600000123' AND Priority = 'High' ORDER BY CreatedDate

Insert

To create a new Task you can specify the following fields:

  • Name
  • Description
  • Owners
  • Duration
  • DurationType
  • EndDate
  • Priority
  • StartDate
  • TasklistId
  • Work
  • GroupNameAssociatedTeamsAnyTeam
  • RatePerHour
  • ReminderString
  • Recurrence
  • BudgetValue
  • BudgetThreshold


INSERT INTO Tasks (Name, Description, Duration, DurationType, Priority,  BudgetValue)
VALUES ('New Task #2', 'This is a test description', '5', 'hrs', 'High', '1000')

Update

To update a Task specify the Id field.

UPDATE Tasks SET Priority = 'Low' WHERE ID = '123456000000034003'

Delete

Tasks can be deleted by providing the Id and issuing a DELETE statement.

DELETE FROM Tasks WHERE Id = '123456000000034003'

Columns

Name Type ReadOnly Description
Id [KEY] String False

Task Id.

Name String False

Task Name.

Key String False

Task Key.

BillingType String False

Task Billing Type.

Completed Boolean False

Task Completed.

CreatedBy String False

Task Created By.

CreatedByEmail String False

Task Created By Email.

CreatedByZpuid String False

Task Created By Zpuid.

CreatedPerson String False

Task Created Person.

CreatedDate Date False

Task Created Date.

CreatedDateTime Datetime False

Task Created Date Time.

Description String False

Task Description.

Owners String False

Task Owners.

Duration String False

Task Duration.

DurationType String False

Task Duration Type.

The allowed values are days, hrs.

EndDate Date False

Task End Date.

EndDateTime Datetime False

Task End Date Time.

CommentAdded Boolean False

Task Comment Added.

DocsAssociated Boolean False

Task Docs Associated.

ForumAssociated Boolean False

Task Forum Associated.

RecurrenceSet Boolean False

Task Recurrence Set.

ReminderSet Boolean False

Task Reminder Set.

Parent Boolean False

Task Parent.

LastUpdatedDate Date False

Task Last Updated Date.

LastUpdatedDateTime Datetime False

Task Last Updated Date Time.

LinkSelfUrl String False

Task Link Self Url.

LinkTimesheetUrl String False

Task Link Timesheet Url.

LinkWebUrl String False

Task Link Web Url.

LogHoursBillableHours String False

Task Log Hours Billable Hours.

LogHoursNonBillableHours String False

Task Log Hours Non Billable Hours.

MilestoneId String False

Task Milestone Id.

OrderSequence Integer False

Task Order Sequence.

PercentComplete String False

Task Percent Complete.

Priority String False

Task Priority.

The allowed values are none, low, medium, high.

StartDate Date False

Task Start Date.

StartDateTime Datetime False

Task Start Date Time.

StatusColorCode String False

Task Status Color Code.

StatusName String False

Task Status Name.

StatusId String False

Task Status Id.

StatusType String False

Task Status Type.

Subtasks Boolean False

Task Subtasks.

TaskFollowers String False

Task Task Followers.

TaskFollowerSize Integer False

Task Task Follower Size.

TasklistId String False

Tasklist Id.

TasklistName String False

Tasklist Name.

Work String False

Task Work.

WorkForm String False

Task Work Form.

WorkType String False

Task Work Type.

The allowed values are work_hrs_per_day.

GroupNameAssociatedTeamsAnyTeam String False

Task Group Name Associated Teams Any Team.

GroupNameAssociatedTeamsCount Integer False

Task Group Name Associated Teams Count.

GroupNameIsTeamUnassigned Boolean False

Task Group Name Is Team Unassigned.

RatePerHour String False

Task Rate Per Hour.

ReminderString String False

Task Reminder String.

Recurrence String False

Task Recurrence.

BudgetValue String False

Task Budget Value.

BudgetThreshold String False

Task Budget Threshold.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Owner String

Task Owner.

Status String

Task Status.

The allowed values are completed, notcompleted.

Time String

Task Time.

The allowed values are overdue, today, tomorrow.

LastModifiedTime Datetime

Task Last Modified Time.

ViewId String

Task View Id.

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