Get a collection of users.

Table Specific Information

The adapter uses the API to process some of the filters. The adapter processes other filters client-side within the adapter. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause inconsistent data. For example, the following queries are processed server side.

• ID supports the '=, IN' operators.
• IsPending supports the '=' operators.
• IsGuest supports the '=' operators.
• Email supports the '=, IN' operators.

SELECT

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 = 'test@cdata.com'
SELECT * FROM Users WHERE Email IN ('test@cdata.com','test@gmail.com')

Columns

Name	Type	References	Description
Id [KEY]	Int		The user's unique identifier.
TeamsIds	String	Teams.Id	A list of teams unique identifiers to which the user belongs.
Name	String		The user's name.
Phone	String		The user's phone number.
Birthday	Date		The user's birthday.
CountryCode	String		The user's country code.
CreatedAt	Datetime		The user's creation date.
Email	String		The user's email.
Enabled	Bool		Whether or not the user is enabled.
EncryptApiToken	String		The token of the user for email to board.
IsAdmin	Bool		Whether or not the user is an account admin.
IsGuest	Bool		Whether or not the user is a guest.
IsPending	Bool		Whether or not the user is a pending user
IsVerified	Bool		Whether or not the user verified their email.
IsViewOnly	Bool		Whether or not the user is a view only user.
JoinDate	Date		The date the user joined the account.
Location	String		The user's location.
MobilePhone	String		The user's mobile phone number.
PhotoOriginal	String		The user's photo in the original size.
PhotoSmall	String		The user's photo in small size (150x150).
PhotoThumb	String		The user's photo in thumbnail size (100x100).
PhotoThumbSmall	String		The user's photo in small thumbnail size (50x50).
PhotoTiny	String		The user's photo in tiny size (30x30).
TimeZoneIdentifier	String		The user's timezone identifier.
Title	String		The user's title.
Url	String		The user's profile url.
UtcHoursDiff	Int		The user's utc hours difference.
AccountFirstDayOfTheWeek	String		The first day of the week for the account (sunday / monday)
AccountId	Int		The account's unique identifier.
AccountLogo	String		The account's logo.
AccountName	String		The account's name.
AccountPlanMaxUsers	Int		The maximum users allowed in the plan.
AccountPlanPeriod	String		The plan's time period.
AccountPlanTier	String		The plan's tier.
AccountPlanVersion	Int		The plan's version.
AccountShowTimelineWeekends	Bool		Whether or not to show weekends in the timeline.
AccountSlug	String		The account's slug.
AccountTier	String		The account's tier.