Users
Lists user accounts along with details like email, profile, role, and login status.
View-Specific Information
Select
The driver will use the Zoho CRM API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the driver.
- Id supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM Users WHERE Id = '3152079000000150015'
Columns
| Name | Type | Description |
| Id [KEY] | String | Unique numeric identifier for the user. |
| FirstName | String | First name of the user. |
| LastName | String | Last name of the user. |
| FullName | String | Full name of the user. |
| String | Email address of the user. | |
| RoleName | String | Name of the role assigned to the user. |
| RoleId | String | Unique identifier of the role assigned to the user. |
| ProfileName | String | Name of the profile assigned to the user. |
| ProfileId | String | Unique identifier of the profile assigned to the user. |
| Country | String | Country where the user is located. |
| City | String | City where the user is located. |
| Street | String | Street where the user is located. |
| State | String | State where the user is located. |
| Zip | String | Postal code where the user is located. |
| Alias | String | Alias name associated with the user. |
| Signature | String | User's email or document signature. |
| NameFormat | String | Preferred format for displaying the user's name. |
| PersonalAccount | Boolean | Indicates whether the user has a personal account. |
| DefaultTabGroup | String | Default tab group assigned to the user. |
| CountryLocale | String | Country locale setting for the user. |
| Fax | String | Fax number of the user. |
| Website | String | Website associated with the user. |
| Mobile | String | Mobile phone number of the user. |
| Phone | String | Primary phone number of the user. |
| Dob | String | Date of birth of the user. |
| Status | String | Current status of the user. |
| Confirm | Boolean | Indicates whether the user has confirmed their email address. |
| Language | String | Language preference of the user. |
| Locale | String | Locale setting for the user. |
| TimeFormat | String | Preferred format for displaying time. |
| DateFormat | String | Preferred format for displaying dates. |
| DecimalSeparator | String | Preferred decimal separator symbol for numeric values. |
| TimeZone | String | Time zone configured for the user. |
| Zuid | String | Zoho User ID (ZUID) associated with the user. |
| Territories | String | Comma-separated list of territories assigned to the user. |
| CreatedByName | String | Name of the user who created this user record. |
| CreatedById | String | Identifier of the user who created this user record. |
| CreatedAt | Datetime | Timestamp when the user record was created. |
| ModifiedByName | String | Name of the user who last modified this user record. |
| ModifiedById | String | Identifier of the user who last modified this user record. |
| ModifiedAt | Datetime | Timestamp when the user record was last modified. |
| CustomizeInfoNotesDesc | String | Custom notes description for the user interface. |
| CustomizeInfoShowRightPanel | Boolean | Indicates whether the right panel is shown in the user interface. |
| CustomizeInfoShowLeftPanel | Boolean | Indicates whether the left panel is shown in the user interface. |
| CustomizeInfoBcView | String | Custom setting for business card view layout. |
| CustomizeInfoShowHome | Boolean | Indicates whether the home screen is shown to the user. |
| CustomizeInfoShowDetailView | Boolean | Indicates whether the detail view is shown to the user. |
| CustomizeInfoUnpinRecentItem | String | Custom setting for unpinning recently accessed items. |
| Microsoft | Boolean | Indicates whether the user is linked to a Microsoft account. |
| ThemeBackground | String | Current background theme applied to the user interface. |
| ThemeNewBackground | String | Updated background theme applied to the user interface. |
| ThemeNormalTabBackground | String | Background color for non-selected tabs. |
| ThemeNormalTabFontColor | String | Font color for non-selected tabs. |
| ThemeScreen | String | Theme configuration for the main screen layout. |
| ThemeSelectedTabBackground | String | Background color for the currently selected tab. |
| ThemeSelectedTabFontColor | String | Represents the font color used for the selected tab in the user's chosen theme. |
| ThemeType | String | Type of theme being used by the user. |
| ReportingToName | String | Name of the user to whom this user reports. |
| ReportingToId | String | Identifier of the user to whom this user reports. |
| Offset | Integer | Record offset value used for pagination. |
| SandboxDeveloper | Boolean | Indicates whether the user is marked as a sandbox developer. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Type | String | Restricts results to users of the specified type.
The allowed values are AllUsers, ActiveUsers, DeactiveUsers, ConfirmedUsers, NotConfirmedUsers, DeletedUsers, ActiveConfirmedUsers, AdminUsers, ActiveConfirmedAdmins, CurrentUser. |