ODBC Driver for HubSpot

Build 23.0.8839


A file or value with a comma separated list of properties to select from HubSpot for the LineItems table.

Data Type


Default Value



In HubSpot, you can potentially have so many custom fields that attempting to select all of them at a time will cause HubSpot to return an error. In a situation where you do not have direct control over the SQL Statement but still need to get custom field data back, you set the LineItemPropertiesFile to the full location of a file that lists which custom fields to select. For instance, C:\users\public\documents\customfields.txt or dealname,amount,description.

The CustomFields document itself is just a comma separated list of the names of which custom fields to select. Note that these must be the API names of the custom fields. These names can be retrieved from the Name column of the LineItemProperties table. For instance: dealname,amount,description.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839