CustomObjectProperties
Retrieves property fields for custom objects, supporting the management of custom data structures.
View Specific Information
SELECT
SELECT * FROM CustomObjectProperties; SELECT * FROM CustomObjectProperties WHERE ObjectId = '24711980';
Columns
| Name | Type | References | Filterable | Description |
| ObjectId | String | False | Unique identifier assigned to the custom object instance, typically including portal ID and object name. | |
| ObjectFullyQualifiedName [KEY] | String | False | Fully qualified name of the object type, combining meta type and unique ID (formatted as _meta_type__uniqueID_). | |
| ObjectName | String | False | Unique name assigned to the schema's custom object type. | |
| ObjectLabelSingular | String | False | Singular label for the custom object type, displayed in the CRM interface. | |
| ObjectLabelPlural | String | False | Plural label for the custom object type, displayed in the CRM interface. | |
| Name [KEY] | String | False | Internal name of the property, used when referencing the property via HubSpot API. | |
| Label | String | False | Human-readable label for the property, displayed in the HubSpot UI. | |
| UpdatedAt | Datetime | False | Timestamp indicating when the custom object property was last updated. | |
| CreatedAt | Datetime | False | Timestamp indicating when the custom object property was initially created. | |
| ArchivedAt | Datetime | False | Timestamp indicating when the custom object property was archived. | |
| Type | String | False | Data type of the property, such as string, number, or date. | |
| FieldType | String | False | Defines how the property appears in the HubSpot UI (such as text field, dropdown, or checkbox). | |
| Description | String | False | Explanation of the property's purpose, shown as help text within HubSpot. | |
| GroupName | String | False | Name of the property group this property belongs to, used for organizational purposes. | |
| Options | String | False | List of valid options for the property, applicable for enumerated (dropdown/select) properties. Empty for other types. | |
| CreatedUserId | String | False | Internal ID of the user who created the property. May be null if created by system processes or external tools. | |
| UpdatedUserId | String | False | Internal ID of the user who last updated the property. May be null if updated externally. | |
| ReferencedObjectType | String | False | If the property references another object type, it is listed here. | |
| DisplayOrder | Int | False | Defines the order in which this property appears relative to others in the HubSpot UI. Lower values appear first. | |
| Calculated | Bool | False | Indicates whether the property is calculated by HubSpot processes. Applicable to default properties. | |
| ExternalOptions | Bool | False | Indicates whether the property options are sourced externally instead of being stored within property settings. | |
| Archived | Bool | False | Indicates whether this property has been archived and is no longer in active use. | |
| HasUniqueValue | Bool | False | Specifies whether the property value must be unique across all records. Once set, it cannot be changed. | |
| Hidden | Bool | False | Indicates whether the property is hidden from standard views in HubSpot. | |
| HubspotDefined | Bool | False | True if the property is a default HubSpot-defined property, false if it is custom. | |
| ShowCurrencySymbol | Bool | False | Indicates whether the currency symbol (as per account settings) should be displayed with the property value. | |
| ModificationMetadata | String | False | Metadata containing details about modifications made to the property. | |
| FormField | Bool | False | Specifies whether the property can be used in HubSpot forms. |