Emails

Includes all emails tracked in Affinity with sender, recipients, subject, and direction information. Name: v1_0.emails Deleted and merged records are covered in Deletes & Merges.

Grant access to the share only to users who are authorized to view all organization data. There are no per-user or per-role visibility filters applied at the share level.

Columns

Column	Description
`id`	The email’s unique identifier
`logging_type`	Indicates how the interaction was added to Affinity: either manually by a user (‘manual’) or automatically through Affinity’s capture process (‘automated’). Currently, emails can only be logged as ‘automated’.
`direction`	The direction of the email: ‘sent’ if the email was sent by an internal user and ‘received’ if the email was sent to an internal user
`sent_at`	The timestamp of when the email was sent
`created_at`	The timestamp of when the email was created in Affinity
`from`	The email address of the participant who sent the email
`to_participants`	Array of email addresses in the To field
`cc_participants`	Array of email addresses in the CC field
`is_deleted`	Whether the email record has been deleted
`last_updated_at`	Timestamp when this record was last updated

Getting Started

Example Queries

V1_0

Changelog

Columns

​Columns

Columns