Comments
Query the available comments in kintone.
Select
The RecordId and AppId columns are required in the WHERE clause. The connector will use the Kintone APIs to filter the results by these columns. The Kintone APIs also support filters on Id. By default, the connector will process other filters client-side within the connector.
For example, the following queries are processed server side:
SELECT * FROM Comments WHERE RecordId = 1 AND AppId = 5 AND Id = 1
Insert
The AppId and RecordId columns are required in the INSERT statement.
INSERT INTO Comments (AppId, RecordId, Text, MentionsAggregate) VALUES (5, 1, 'To do', '[{"code": "Administrator","type": "USER"}]')
Delete
Comments can be deleted by issuing a DELETE statement and specifying the RecordId, AppId, and Id.
DELETE FROM Comments WHERE RecordId = 1 AND AppId = 5 AND Id = 1
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
The Comment Id. | |
| AppId [KEY] | Integer | False |
The App Id. | |
| RecordId [KEY] | Integer | False |
The Record Id. | |
| Text | String | False |
The comment including the line feed codes. | |
| CreatorCode | String | True |
The user code of the comment creator (log-in name). | |
| CreatorName | String | True |
The user name of the comment creator (display name). | |
| CreatedAt | Datetime | True |
The created date and time of the comment. | |
| MentionsAggregate | String | False |
An array including information of mentioned users. |