Power BI Connector for Zendesk

Build 25.0.9539

SuspendedUsers

Query Suspended Users in Zendesk.

Columns

Name Type References Description
Id [KEY] Long Automatically assigned when the ticket is created.
Email String The primary email address of the user. Writeable on create only. On update, a secondary email is added.
Name String The name of the user.
Role String The role of the user. Possible values are end-user, agent, or admin.
Active Boolean False if the user has been deleted.
OrganizationId Long

Organizations.Id

The id of the organization the user is associated with.
Alias String An alias displayed to end users.
Verified Boolean If the identity of the user has been verified or not.
ChatOnly Boolean Whether or not the user is a chat-only agent.
CreatedAt Datetime The time the user was created.
UpdatedAt Datetime The time the user was last updated.
CustomRoleId Long A custom role if the user is an agent on the Enterprise plan.
RoleType String The role id of the user. 0 for custom agents, 1 for light agent and 2 for chat agent.
DefaultGroupId Long The id of the default group of the user. Can only be set on create, not on update.
Details String Any details you want to store about the user, such as an address.
ExternalId String A unique identifier from another system.
LastLoginAt Datetime The last time the user signed in to Zendesk Support.
Locale String The locale of the user.
LocaleId Long The language identifier of the user.
Moderator Boolean Designates whether the user has forum moderation capabilities.
Notes String Any notes you want to store about the user.
OnlyPrivateComments Boolean True if the user can only create private comments.
Phone String The primary phone number of the user.
Photo String photo attachment.
PhotoThumbnails String photo thumbnails.
PhotoInline Boolean If true, the attachment is excluded from the attachment list and the attachment's URL can be referenced within the comment of a ticket. Default is false.
RestrictedAgent Boolean If the agent has any restrictions; false for admins and unrestricted agents, true for other agents.
Shared Boolean If the user is shared from a different Zendesk Support instance. Ticket sharing accounts only.
SharedAgent Boolean If the user is a shared agent from a different Zendesk Support instance. Ticket sharing accounts only.
Signature String The signature of the user. Only agents and admins can have signatures.
Suspended Boolean If 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 user. Only present if your account has user tagging enabled.
TicketRestriction String Specifies which tickets the user has access to. Possible values are: organization, groups, assigned, requested, null.
TimeZone String The time zone of the user.
TwoFactorAuthEnabled Boolean If two factor authentication is enabled.
Url String The API url of the user.
PermissionSet String Used for custom roles in the Enterprise plan. You can only filter by one role id per request.

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