Users
Query information regarding users.
View-Specific Information
Select
The connector 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 connector.
- 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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Type | String | Limit the users returned to the ones of this type
使用できる値は次のとおりです。AllUsers, ActiveUsers, DeactiveUsers, ConfirmedUsers, NotConfirmedUsers, DeletedUsers, ActiveConfirmedUsers, AdminUsers, ActiveConfirmedAdmins, CurrentUser |