CData Python Connector for kintone

Build 21.0.7930


Query the available comments in kintone.


The RecordId and AppId columns are required in the WHERE clause. The provider will use the kintone APIs to filter the results by these columns. The kintone APIs also support filters on Id. By default, the provider will process other filters client-side within the provider. If SupportEnhancedSQL is set to false, an error will be returned for filters on other columns.

For example, the following queries are processed server side:

SELECT * FROM Comments WHERE RecordId=1 AND AppId=5 AND Id=1


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"}]')


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


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.

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