TicketTimeEntry
Retrieve TicketTimeEntry data from Zoho Desk.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Id | |
| CustomFields | String | True |
Custom fields | |
| OwnerFirstName | String | True |
Owner firstname | |
| OwnerLastName | String | True |
Owner lastname | |
| OwnerName | String | True |
Owner name | |
| ParentSubject | String | True |
Parent subject | |
| BillingType | String | True |
Billingtype | |
| ParentType | String | True |
Parent type | |
| RequestChargeType | String | True |
Requestchargetype | |
| CreatedTime | Datetime | True |
Createdtime | |
| Description | String | False |
Description | |
| AdditionalCost | Decimal | True |
Additionalcost | |
| AgentCostPerHour | Decimal | True |
Agentcostperhour | |
| CreatedBy | String | True |
Createdby | |
| CreatorId | String | True |
Creatorid | |
| LayoutId | String | True |
Layoutid | |
| RequestId | String | True |
Requestid | |
| TaskId | String | True |
taskid | |
| DepartmentId | String | True |
Departmentid | |
| ExecutedTime | Datetime | False |
Executedtime | |
| FixedCost | Decimal | True |
Fixedcost | |
| HoursSpent | Integer | False |
Hoursspent | |
| InvoiceId | String | True |
Invoiceid | |
| IsBillable | Boolean | False |
Isbillable | |
| IsTrashed | Boolean | True |
Istrashed | |
| MinutesSpent | Integer | False |
Minutesspent | |
| Mode | String | True |
Mode | |
| CustomFields | String | True |
CustomFields | |
| OwnerId | String | False |
Owner id | |
| OwnerPhotoUrl | String | True |
Owner photourl | |
| ParentId | String | True |
Parent id | |
| ParentTicketNumber | Long | True |
Parent ticketnumber | |
| SecondsSpent | Integer | False |
Secondsspent | |
| TotalCost | Decimal | True |
Totalcost | |
| TicketId | String | False |
Unique identifier of the support ticket |
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 |
| FilterBillStatus | String |
Filter time entries by billing status The allowed values are nonBillable, billable, billed. |
| CreatedTimeRange | String |
Date range to filter time entries by creation time (e.g., 2024-01-01T00:00:00.000Z,2024-12-31T23:59:59.999Z) |
| Include | String |
Additional information to include in the response The allowed values are owner. |
| ModifiedTimeRange | String |
Date range to filter time entries by modification time (e.g., 2024-01-01T00:00:00.000Z,2024-12-31T23:59:59.999Z) |
| FetchModule | String |
Allowed values are tickets,tasks |