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

Syntax

Connect-HubSpot -LineItemPropertiesFile string

Data Type

cstr

Default Value

""

Remarks

Use this property to limit the fields selected from the LineItems table, especially when the number of custom properties may exceed HubSpot's API limits. Selecting all fields at once may result in an error.

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 LineItemProperties table.

This property is useful in scenarios where you do not have direct control over the SQL query, such as when using analytics platforms or data sync tools.

Performance Considerations

Limiting the selected fields can reduce API response size, avoid field count errors, and improve performance when querying line items with many custom properties.