Apps
Returns all apps in the Kintone environment with key metadata required for cataloging, governance, or integration with external systems.
Select
By default, the connector will use the Kintone APIs to process search criteria that refer to the following columns and will process other filters client-side within the connector: the Kintone API supports searches on the AppId, Code, and SpaceId columns. These columns support server-side processing for the = and IN operators while the Name column supports only the LIKE operator. For example, the following query is processed server side:
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. |