Returns object IDs associated with specific product records, supporting product associations.

Table Specific Information

SELECT

Note: You cannot reference custom objects by base name. When querying ProductAssociations, if Type refers to a custom object, the value must now be either the short-hand object type name (p_<object_name>) or the fully qualified object type name.

Filtering by multiple Product Id values with IN, combined with the association Type, retrieves associations for up to 1,000 Products in a single batched request instead of one request per Product. The driver splits IN lists larger than 1,000 values into additional batched requests automatically.

-- Retrieve associations for multiple Products in a single batched request
SELECT *
FROM ProductAssociations
WHERE Id IN ('436648510605', '436648510606', '436648510607')
  AND Type = 'Deal';

Columns

Name	Type	ReadOnly	References	Filterable	Description
Id [KEY]	Long	False	Products.Id	False	Unique identifier for the product association record.
AssociationId [KEY]	Long	False		False	Unique identifier of the object associated with this product, such as a deal or quote.
Type [KEY]	String	False		False	Type of the associated object, such as contact, deal, or quote.
TypeId [KEY]	String	False	AssociationsLabels.TypeId	False	The numeric identifier of the association type between the product and the related object. This column is empty for general association queries.
Category [KEY]	String	False	AssociationsLabels.Category	False	The classification of the association type for this object pair. This column is empty for generic association queries.
TypeLabel	String	True	AssociationsLabels.Label	False	The descriptive label assigned to the type of association between the product and the related object.