Data Type Mappings

The driver maps types from the data source to the corresponding data type available in the schema. The table below documents these mappings, which apply to every schema the driver exposes.

HubSpot Field Type	CData Schema
Date picker	date
Dropdown select	string
HubSpot user	string
Multi-line text	string
Multiple checkboxes	string
Number	double or decimal, as described below
Radio select	string
Single checkbox	string
Single-line text	string

Number Fields

HubSpot reports all numeric fields using a single generic number type, so the driver cannot infer the exact numeric type of a field. The schema in use determines how the driver resolves this:

• In the HubSpot schema, number fields are always reported as double.
• In all other schemas, number fields are reported using the type set by NumberColumnMode, which defaults to decimal. Calculated rollup fields defined by HubSpot are an exception: these are always reported as string.