Tasks
Retrieve Tasks data from Zoho Desk.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Unique identifier of the task | |
| TicketId [KEY] | String | False |
ID of the ticket associated with the task | |
| AssigneeFirstName | String | True |
First name of the task assignee | |
| AssigneeLastName | String | True |
Last name of the task assignee | |
| ModifiedByFirstName | String | True |
First name of the user who last modified the task | |
| ModifiedByLastName | String | True |
Last name of the user who last modified the task | |
| Subject | String | False |
Subject or title of the task | |
| Status | String | False |
Current status of the task | |
| StatusType | String | True |
Type of status for the task | |
| ActivityType | String | True |
Type of activity for the task | |
| Priority | String | False |
Priority level of the task | |
| CreatedTime | Datetime | True |
Timestamp when the task was created | |
| ModifiedTime | Datetime | True |
Timestamp when the task was last modified | |
| Category | String | True |
Category classification of the task | |
| Description | String | False |
Detailed description of the task | |
| AssigneeId | String | False |
ID of the user assigned to the task | |
| AssigneePhotoUrl | String | True |
Profile photo URL of the task assignee | |
| CompletedTime | Datetime | True |
Timestamp when the task was completed | |
| Contact | String | True |
Contact information associated with the task | |
| ContactId | String | False |
ID of the contact associated with the task | |
| CreatorId | String | True |
ID of the user who created the task | |
| DepartmentId | String | False |
ID of the department | |
| Direction | String | True |
Direction of the task activity | |
| DueDate | Datetime | False |
Due date for task completion | |
| IsCommented | Boolean | True |
Indicates whether the task has comments | |
| IsSpam | Boolean | True |
Indicates whether the task is marked as spam | |
| IsTrashed | Boolean | True |
Indicates whether the task has been moved to trash | |
| ModifiedById | String | True |
ID of the user who last modified the task | |
| ModifiedByPhotoUrl | String | True |
Profile photo URL of the last modifier | |
| ModifiedByEmail | String | True |
Email address of the user who last modified the task | |
| OwnerId | String | False |
ID of the task owner | |
| StartTime | Datetime | True |
Start time for the task | |
| Team | String | True |
Team assigned to the task | |
| Ticket | String | True |
Ticket information associated with the task | |
| LayoutId | String | True |
ID of the layout format for the task | |
| WebUrl | String | True |
Web URL to access the task |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| IsCompleted | Boolean |
Filter by task completion status |
| Include | String |
Additional information to include in the response |
| ViewId | String |
ID of the view to filter tasks |
| FilterDueDate | String |
Allowed values are Overdue, Tomorrow, CurrentWeek, CurrentMonth and Today |