ContactProperties
Contact properties are the standard and custom pieces of field data that appear in HubSpot.
Table Specific Information
Contact properties are a number of custom properties that are available to store data about the contacts in your HubSpot Hub. Some of these properties are added by HubSpot and cannot be deleted. They will be automatically added to the Contacts on a new connection.
SELECT
Contact properties can only be filtered by the unique contact property name or group name. For example:
SELECT * FROM ContactProperties WHERE Name = 'property_name' SELECT * FROM ContactProperties WHERE GroupName = 'group_name'
Columns
| Name | Type | ReadOnly | References | Description |
| Name [KEY] | String | False |
The name of the contact property. The name must contain only lowercase alphabetical characters and numbers and must start with a lowercase alphabetical character. | |
| Label | String | False |
The human readable label for the contact property that will display in the HubSpot UI. | |
| FieldType | String | False |
The type of field that will display on the screen for the company property. 使用できる値は次のとおりです。textarea, select, text, date, file, number, radio, checkbox | |
| Type | String | False |
The stored machine type for the company property. 使用できる値は次のとおりです。string, number, bool, datetime, enumeration | |
| GroupName | String | False |
The group the company property is a part of. | |
| Description | String | False |
A description of what the property is for. | |
| DisplayMode | String | False |
How the property will be displayed. | |
| DisplayOrder | Integer | False |
The order in which the property should be displayed in relation to other properties in the same group. | |
| ExternalOptions | Boolean | False |
Boolean indicating if there are external options associate with the company property. | |
| IsFormField | Boolean | False |
Boolean indicating if the property is a field that is part of a form. | |
| IsCalculated | Boolean | False |
Boolean indicating if the property is calculated. | |
| IsHidden | Boolean | False |
Boolean indicating if the property is hidden. | |
| IsFavorited | Boolean | False |
Boolean indicating if the property is favorited. | |
| FavoritedOrder | Integer | False |
The favorited order for this property. | |
| MutableDefinitionNotDeletable | Boolean | False |
Boolean indicating if the property can be modified but not deleted. | |
| ReadOnlyDefinition | Boolean | False |
Boolean indicating if the definition for the property is read only. | |
| ReadOnlyValue | Boolean | False |
Boolean indicating if the value of the property is read only. | |
| OptionsAggregate | String | False |
An aggregate of additional options for the property. Will have a value if the FieldType is radio, checkbox, or booleancheckbox. | |
| ExtraUrlParameters | String | True |
An input only property for specifying additional parameters when selecting data from HubSpot. Specify the parameters as name=value pairs in a comma separated list. For instance, 'param1=value1,param2=value2,param3=value3'. |