API Data Provider - Online Help

Tickets

List tickets.

Columns

Name Type References
Id [KEY] Long
Subject String
Description String
Priority Long
Urgency Long
Status Long
Type String
Source Long
Category String
SubCategory String
IsDeleted Boolean
IsSpam Boolean
DepartmentId Long

Departments.Id

GroupId Long
Attachments String
CcEmails String
DueBy Datetime
EmailConfigId String
FrDueBy Datetime
IsFrEscalated Boolean
FwdEmails String
Impact Long
IsEscalated Boolean
ItemCategory String
ReplyCcEmails String
RequesterId Long

Requesters.Id

RequesterName String
RequesterEmail String
RequesterPhone String
RequesterMobile String
ResponderId String
SlaPolicyId Long
ToEmails String
CustomFields String
CreatedAt Datetime
UpdatedAt Datetime
ClosedAt Datetime
ResolvedAt Datetime
FirstRespondedAt Datetime
Tags String
Problem String
Change String
RelatedTickets String
RequestedForId Long

Requesters.Id

ResolutionNotes String
ResolutionNotesHtml String
IsCreatedWithinBusinessHours Boolean
ApprovalStatus Long
ApprovalStatusName String
SkillsetId Long
TasksDependencyType Long
WorkspaceId Long

Workspaces.Id

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770.0