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

Data Type

string

Default Value

""

Remarks

Use this property to limit the fields selected from the Tasks table, especially when the number of custom fields may cause HubSpot to return an error. Retrieving all fields at once can exceed API limits for field count or response size.

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 TaskProperties metadata table.

This property is especially useful when working in environments where you cannot directly control the SQL query, such as in dashboards, integrations, or reporting tools.

Performance Considerations

Limiting the number of selected fields helps prevent API errors, reduces payload size, and improves overall query performance when working with tasks that include many custom fields.