Users
Returns detailed user profile information from the Cybozu directory to support identity synchronization and permission audits.
Select
本製品 はKintone API を使用してサポート対象のフィルタを処理します。デフォルトでは、本製品 はクライアント側で本製品 内で他のフィルタを処理します。
例えば、次のクエリはサーバー側で処理されます。
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 | Unique identifier for the user, used to reference the user across related records and organizational structures. | |
| Code | String | Login name associated with the user, used for authentication and identifying the user in queries. | |
| CreatedTime | Datetime | Date and time when the user account was first created, supporting audit and lifecycle tracking. | |
| UpdatedTime | Datetime | Date and time when the user account was last modified, helping track profile updates or administrative changes. | |
| Valid | Boolean | Indicates whether the user's status is active, allowing systems to filter out deactivated or archived accounts. | |
| Name | String | Primary display name of the user as it appears in directories and user-facing applications. | |
| SurName | String | Family name of the user, typically used in formal identification and directory listings. | |
| GivenName | String | First name of the user, representing the personal portion of the user's full name. | |
| SurNameReading | String | Phonetic reading of the user's family name, supporting pronunciation guidance in languages that require it. | |
| GivenNameReading | String | Phonetic reading of the user's first name, helping ensure accurate pronunciation in supported locales. | |
| LocalName | String | Localized version of the user's display name for regions or languages that require translation or adaptation. | |
| LocalNameLocale | String | Locale code indicating the language or region associated with the user's localized display name. | |
| Timezone | String | Identifier of the time zone configured for the user, ensuring correct scheduling and timestamp alignment. | |
| Locale | String | Language preference set for the user, influencing UI display and formatting behavior. | |
| Description | Longvarchar | The user's profile description or About Me text, often used to share background information or role context. | |
| Phone | String | Primary phone number associated with the user for contact or directory purposes. | |
| MobilePhone | String | Mobile phone number of the user, used for direct communication or multi-factor verification. | |
| ExtensionNumber | String | Internal extension assigned to the user for office or system-based telecommunications. | |
| String | Email address of the user, serving as a primary communication channel and identifier. | ||
| SkypeID | String | Skype identifier associated with the user for messaging or online collaboration. | |
| Url | String | Profile URL field where the user can include a personal or work-related link. | |
| EmployeeNumber | String | Employee number assigned to the user for internal tracking, payroll, or Human Resources (HR) systems. | |
| BirthDate | Datetime | Birth date of the user, used for administrative records or compliance requirements. | |
| JoinDate | Datetime | Hire date of the user, supporting tenure tracking, HR records, and onboarding workflows. | |
| PrimaryOrganization | Integer | Identifier of the user's primary department. If the value is 'null', there is no designated primary assignment. | |
| SortOrder | Integer | Display order value used to control how the user appears in sorted lists or organizational views. | |
| CustomItemValues | String | List of custom field name and code pairs, representing extended profile attributes defined by the organization. |