Retrieves a collection of users, including their details and roles.

View-Specific Information

SELECT

The connector uses the Monday API to process some of the filters. The connector processes other filters client-side within the connector.

• Id supports the '=','IN' comparison operators.
• Email supports the '=','IN' comparison operators.
• IsGuest supports the '=' comparison operator.
• IsPending supports the '=' comparison operator.
• NonActive supports the '=' comparison operator.
• TeamsIds supports the '=','IN' comparison operators when filtering for users that belong to a single team.

For example, the following queries are processed server side:

SELECT * FROM Users ORDER BY CreatedAt DESC
SELECT * FROM Users WHERE IsPending = true
SELECT * FROM Users WHERE IsGuest = true
SELECT * FROM Users WHERE Id = '27278379'
SELECT * FROM Users WHERE Id IN ('27278379', '27278377')
SELECT * FROM Users WHERE Email = '[email protected]'
SELECT * FROM Users WHERE Email IN ('[email protected]', '[email protected]')
SELECT * FROM Users WHERE TeamsIds = '915408'

Columns

Name	Type	References	Description
Id [KEY]	String		The unique identifier for the user, used to reference the user across the system.
TeamsIds	String		A list of unique identifiers for the teams the user belongs to, helping to track user membership within teams.
Name	String		The full name of the user, used for identification and display purposes.
Phone	String		The user's primary phone number, used for contact and verification.
Birthday	Date		The user's birthdate, which can be used for age verification or personalization.
CurrentLanguage	String		The language currently selected by the user for their interface preferences.
CountryCode	String		The two-letter country code of the user's location, based on their country of residence.
CreatedAt	Datetime		The timestamp for when the user account was created, used for tracking account age and activity.
LastActivity	Datetime		The most recent date and time when the user was active, providing insight into user engagement.
Email	String		The user's email address, used for communication, notifications, and account recovery.
Enabled	Bool		Indicates whether the user account is currently active and able to perform actions.
IsAdmin	Bool		Indicates if the user has administrative privileges and can manage account settings and users.
IsGuest	Bool		Indicates if the user has guest access, typically with restricted permissions.
IsPending	Bool		Indicates whether the user account is pending approval or activation.
IsVerified	Bool		Indicates if the user has verified their email address, confirming their identity.
IsViewOnly	Bool		Indicates if the user has view-only access, meaning they can view but not modify data.
JoinDate	Date		The date when the user first joined the account, useful for understanding user tenure.
Location	String		The geographic location of the user, which may affect settings like time zone or language.
MobilePhone	String		The user's mobile phone number, used for notifications or secondary contact.
PhotoOriginal	String		The URL for the user's photo in its original size, typically used in larger display contexts.
PhotoSmall	String		The URL for the user's photo in a smaller size (150x150), suitable for smaller profile views.
PhotoThumb	String		The URL for the user's thumbnail photo (100x100), used in list views and smaller displays.
PhotoThumbSmall	String		The URL for the user's small thumbnail photo (50x50), typically used for icons or minimal views.
PhotoTiny	String		The URL for the user's tiny photo (30x30), used for extremely small icons or visual references.
TimeZoneIdentifier	String		The user's time zone identifier, used for scheduling and displaying time-related information.
Title	String		The user's job title or designation, providing context about their role within the organization.
Url	String		The URL to the user's profile page, typically used for linking to the user's detailed information.
UtcHoursDiff	Int		The difference in hours between the user's local time and UTC, used for adjusting timestamps and scheduling.
SignUpProductKind	String		The product or service that the user initially signed up for, helping to categorize user plans.
AccountFirstDayOfTheWeek	String		The day of the week (Sunday or Monday) designated as the start of the week for the account, affecting calendar views.
AccountId	String		The unique identifier for the account to which the user belongs, used to associate users with specific accounts.
AccountLogo	String		The URL for the account's logo, displayed in the UI to represent the account.
AccountName	String		The name of the account, used to identify the account in the system.
AccountPlanMaxUsers	Int		The maximum number of users allowed under the current account plan, indicating the plan's user capacity.
AccountPlanPeriod	String		The duration of the account's plan (for example, monthly, annually), which helps track billing cycles.
AccountPlanTier	String		The tier of the account's subscription plan (for example, Basic, Premium), defining the features available.
AccountPlanVersion	Int		The version number of the current plan, useful for tracking plan changes over time.
AccountShowTimelineWeekends	Bool		Indicates whether weekends are included in the account's timeline views.
AccountSlug	String		A URL-friendly version of the account name, typically used for the account's web address or identifier.
AccountTier	String		The account's subscription tier, which determines available features and limitations.
AccountCountryCode	String		The two-letter ISO 3166 country code for the account's registered country, helping to localize settings.
AccountSignUpProductKind	String		The product or service the account initially signed up for, which may determine the account's default settings.
AccountProducts	String		A list of active products or services associated with the account, showing the account's current offerings.
OutOfOfficeActive	Bool		Indicates whether the user's out-of-office status is currently active, affecting their availability.
OutOfOfficeDisableNotifications	Bool		Indicates if notifications are disabled while the user is out of office.
OutOfOfficeStartDate	Date		The date when the user's out-of-office status began, marking the start of their absence.
OutOfOfficeEndDate	Date		The date when the user's out-of-office status ends, marking the return to active status.
OutOfOfficeType	String		The type of out-of-office status, such as vacation or personal leave, used to specify the reason for absence.
NonActive	Bool		Indicates whether non-active users should be included in account queries, useful for generating reports on inactive users.