Users
Query information regarding users.
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 | A unique numeric identifier for the user. |
| FirstName | String | The first name of the user. |
| LastName | String | The last name of the user. |
| FullName | String | The full name of the user. |
| String | The email of the user. | |
| RoleName | String | The name of the role the user has. |
| RoleId | String | The Id of the role the user has. |
| ProfileName | String | The name of the profile the user has. |
| ProfileId | String | The Id of the profile the user has. |
| Country | String | The country where the user is situated. |
| City | String | The city where the user is situated. |
| Street | String | The street where the user is situated. |
| State | String | The state where the user is situated. |
| Zip | String | The zip where the user is situated. |
| Alias | String | The alias of the user. |
| Signature | String | The signature of the user. |
| NameFormat | String | The format of the name of the user. |
| PersonalAccount | Boolean | Whether this user has a personal account or not. |
| DefaultTabGroup | String | The default tab group for this user. |
| CountryLocale | String | The default country locale of the user. |
| Fax | String | The fax of the user. |
| Website | String | The website of the user. |
| Mobile | String | The mobile phone number of the user. |
| Phone | String | The phone number of the user. |
| Dob | String | The date of birth of the user. |
| Status | String | The status of the user. |
| Confirm | Boolean | Whether this user has confirmed his email or not. |
| Language | String | The Language of the user. |
| Locale | String | The locale of the user. |
| TimeFormat | String | The default time format of the user. |
| DateFormat | String | The default date format of the user. |
| DecimalSeparator | String | The locale of the default decimal separator of the user. |
| TimeZone | String | The time zone of the user. |
| Zuid | String | The default ZUID of the user. |
| Territories | String | A comma separeted string of the user's territories. |
| CreatedByName | String | The name of the user who created this user. |
| CreatedById | String | The id of the user who created this user. |
| CreatedAt | Datetime | The time this user was created. |
| ModifiedByName | String | The name of the user who modified this user. |
| ModifiedById | String | The id of the user who modified this user. |
| ModifiedAt | Datetime | The time this user was last modified. |
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 | Limit the users returned to the ones of this type
The allowed values are AllUsers, ActiveUsers, DeactiveUsers, ConfirmedUsers, NotConfirmedUsers, DeletedUsers, ActiveConfirmedUsers, AdminUsers, ActiveConfirmedAdmins, CurrentUser. |