Apps
Returns all apps in the Kintone environment with key metadata required for cataloging, governance, or integration with external systems.
Select
デフォルトでは、connector はKintone API を使用して以下のカラムを参照する検索条件を処理し、クライアント側でconnector 内で他のフィルタを処理します。Kintone API は、AppId、Code、およびSpaceId カラムの検索をサポートしています。これらのカラムは= およびIN 演算子のサーバー側処理をサポートしますが、Name カラムがサポートするのはLIKE 演算子のみです。例えば、次のクエリはサーバー側で処理されます。
SELECT * FROM Apps WHERE AppId IN (20, 21, 51, 56) AND Name LIKE '%To Do%'
Columns
| Name | Type | References | Description |
| AppId [KEY] | Integer | Identifier of the Kintone app whose details are being retrieved. | |
| Code | String | App code assigned to the app, returned as a blank value when no app code is configured in the app settings. | |
| Name | String | Display name of the app, returned in the user's configured language when localization settings are enabled. | |
| Description | Longvarchar | Text description of the app, returned in the user's configured language when localization settings are enabled. | |
| SpaceId | String | Identifier of the space that contains the app, with the value of 'null' returned when the app is not created inside a space. | |
| ThreadId | String | Identifier of the thread that contains the app when the app is created inside a space, with the value of 'null' returned when the app does not belong to a space or thread. | |
| CreatedAt | Datetime | Date and time when the app was created. | |
| CreatorCode | String | Login name of the user who created the app, with no value returned for inactive or deleted users. | |
| CreatorName | String | Display name of the user who created the app, with no value returned for inactive or deleted users. | |
| ModifiedAt | Datetime | Date and time when the app was last modified. | |
| ModifierCode | String | Login name of the user who last updated the app, with no value returned for inactive or deleted users. | |
| ModifierName | String | Display name of the user who last updated the app, with no value returned for inactive or deleted users. | |
| Alias | String | Alias name defined for the app, which can be made unique by using the connection property TableNameMode=AppId. | |
| ItemUrl | String | Unique URL used to access or reference the app within the Kintone environment. |