Specifies a comma-separated list or file path containing the names of fields to retrieve for the FeedbackSubmissions table.

Data Type

string

Default Value

""

Remarks

Use this property to limit the fields selected from the FeedbackSubmissions table, especially when the number of custom properties may exceed HubSpot's API limits. Attempting to select all fields at once may result in errors.

You can set this property to either:

• A comma-separated list of field names (for example: "dealname,amount,description").
• The full file path to a text file containing a comma-separated list of API field names (for example: C:\Users\Public\Documents\customfields.txt).

The field names must match the internal (API) names used by HubSpot. You can retrieve these names from the Name column of the FeedbackSubmissionProperties table.

This property is helpful in environments where you cannot directly edit the SQL query, such as with middleware or business intelligence tools.

Performance Considerations

Limiting the selected fields can help avoid API errors and improve performance by reducing the size of API responses and minimizing unnecessary data retrieval.