Excel Add-In for kintone

Build 21.0.7930

Apps

Query the available apps in kintone.

Select

By default, the add-in will use the kintone APIs to process search criteria that refer to the following columns and will process other filters client-side within the add-in: 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%'

If SupportEnhancedSQL is set to false, an error will be returned for filters on other columns.

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.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930