ODBC Driver for HubSpot

Build 25.0.9434

ProductProperties

Retrieves all available product property fields, including standard and custom fields.

Columns

Name Type ReadOnly References Filterable Description
Name [KEY] String False True

Internal name of the product property. Must start with a lowercase letter and contain only lowercase letters and numbers.

Label String False False

User-facing label that appears for the product property in the HubSpot interface.

FieldType String False False

Type of input field displayed for the property, such as text, dropdown, or date picker.

Type String False False

Underlying machine data type used to store the property value, such as string, number, or boolean.

GroupName String False False

Name of the group that organizes this property within the product object.

Description String False False

Explanation of the purpose and usage of the property.

DisplayOrder Int False False

Numeric value that determines the display order of the property within its group.

ExternalOptions Bool False False

Indicates whether the property options are sourced externally rather than defined within HubSpot.

IsFormField Bool False False

Indicates whether the property can be used in forms for data collection.

IsCalculated Bool False False

Indicates whether the property's value is automatically calculated based on other properties.

IsHidden Bool False False

Indicates whether the property is hidden from standard user views in the interface.

IsHubspotDefined Bool False False

Indicates whether the property was created by HubSpot as part of the default object schema.

Archivable Bool False False

Indicates whether the property can be archived when no longer needed.

ReadOnlyDefinition Bool False False

Indicates whether the configuration of the property (such as name or type) is locked from editing.

ReadOnlyValue Bool False False

Indicates whether the value of the property is read-only and cannot be modified.

OptionsAggregate String False False

List of selectable options available for the property if the field type supports multiple choices, such as radio buttons or checkboxes.

HasUniqueValue Bool False False

Boolean indicating whether the value of the property is unique.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434