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