SSIS Components for Highrise

Build 20.0.7587


Create, update, delete, and query Comments associated with a Note or Email and visible to the authenticated user.



Comments の取得には、Notes およびEmails などのNote が所属するSebjectType およびSubject Id を入力します。

SELECT * FROM Comments WHERE SubjectType='notes' AND SubjectId='351922361'


Comment の挿入には、次のクエリを入力します。Common Body およびParentId は必須です。

INSERT INTO Comments (Body, ParentId) VALUES('me comment', '351199012') 


Name Type ReadOnly References Description
Id [KEY] Integer True

The unique identifier of the comment.

Body String False

The body of the comment.

ParentId Integer False

The Id of the parent of the comment.

SubjectId Integer True

The Id of the subject of the comment.

SubjectType String True

The subject type of the comment.

SubjectName String True

The subject name of the comment.

CollectionId Integer True

The Id of the collection.

CollectionType String True

The type of the collection.

VisibleTo String True

Who the comment is visible to: Everyone, Owner, or NamedGroup.

GroupId Integer True

The Id of the group.

OwnerId Integer True

The Id of the owner.

AuthorId Integer True

The Id of the author of the comment.

CreatedAt Datetime True

The date and time when the comment was created.

UpdatedAt Datetime True

The date and time when the comment was last updated.


SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
ParentType String

Whether the comment is associated with a note or email.

使用できる値は次のとおりです。note, email


Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587