Users
Lists user accounts along with details like email, profile, role, and login status.
View-Specific Information
Select
The add-in 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 add-in.
- 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. |