Returns object IDs associated with specific order records, enabling order association tracking.

Table-Specific Information

SELECT

The OrderAssociations table always includes the same set of columns, but some return NULL unless you filter by Id and Type, which allows the connector to retrieve full association details.

To return full details for Order associations, filter by both the Order 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 Order and its related Deals
SELECT *
FROM OrderAssociations
WHERE Id = '436648510605'   -- Order Id
  AND Type = 'Deal';        -- Associated object type

Note: Fetching all fields can cause a reduction in performance, as it requires the connector to make requests for each Order.

DELETE

To remove an Order association, include both the Order Id and the association Type:

-- Delete an Order-Deal association
DELETE FROM OrderAssociations
WHERE Id = '436648510605'   -- Order Id
  AND Type = 'Deal';        -- Associated object type

Columns