Apps
Query the available apps in kintone.
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 | The App ID of the kintone application. | |
| Code | String | The App Code of the app. This will be blank if an App Code is not set in the settings of the App. | |
| Name | String | The name of the App. If Localization settings are used, this column will return the localized name dependant on the language settings of the kintone user using this API. | |
| Description | String | The description of the App. If Localization settings are used, this column will return the localized app description dependent on the language settings of the kintone user using this API. | |
| SpaceId | String | If the app was created inside a space, this column will return the space Id. If not, this column returns null. | |
| ThreadId | String | If the app was created inside a space, this column will return the thread Id of the thread of the space it belongs to. For users who have not altered their User Interface Settings to the classic design, apps will automatically belong to the first thread of the space when the app is made in the space. Users who use the classic design will find that they can create apps that are thread-specific instead of space-specific. If the app was not created in a space, null is returned. | |
| CreatedAt | Datetime | The date of when the app was created. | |
| CreatorCode | String | The log-in name of the creator. Nothing is returned for inactive users and deleted users. | |
| CreatorName | String | The display name of the creator. Nothing is returned for inactive users and deleted users. | |
| ModifiedAt | Datetime | The date of when the app was last modified. | |
| ModifierCode | String | The log-in name of the last updater. Nothing is returned for inactive users and deleted users. | |
| ModifierName | String | The display name of the last updater. Nothing is returned for inactive users and deleted users. | |
| Alias | String | The alias name of the App. |