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 driver 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 driver 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