Returns end-user requests submitted as tickets, including subject, status, priority, and assignment details.

View-Specific Information

Select

The following query is processed server-side while other filters are processed client-side within the provider:

SELECT * FROM Requests WHERE Id = '123'

Columns

Name	Type	References	Description
Id [KEY]	Long		The Id automatically assigned when the request is created.
Subject	String		The value of the subject field for this request if the subject field is visible to end users; a truncated version of the description otherwise.
Description	String		The first comment on the request.
Status	String		The state of the request, new, open, pending, hold, solved, closed.
Priority	String		The priority of the request, low, normal, high, urgent.
Type	String		The type of the request, question, incident, problem, task.
OrganizationId	Long	Organizations.Id	The organization of the requester.
RequesterId	Long	Users.Id	The Id of the requester.
AssigneeId	Long	Users.Id	The Id of the assignee if the field is visible to end users.
GroupId	Long	Groups.Id	The Id of the assigned group if the field is visible to end users.
CollaboratorIds	String		The Ids of users who are currently CC'd on the ticket.
ViaChannel	String		The channel through which the ticket or event was created, such as web, mobile, rule, or system.
ViaSource	String		For some channels a source object gives more information about how or why the ticket or event was created.
IsPublic	Boolean		Indicates whether any comments on the request are public.
DueAt	Date		When the task is due (only applies if the request is of type 'task').
CanBeSolvedByMe	Boolean		Indicates whether the end user can mark the request as solved.
Solved	Boolean		Indicates whether the request is solved. An end user can set this if CanBeSolvedByMe is true for that user.
TicketFormId	Long	TicketForms.Id	The numeric id of the ticket form associated with this request if the form is visible to end users - only applicable for enterprise accounts.
Recipient	String		The original recipient e-mail address of the request.
FollowupSourceId	Integer	Tickets.Id	The Id of the original ticket if this request is a follow-up ticket.
CreatedAt	Datetime		The time the request was created.
UpdatedAt	Datetime		The time of the last update of the request.
Url	String		The API URL of this request.
CustomFields	String		Custom fields for the request.
CustomStatusId	Long		The custom ticket status Id of the ticket.
EmailCcIds	String		The Ids of users who are currently email CCs on the ticket.