JDBC Driver for Highrise

Build 22.0.8462

Emails

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

Table Specific Information

Select

To retrieve Emails, provide a SubjectType that the Email belongs to, such as People, Company, Case, or Deal, and the Subject Id.

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

To retrieve information related to a specific email, provide the Id of the email.

SELECT * FROM Emails WHERE Id = '1234567'

To retrieve all the emails from all the companies, you can use a subquery with IN operator.

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

For datetime columns only the '>' and '>=' operators are supported.

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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462