Users
Gets information of users.
Select
The add-in uses the Kintone API to process supported filters. By default, the add-in will process other filters client-side within the add-in.
For example, the following queries are processed server side:
SELECT * FROM Users where id = 1;
SELECT * FROM Users where id in (1,2);
SELECT * FROM Users where Code = 'loginname';
SELECT * FROM Users where code in ('loginname1','loginname2');
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | The user ID. | |
| Code | String | The log in name of the User. | |
| CreatedTime | Datetime | The created datetime of the User. | |
| UpdatedTime | Datetime | The updated datetime of the User. | |
| Valid | Boolean | If the Status of the user is Active or not. | |
| Name | String | The display name of the User. | |
| SurName | String | The last name of the User. | |
| GivenName | String | The first name of the User. | |
| SurNameReading | String | The phonetic reading of the Last name. | |
| GivenNameReading | String | The phonetic reading of the First name. | |
| LocalName | String | The localized display name of the User. | |
| LocalNameLocale | String | The locale of the localized display name of the User. | |
| Timezone | String | The time zone ID of the user's set time zone. | |
| Locale | String | The language setting of the user. | |
| Description | String | The About Me section of the user's profile. | |
| Phone | String | The phone number of the User. | |
| MobilePhone | String | The mobile phone number of the User. | |
| ExtensionNumber | String | The extension number of the User. | |
| String | The Email address of the User. | ||
| SkypeID | String | The Skype ID of the User. | |
| Url | String | The URL section of the user's profile. | |
| EmployeeNumber | String | The Employee Number of the User. | |
| BirthDate | Datetime | The Birthday of the User. | |
| JoinDate | Datetime | The Hire Date of the User. | |
| PrimaryOrganization | Integer | The Department ID of the Priority Department of the User. Set to null if there is no Priority Department. | |
| SortOrder | Integer | The Display Order priority of the User. | |
| CustomItemValues | String | A list of pairs of Custom Field Names and Custom Field Codes. |