Excel Add-In for kintone

Build 21.0.7930

Data Model

The add-in models the kintone API as relational Tables, Views, and Stored Procedures.

Tables

Using the add-in, you can work with all the tables in your account. The table schemas can be static or dynamic. The Comments table has a static schema with fixed columns, while other tables are dynamic, reflecting changes in the metadata -- when you connect, the add-in retrieves table metadata from kintone to generate the table schemas.

Static schemas are defined in schema files, which makes them easy to extend. Edit the schema file to customize the column behavior of the static Comments table, to change the data type for example. The schema files are located in the db subfolder of the add-in installation folder.

Sub-Tables

In some kintone apps, the user can add custom fields containing many records. The add-in models these fields as dynamic subtables reflecting your changes.

Stored Procedures

Stored Procedures are function-like interfaces to kintone. They can be used to search, update, and modify information in kintone. For example, use stored procedures to execute operations on apps or work with files.

Views

The add-in models apps in the static Apps view.

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