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

Data Type

string

Default Value

""

Remarks

Use this property to limit the fields selected from the Emails 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 EmailProperties table.

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

Performance Considerations

Selecting only the fields you need reduces API response size and improves performance, especially when querying emails that include many custom properties. This also helps prevent errors related to HubSpot's response size or field count limits.