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

Data Type

string

Default Value

""

Remarks

Use this property to limit the fields selected from the Quotes table, especially when the number of custom fields may cause HubSpot to return an error. Attempting to select all fields at once can exceed field count or payload limits imposed by the API.

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

This property is useful when you cannot modify the SQL query directly, such as in business intelligence tools, integrations, or automation platforms.

Performance Considerations

Reducing the number of fields returned helps avoid API errors, improve response times, and reduce memory usage when working with quotes that include many custom fields.