A file or a CSV string for the columns to select from HubSpot for the Orders table.

Data Type

string

Default Value

""

Remarks

In HubSpot, selecting all custom fields at once can lead to an error due to the large number of fields. If you cannot directly control the SQL statement, but still need to retrieve custom field data or override the query projection, you can use the OrderPropertiesFile property. You can either specify the full path to a file containing a CSV string that lists the custom fields to select or directly pass the CSV string in the property. For example, OrderPropertiesFile='C:\users\public\documents\customfields.txt' or OrderPropertiesFile='hs_object_id,hs_order_name,hs_order_note'.