Returns collaborators associated with tickets, including user profile, role, and contact details.

View-Specific Information

Select

The provider uses the Zendesk API to process WHERE clause conditions built with the TicketId column, which supports the = operator.

The rest of the filter is executed client-side within the provider.

For example, the following query is processed server-side:

SELECT * FROM Collaborators WHERE TicketId = '123' 

Columns

Name	Type	References	Description
Id [KEY]	Long		The unique Id of the collaborator, automatically assigned when the user is created.
TicketId [KEY]	Integer	Tickets.Id	The Id of the ticket the collaborator is associated with.
Email	String		The primary email address of the collaborator. Writeable on create only. On update, a secondary email is added.
Name	String		The name of the collaborator.
Role	String		The role of the collaborator. Possible values are end-collaborator, agent, or admin.
Active	Boolean		Indicates whether the collaborator is active. Returns false if the collaborator has been deleted.
OrganizationId	Long	Organizations.Id	The Id of the organization the collaborator is associated with.
Alias	String		An alias displayed to end users.
Verified	Boolean		Indicates whether the identity of the collaborator has been verified.
ChatOnly	Boolean		Indicates whether the collaborator is a chat-only agent.
CreatedAt	Datetime		The time the collaborator was created.
UpdatedAt	Datetime		The time the collaborator was last updated.
CustomRoleId	Long	CustomAgentRoles.Id	The Id of the custom role assigned to the collaborator, if the collaborator is an agent on the Enterprise plan.
RoleType	String		The numeric role Id of the collaborator. Possible values are 0 for custom agents, 1 for light agents, and 2 for chat agents.
DefaultGroupId	Long	Groups.Id	The Id of the default group of the collaborator. Can only be set on create, not on update.
Details	String		Any details you want to store about the collaborator, such as an address.
ExternalId	String		A unique identifier from another system.
LastLoginAt	Datetime		The last time the collaborator signed in to Zendesk Support.
Locale	String		The locale of the collaborator.
LocaleId	Long	Locales.Id	The Id of the language locale for the collaborator.
Moderator	Boolean		Designates whether the collaborator has forum moderation capabilities.
Notes	String		Any notes you want to store about the collaborator.
OnlyPrivateComments	Boolean		Indicates whether the collaborator can only create private comments.
Phone	String		The primary phone number of the collaborator.
PhotoId	Long		The unique Id of the photo attachment, automatically assigned when the attachment is created.
PhotoFileName	String		The name of the image file.
PhotoContentUrl	String		A full URL where the attachment image file can be downloaded.
PhotoContentType	String		The content type of the image. Example value: image/png.
PhotoSize	Integer		The size of the image file in bytes.
PhotoThumbnailsId	Long		The unique Id of the photo thumbnail attachment.
PhotoThumbnailsFileName	String		The file name of the photo thumbnail image.
PhotoThumbnailsContentUrl	String		The full URL where the photo thumbnail file can be downloaded.
PhotoThumbnailsContentType	String		The content type of the photo thumbnail image, such as image/png.
PhotoThumbnailsSize	Integer		The size of the photo thumbnail file in bytes.
PhotoInline	Boolean		Indicates whether the attachment is excluded from the attachment list. When true, the attachment's URL can be referenced within the comment of a ticket.
RestrictedAgent	Boolean		Indicates whether the agent has restrictions. Returns false for admins and unrestricted agents, and true for other agents.
Shared	Boolean		Indicates whether the collaborator is shared from a different Zendesk Support instance. Applies to ticket sharing accounts only.
SharedAgent	Boolean		Indicates whether the collaborator is a shared agent from a different Zendesk Support instance. Applies to ticket sharing accounts only.
Signature	String		The signature of the collaborator. Only agents and admins can have signatures.
Suspended	Boolean		Indicates whether the agent is suspended. Tickets from suspended users are also suspended, and these users cannot sign in to the end-user portal.
Tags	String		The tags of the collaborator. Only present if your account has collaborator tagging enabled.
TicketRestriction	String		Specifies which tickets the collaborator has access to. Possible values are: organization, groups, assigned, requested, null.
TimeZone	String		The time zone of the collaborator.
TwoFactorAuthEnabled	Boolean		Indicates whether two-factor authentication is enabled for the collaborator.
Url	String		The API URL of the collaborator.