Chat Messages

Includes all chat messages tracked in Affinity with sender, direction, and metadata. Name: v1_0.chat_messages 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`	Unique identifier for the chat message
`logging_type`	Indicates how the interaction was added to Affinity: either manually by a user or automatically through Affinity’s capture process. Currently, chat messages can only be logged as ‘manual’.
`direction`	The direction of the chat message
`sent_at`	Timestamp indicating when the chat message was sent
`creator_id`	The ID of the creator of the chat message
`created_at`	Timestamp indicating when the chat message was created in Affinity
`is_deleted`	Whether the chat message record has been deleted
`last_updated_at`	Timestamp when this record was last updated

Getting Started

Example Queries

V1_0

Changelog

Columns

​Columns

Columns