Accessing Custom Fields

If you have defined a large number of custom fields, SELECT * queries can fail with an error as HubSpot limits how many fields can be requested. To avoid the error, you can specify the custom fields you want to return in the text files specified by ContactPropertiesFile and DealPropertiesFile. Alternatively, specify the primary key in the WHERE clause.

If the detected column sizes for custom fields are not sufficient, you can specify the sizes in ColumnSizes.

Fine Tuning Data Access

You can use the following properties to gain more control over column names:

• UseDisplayNames
• UseSimpleNames