Returns object IDs associated with specific leads, enabling management of lead associations.

Table-Specific Information

SELECT

The LeadAssociations 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 Lead associations, filter by both the Lead Id and the association Type. The Type identifies the associated object (such as a Deal, Company, Contact, or Ticket).

-- Retrieve all fields for associations between a specific Lead and its related Deals
SELECT *
FROM LeadAssociations
WHERE Id = '436648510605'   -- Lead 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 Lead.

DELETE

To remove a Lead association, include both the Lead Id and the association Type:

-- Delete a Lead-Deal association
DELETE FROM LeadAssociations
WHERE Id = '436648510605'   -- Lead Id
  AND Type = 'Deal';        -- Associated object type

Columns