CData Python Connector for kintone

Build 21.0.7930

Comments

Query the available comments in kintone.

Select

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

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.

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