Users
Returns detailed user profile information from the Cybozu directory to support identity synchronization and permission audits.
Select
The connector uses the Kintone API to process supported filters. By default, the connector will process other filters client-side within the connector.
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 | 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. |