CustomObjects
Lists all available custom objects in HubSpot, useful for managing non-standard CRM data.
View Specific Information
In HubSpot, CustomObjects are custom CRM Objects that you create to represent and organize your CRM data based on your business needs.
SELECT
SELECT * FROM CustomObjects; SELECT * FROM CustomObjects WHERE Id = '24711980';
Columns
| Name | Type | References | Filterable | Description |
| Id | String | False | Unique identifier assigned to the custom object instance, typically including portal ID and object name. | |
| FullyQualifiedName [KEY] | String | False | Fully qualified name of the object type, combining meta type and unique ID (formatted as _meta_type__uniqueID_). | |
| Name | String | False | Unique name assigned to the custom object's schema, used to reference the object type. | |
| LabelSingular | String | False | Singular display label for the custom object, used throughout the CRM interface. | |
| LabelPlural | String | False | Plural display label for the custom object, used throughout the CRM interface. | |
| CreatedAt | Datetime | False | Timestamp marking when the custom object type was initially created. | |
| UpdatedAt | Datetime | False | Timestamp marking the most recent update to the custom object type. | |
| PropertiesAggregate | String | False | Aggregate list of properties defined for this object type. Detailed property information is available in the CustomObjectProperties table. | |
| AssociationsAggregate | String | False | Aggregate list of associations defined for this object type. Detailed association information is available in the CustomObjectAssociations table. | |
| RequiredProperties | String | False | List of property names that must be populated when creating a new object of this type. | |
| SearchableProperties | String | False | List of properties that will be indexed and searchable within HubSpot's product search for this object type. | |
| PrimaryDisplayProperty | String | False | Name of the primary property displayed prominently on the HubSpot record page for this object type. | |
| SecondaryDisplayProperties | String | False | List of secondary properties displayed on the HubSpot record page for this object type. | |
| ObjectTypeId | String | False | Unique identifier assigned to the custom object type. | |
| MetaType | String | False | Meta description providing details about the custom object type. |