Retrieves all feedback submission records in HubSpot, useful for tracking customer feedback.

Table Specific Information

When contacts submit feedback to your surveys, you can use submission data in HubSpot tools to help understand how customers feel about your business.

SELECT

When selecting contacts, they can be filtered by columns marked below as 'Filterable'. For those columns, the supported server-side operators are: =, !=, <, <=, >, >=, IN

Further filtering is available using AND and OR combinations. A maximum of 3 OR operators are supported server-side, with each of these operators supporting up to 3 AND operators inside of them. For example:

SELECT * FROM FeedbackSubmissions WHERE [Survey Name] = 'Customer Support Survey 1' AND [Date] > '2021-08-01'
SELECT * FROM FeedbackSubmissions WHERE [Email] = '[email protected]' OR [Feedback sentiment] = 'PROMOTER'

In the below server-offloading examples, "{Column}" represents any column you'd like to filter and "{Value}" represents any value you want to filter it on:

SELECT * FROM FeedbackSubmissions WHERE {Column} = {Value} AND {Column} < {Value} AND {Column} > {Value}
SELECT * FROM FeedbackSubmissions WHERE {Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value} AND {Column} = {Value}
SELECT * FROM FeedbackSubmissions WHERE ({Column} = {Value} AND {Column} = {Value}) OR ({Column} != {Value} AND {Column} >= {Value})
SELECT * FROM FeedbackSubmissions WHERE ({Column} >= {Value} AND {Column} <= {Value} AND {Column} = {Value}) OR ({Column} >= {Value} AND {Column} <= {Value} AND {Column} = {Value}) OR ({Column} >= {Value} AND {Column} <= {Value} AND {Column} = {Value})

Columns