Threads

Lists all available conversation threads in HubSpot, useful for managing customer interactions.

SELECT

When selecting Threads, they can be filtered by columns marked below as 'Filterable'. For those columns, the supported server-side operators is: =.

SELECT * FROM Threads;
SELECT * FROM Threads WHERE Id = 8413472578;

UPDATE Threads SET Status = 'OPEN' WHERE Id = 8413472578;

DELETE FROM Threads WHERE Id = 8413472575


Name	Type	ReadOnly	References	Filterable	Description
Id [KEY]	String	True		True	Unique identifier for the conversation thread.
CreatedAt	Datetime	True			Timestamp indicating when the thread was initiated.
ClosedAt	Datetime	True			Timestamp indicating when the thread was closed, if applicable.
Status	String	False		True	Current status of the thread, typically either open or closed.
LatestMessageTimestamp	Datetime	True			Timestamp of the most recent message sent or received within the thread.
LatestMessageSentTimestamp	Datetime	True			Timestamp of the most recent message sent from within the thread.
LatestMessageReceivedTimestamp	Datetime	True			Timestamp of the most recent message received in the thread.
AssignedTo	String	True			Identifier of the user or participant currently assigned to manage the thread.
Spam	Bool	True			Indicates whether the thread has been flagged as spam.
InboxId	String	True			Identifier for the inbox that contains the thread within the conversations tool.
AssociatedContactId	String	True		True	Identifier of the contact in the CRM that is associated with the thread.
Archived	Bool	False			Indicates whether the thread has been archived.