The server models the Kintone REST API as relational Tables, Views and Stored Procedures.

Tables

Using the server, 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 server 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 server installation folder.

Sub-Tables

In some Kintone apps, the user can add custom fields containing many records. The server 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 server models apps in the static Apps view.