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

Data Type

string

Default Value

""

Remarks

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

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. These can be retrieved from the Name column of the TicketProperties metadata table.

This property is especially useful in scenarios where the SQL projection cannot be controlled directly, such as within reporting tools or middleware pipelines.

Performance Considerations

Limiting the number of fields retrieved can reduce query time, lower memory usage, and help prevent errors when working with tickets that include many custom properties.