TicketAssociations
Returns object IDs associated with specific tickets, supporting customer support case associations.
Table-Specific Information
SELECT
The TicketAssociations table always includes the same set of columns, but some return NULL unless you filter by Id and Type, which allows the component to retrieve full association details.
To return full details for Ticket associations, filter by both the Ticket Id and the association Type.
The Type identifies the associated object (such as a Deal, Company, or Contact).
-- Retrieve all fields for associations between a specific Ticket and its related Deals
SELECT *
FROM TicketAssociations
WHERE Id = '436648510605' -- Ticket Id
AND Type = 'Deal'; -- Associated object type
Note: Fetching all fields can cause a reduction in performance, as it requires the component to make requests for each Ticket.
DELETE
To remove a Ticket association, include both the Ticket Id and the association Type:
-- Delete a Ticket-Deal association
DELETE FROM TicketAssociations
WHERE Id = '436648510605' -- Ticket Id
AND Type = 'Deal'; -- Associated object type
Columns
| Name | Type | ReadOnly | References | Filterable | Description |
| Id [KEY] | Long | False |
Tickets.Id | False |
Unique identifier for the ticket record. |
| AssociationId [KEY] | Long | False | False |
Identifier of the object that this ticket is associated with. | |
| Type [KEY] | String | False | False |
Type of the associated object, such as a contact, deal, or company. | |
| TypeId [KEY] | String | False |
AssociationsLabels.TypeId | False |
Numeric identifier for the association type. May be blank for general association queries. |
| Category [KEY] | String | False |
AssociationsLabels.Category | False |
Category that classifies the type of relationship between the ticket and the associated object. Often empty for generic associations. |
| TypeLabel | String | True |
AssociationsLabels.Label | False |
Descriptive label that defines the association type between the ticket and the related object. |