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

Data Type

string

Default Value

""

Remarks

Use this property to limit the fields selected from the Products table, especially when the number of custom fields may cause HubSpot to return an error. Selecting all fields at once can result in an API failure due to field count or payload size limits.

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 from the Name column of the ProductProperties metadata table.

This property is useful in scenarios where you cannot modify the SQL query directly, such as when working with business intelligence tools or integration middleware.

Performance Considerations

Limiting the selected fields helps reduce API payload size, improves query performance, and avoids errors caused by requesting too many fields at once.