SSIS Components for Highrise

Build 20.0.7587

Emails

Query Emails that are visible to the authenticated user and related to a specific Person, Company, Case, or Deal.

テーブル固有の情報

Select

Email の取得には、People、Company、Case、もしくはDeal などのEmail が所属するSebjectType およびSubject Id を入力します。

SELECT * FROM Emails WHERE SubjectType='People' AND SubjectId='1234567' 
SELECT * FROM Emails WHERE SubjectType='Company' AND SubjectId='1234567' 

特定のEmail に関連する情報の取得には Email のId を指定します。

SELECT * FROM Emails WHERE Id='1234567'

すべての会社からすべてのE メールを取得するには、IN 演算子でサブクエリを使用できます。

SELECT * FROM Emails WHERE SubjectType='Company' AND SubjectId IN (Select Id FROM Companies)

Datetime カラムでは、'>'、および'>=' の演算子だけがサポートされています。

SELECT * FROM Emails WHERE SubjectType='People' AND SubjectId='1234567' AND UpdatedAt > "2016-01-01"

Columns

Name Type References Description
Id [KEY] Integer The unique identifier of the email.
Title String The title of the email.
Body String The body of the email.
AuthorId Integer The Id of the author of the email.
SubjectId Integer The Id of the subject of the email.
SubjectType String The subject type of the email. The allowed values are People, Company, Case, Deal.
SubjectName String The subject name of the email.
CollectionId Integer The Id of the collection.
CollectionType String The type of the collection.
VisibleTo String Who the email is visible to: Everyone, Owner, or NamedGroup.
OwnerId Integer The Id of the owner associated with the email.
GroupId Integer The Id of the group associated with the email.
CreatedAt Datetime The date and time when the email was created.
UpdatedAt Datetime The date and time when the email was last updated.

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