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

Data Type

string

Default Value

""

Remarks

Use this property to limit the fields selected from the Notes table, especially when the number of custom properties may exceed HubSpot's API limits. Selecting all fields at once may result in an error.

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 the same list (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 NoteProperties table.

This property is useful when you do not have direct control over the SQL projection, such as when working within business intelligence tools or automated workflows.

Performance Considerations

Restricting the fields included in queries improves performance, reduces API response size, and helps avoid errors caused by excessive field counts or large payloads.