Users

Gets information of users.

Select

connector はKintone API を使用してサポート対象のフィルタを処理します。デフォルトでは、connector はクライアント側でconnector 内で他のフィルタを処理します。

例えば、次のクエリはサーバー側で処理されます。

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.
Email	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.

Tableau Connector for Kintone

Users

Select

Columns