Returns object IDs associated with specific feedback submissions, useful for feedback association tracking.

Table-Specific Information

SELECT

The FeedbackSubmissionAssociations 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 Feedback Submission associations, filter by both the Feedback Submission 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 Feedback Submission and its related Deals
SELECT *
FROM FeedbackSubmissionAssociations
WHERE Id = '436648510605'   -- FeedbackSubmission 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 FeedbackSubmission.

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

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

DELETE

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

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

Columns

Name	Type	ReadOnly	References	Filterable	Description
Id [KEY]	Long	False	FeedbackSubmissions.Id	False	Unique identifier of the feedback submission engagement.
AssociationId [KEY]	Long	False		False	ID of the associated object, such as a contact, company, or deal.
Type [KEY]	String	False		False	Type of the associated object, such as contact or deal.
TypeId [KEY]	String	False	AssociationsLabels.TypeId	False	The numeric ID representing the type of association. May be blank for general association queries.
Category [KEY]	String	False	AssociationsLabels.Category	False	The classification of the association type for the given object pair. May be blank for generic queries.
TypeLabel	String	True	AssociationsLabels.Label	False	The descriptive label assigned to the type of association between the feedback submission and the related object.