# Schema Information

## Tables/APIs 

The following are the tables or APIs associated with the HubSpot v2 connector:

### Owners 

The Owners API allows you to manage and retrieve information about the owners (users) of records in HubSpot, such as contacts, companies, and deals.

For more information, see [HubSpot- Owners](https://legacydocs.hubspot.com/docs/methods/owners/owners_overview).

**FIELDS**

<table><thead><tr><th width="101">Field Name</th><th width="101">Data Type</th></tr></thead><tbody><tr><td>portalId</td><td>NUMERIC</td></tr><tr><td>ownerId</td><td>NUMERIC</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>firstName</td><td>STRING</td></tr><tr><td>lastName</td><td>STRING</td></tr><tr><td>email</td><td>STRING</td></tr><tr><td>createdAt</td><td>NUMERIC</td></tr><tr><td>updatedAt</td><td>NUMERIC</td></tr><tr><td>remoteList</td><td>RECORD</td></tr><tr><td>hasContactsAccess</td><td>BOOLEAN</td></tr><tr><td>activeUserId</td><td>NUMERIC</td></tr><tr><td>isActive</td><td>BOOLEAN</td></tr><tr><td>userIdIncludingInactive</td><td>NUMERIC</td></tr></tbody></table>

### Company Properties&#x20;

This API enables you to access and manage properties (fields) associated with company records in HubSpot, facilitating customization and data management.

For more information, see [HubSpot- Company Properties](https://legacydocs.hubspot.com/docs/methods/companies/company-properties-overview).

**FIELDS**

&#x20;

<table><thead><tr><th width="101">Field Name</th><th width="101">Data Type</th></tr></thead><tbody><tr><td>name</td><td>STRING</td></tr><tr><td>label</td><td>STRING</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>groupName</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>fieldType</td><td>STRING</td></tr><tr><td>hidden</td><td>BOOLEAN</td></tr><tr><td>isCustomizedDefault</td><td>BOOLEAN</td></tr><tr><td>createdAt</td><td>NUMERIC</td></tr><tr><td>updatedAt</td><td>NUMERIC</td></tr><tr><td>favoritedOrder</td><td>NUMERIC</td></tr><tr><td>calculated</td><td>BOOLEAN</td></tr><tr><td>externalOptions</td><td>BOOLEAN</td></tr><tr><td>displayMode</td><td>STRING</td></tr><tr><td>hubspotDefined</td><td>BOOLEAN</td></tr><tr><td>formField</td><td>BOOLEAN</td></tr><tr><td>searchableInGlobalSearch</td><td>BOOLEAN</td></tr><tr><td>hasUniqueValue</td><td>BOOLEAN</td></tr><tr><td>displayOrder</td><td>NUMERIC</td></tr><tr><td>readOnlyValue</td><td>BOOLEAN</td></tr><tr><td>readOnlyDefinition</td><td>BOOLEAN</td></tr><tr><td>mutableDefinitionNotDeletable</td><td>BOOLEAN</td></tr><tr><td>favorited</td><td>BOOLEAN</td></tr></tbody></table>

### Company Properties Groups&#x20;

With this API, you can organize and work with property groups that categorize properties related to company records in HubSpot.

For more information, see HubSpot- [Company Properties Groups](https://legacydocs.hubspot.com/docs/methods/companies/get_company_property_groups).

**FIELDS**

<table><thead><tr><th width="101">Field Name</th><th width="101">Data Type</th></tr></thead><tbody><tr><td>name</td><td>STRING</td></tr><tr><td>fulcrumPortalId</td><td>NUMERIC</td></tr><tr><td>fulcrumTimestamp</td><td>NUMERIC</td></tr><tr><td>displayName</td><td>STRING</td></tr><tr><td>displayOrder</td><td>NUMERIC</td></tr><tr><td>hubspotDefined</td><td>BOOLEAN</td></tr><tr><td>properties</td><td>RECORD</td></tr></tbody></table>

### Contact List&#x20;

The Contact List API provides tools to manage and interact with contact lists in HubSpot, making it easier to segment and work with specific groups of contacts.

For more information, see [HubSpot- Contact List](https://legacydocs.hubspot.com/docs/methods/lists/contact-lists-overview).

**FIELDS**

<table><thead><tr><th width="101">Field Name</th><th width="101">Data Type</th></tr></thead><tbody><tr><td>portalId</td><td>NUMERIC</td></tr><tr><td>listId</td><td>NUMERIC</td></tr><tr><td>createdAt</td><td>NUMERIC</td></tr><tr><td>updatedAt</td><td>NUMERIC</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>listType</td><td>STRING</td></tr><tr><td>authorId</td><td>NUMERIC</td></tr><tr><td>metaData</td><td>RECORD</td></tr><tr><td>archived</td><td>BOOLEAN</td></tr><tr><td>ilsFilterBranch</td><td>STRING</td></tr><tr><td>readOnly</td><td>BOOLEAN</td></tr><tr><td>internal</td><td>BOOLEAN</td></tr><tr><td>limitExempt</td><td>BOOLEAN</td></tr><tr><td>dynamic</td><td>BOOLEAN</td></tr></tbody></table>

### Contact Properties Groups&#x20;

The Contact Properties Groups API allows you to organize and handle property groups that categorize properties associated with contact records in HubSpot.

For more information, see [HubSpot- Contact Properties Groups](https://legacydocs.hubspot.com/docs/methods/contacts/v2/get_contact_property_groups).

**FIELDS**

<table><thead><tr><th width="101">Field Name</th><th width="101">Data Type</th></tr></thead><tbody><tr><td>name</td><td>STRING</td></tr><tr><td>fulcrumPortalId</td><td>NUMERIC</td></tr><tr><td>fulcrumTimestamp</td><td>NUMERIC</td></tr><tr><td>displayName</td><td>STRING</td></tr><tr><td>displayOrder</td><td>NUMERIC</td></tr><tr><td>hubspotDefined</td><td>BOOLEAN</td></tr></tbody></table>

### Deal Properties&#x20;

Using the Deal Properties API, you can access and manage properties (fields) associated with deal records in HubSpot, enhancing customization and data management for sales processes.

For more information, see [HubSpot- Deal Properties](https://legacydocs.hubspot.com/docs/methods/deals/deal_properties_overview).

**FIELDS**

<table><thead><tr><th width="101">Field Name</th><th width="101">Data Type</th></tr></thead><tbody><tr><td>name</td><td>STRING</td></tr><tr><td>label</td><td>STRING</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>groupName</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>fieldType</td><td>STRING</td></tr><tr><td>hidden</td><td>BOOLEAN</td></tr><tr><td>createdAt</td><td>NUMERIC</td></tr><tr><td>formField</td><td>BOOLEAN</td></tr><tr><td>displayOrder</td><td>NUMERIC</td></tr><tr><td>readOnlyValue</td><td>BOOLEAN</td></tr><tr><td>readOnlyDefinition</td><td>BOOLEAN</td></tr><tr><td>mutableDefinitionNotDeletable</td><td>BOOLEAN</td></tr><tr><td>favorited</td><td>BOOLEAN</td></tr><tr><td>favoritedOrder</td><td>NUMERIC</td></tr><tr><td>calculated</td><td>BOOLEAN</td></tr><tr><td>externalOptions</td><td>BOOLEAN</td></tr><tr><td>displayMode</td><td>STRING</td></tr><tr><td>showCurrencySymbol</td><td>BOOLEAN</td></tr><tr><td>deleted</td><td>BOOLEAN</td></tr><tr><td>updatedAt</td><td>NUMERIC</td></tr><tr><td>createdUserId</td><td>NUMERIC</td></tr><tr><td>searchableInGlobalSearch</td><td>BOOLEAN</td></tr><tr><td>hasUniqueValue</td><td>BOOLEAN</td></tr><tr><td>numberDisplayHint</td><td>STRING</td></tr><tr><td>isCustomizedDefault</td><td>BOOLEAN</td></tr><tr><td>updatedUserId</td><td>NUMERIC</td></tr><tr><td>options</td><td>RECORD</td></tr></tbody></table>

### Call Disposition&#x20;

The Call\_Disposition API offers tools to manage call dispositions, which are labels or tags applied to calls, helping track call outcomes and interactions in HubSpot.

For more information, see [HubSpot- Call Disposition](https://legacydocs.hubspot.com/docs/methods/engagements/get-call-dispositions).

**FIELDS**

<table><thead><tr><th width="101">Field Name</th><th width="101">Data Type</th></tr></thead><tbody><tr><td>id</td><td>STRING</td></tr><tr><td>label</td><td>STRING</td></tr><tr><td>deleted</td><td>BOOLEAN</td></tr></tbody></table>

### Contact Properties&#x20;

The Contact Properties API provides access to properties (fields) associated with contact records in HubSpot, allowing customization and data management for contacts.

For more information, see[ HubSpot- Contact Properties](https://legacydocs.hubspot.com/docs/methods/contacts/contact-properties-overview).

**FIELDS**

<table><thead><tr><th width="101">Field Name</th><th width="101">Data Type</th></tr></thead><tbody><tr><td>name</td><td>STRING</td></tr><tr><td>label</td><td>STRING</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>groupName</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>fieldType</td><td>STRING</td></tr><tr><td>hidden</td><td>BOOLEAN</td></tr><tr><td>isCustomizedDefault</td><td>BOOLEAN</td></tr><tr><td>createdAt</td><td>NUMERIC</td></tr><tr><td>formField</td><td>BOOLEAN</td></tr><tr><td>displayOrder</td><td>NUMERIC</td></tr><tr><td>readOnlyValue</td><td>BOOLEAN</td></tr><tr><td>readOnlyDefinition</td><td>BOOLEAN</td></tr><tr><td>mutableDefinitionNotDeletable</td><td>BOOLEAN</td></tr><tr><td>favorited</td><td>BOOLEAN</td></tr><tr><td>favoritedOrder</td><td>NUMERIC</td></tr><tr><td>calculated</td><td>BOOLEAN</td></tr><tr><td>externalOptions</td><td>BOOLEAN</td></tr><tr><td>displayMode</td><td>STRING</td></tr><tr><td>showCurrencySymbol</td><td>BOOLEAN</td></tr><tr><td>deleted</td><td>BOOLEAN</td></tr><tr><td>updatedAt</td><td>NUMERIC</td></tr><tr><td>createdUserId</td><td>NUMERIC</td></tr><tr><td>searchableInGlobalSearch</td><td>BOOLEAN</td></tr><tr><td>hasUniqueValue</td><td>BOOLEAN</td></tr><tr><td>numberDisplayHint</td><td>STRING</td></tr><tr><td>updatedUserId</td><td>NUMERIC</td></tr><tr><td>options</td><td>RECORD</td></tr></tbody></table>

### Deals&#x20;

With the Deals API, you can manage and interact with deal records in HubSpot, facilitating sales pipeline management and deal tracking.

For more information, see [HubSpot- Deals](https://legacydocs.hubspot.com/docs/methods/deals/deals_overview).

**FIELDS**&#x20;

<table><thead><tr><th width="101">Field Name</th><th width="101">Data Type</th></tr></thead><tbody><tr><td>portalId</td><td>NUMERIC</td></tr><tr><td>dealId</td><td>NUMERIC</td></tr><tr><td>isDeleted</td><td>BOOLEAN</td></tr><tr><td>associations</td><td>RECORD</td></tr><tr><td>properties</td><td>RECORD</td></tr></tbody></table>

### Contacts&#x20;

The Contacts API allows you to manage and retrieve information related to contact records in HubSpot, enabling efficient customer relationship management.

For more information, see [HubSpot- Contacts](https://legacydocs.hubspot.com/docs/methods/contacts/contacts-overview).

**FIELDS**

<table><thead><tr><th width="101">Field Name</th><th width="101">Data Type</th></tr></thead><tbody><tr><td>vid</td><td>NUMERIC</td></tr><tr><td>canonical-vid</td><td>NUMERIC</td></tr><tr><td>portal-id</td><td>NUMERIC</td></tr><tr><td>is-contact</td><td>BOOLEAN</td></tr><tr><td>properties</td><td>RECORD</td></tr><tr><td>form-submissions</td><td>RECORD</td></tr><tr><td>identity-profiles</td><td>RECORD</td></tr><tr><td>addedAt</td><td>NUMERIC</td></tr></tbody></table>

### Companies&#x20;

The Companies API offers tools to manage and interact with company records in HubSpot, facilitating B2B relationship management and data organization.

For more information, see[ HubSpot- Companies](https://legacydocs.hubspot.com/docs/methods/companies/companies-overview).

**FIELDS**

<table><thead><tr><th width="101">Field Name</th><th width="101">Data Type</th></tr></thead><tbody><tr><td>portalId</td><td>NUMERIC</td></tr><tr><td>companyId</td><td>NUMERIC</td></tr><tr><td>isDeleted</td><td>BOOLEAN</td></tr><tr><td>properties</td><td>RECORD</td></tr></tbody></table>

### Engagement&#x20;

The Engagement API provides access to engagement records, which include interactions such as emails, calls, and meetings, allowing for the tracking and analysis of customer engagements in HubSpot.

For more information, see [HubSpot- Engagement](https://legacydocs.hubspot.com/docs/methods/engagements/engagements-overview).

**FIELDS**

<table><thead><tr><th width="101">Field Name</th><th width="101">Data Type</th></tr></thead><tbody><tr><td>engagement</td><td>RECORD</td></tr><tr><td>associations</td><td>RECORD</td></tr><tr><td>metadata</td><td>RECORD</td></tr></tbody></table>