Specifies how to handle detected number columns.

Syntax

Connect-HubSpot -NumberColumnMode string

Possible Values

Data Type

cstr

Default Value

"DECIMAL"

Remarks

HubSpot reports all numeric data type fields (ex. integer, double, decimal, etc.) as 'number' type. For this reason, there isn't a reliable way for the cmdlet to determinate the exact numeric type for each detected numeric field.

By default, all numbers will be specified as decimal. However, depending on your needs, you may wish to handle number columns as either double or decimal. In addition, you can also set the value to string to report all number columns as strings.

Note: This connection property is applicable only for 'HUBSPOTV3' Schema.