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. |