Salesforce Docs Portal

HubSpot Connector Objects (hubspotv4 Schema)

note: This feature is a Beta Service. A customer may opt to try a Beta Service in its sole discretion. Any use of the Beta Service is subject to the applicable Beta Services Terms provided at Agreements and Terms. If you have questions or feedback about this Beta Service, contact the Data 360 Connector team at datacloud-connectors-beta@salesforce.com.

Objects Supported

Name Description
AssociationsLabels Retrieve all available association types between a pair of CRM objects.
Companies Retrieve the available Companies in HubSpot. This table supports both OAuth and PrivateAppToken authentication.
CompanyAssociations Retrieve the IDs of all the objects associated to specific Deals objects in HubSpot. This table supports both OAuth and PrivateAppToken authentication.
CompanyPropertiesHistory Retrieve the available Company properties history in HubSpot.
ContactAssociations Retrieve the IDs of all the objects associated to specific Deals objects in HubSpot. This table supports both OAuth and PrivateAppToken authentication.
ContactPropertiesHistory Retrieve the available Contact properties history in HubSpot.
Contacts Retrieve the available Contacts in HubSpot. This table supports both OAuth and PrivateAppToken authentication.
ContactsToDealsAssociations Retrieve the IDs of all the Deals objects associated to specific Contacts objects in HubSpot. his table supports both OAuth and PrivateAppToken authentications.
DealAssociations Retrieve the IDs of all the objects associated to specific Deals objects in HubSpot. This table supports both OAuth and PrivateAppToken authentication.
DealPropertiesHistory Retrieve the available Deal properties history in HubSpot.
Deals Retrieve the available Deals in HubSpot. This table supports both OAuth and PrivateAppToken authentication.
EngagementsCalls Retrieve the available Calls in HubSpot.
EngagementsEmails Retrieve the available Emails in HubSpot.
EngagementsMeetings Retrieve the available Meetings in HubSpot.
EngagementsNotes Retrieve the available Notes in HubSpot.
EngagementsTasks Retrieve the available Tasks in HubSpot.
FeedbackSubmissionAssociations Retrieve the IDs of all the objects associated to specific feedback submissions objects in HubSpot.
FeedbackSubmissions Retrieve the available feedback submissions in HubSpot.
Goals Retrieve the available Goals in HubSpot.
LeadAssociations Retrieve the IDs of all the objects associated to specific Leads objects in HubSpot.
LeadPropertiesHistory Retrieve the available Lead properties history in HubSpot.
Leads Retrieve the available Leads in HubSpot.
LineitemAssociations Retrieve the IDs of all the objects associated to specific line items objects in HubSpot. This table supports both OAuth and PrivateAppToken authentication.
Lineitems Retrieve the available Lineitems in HubSpot. This table supports both OAuth and PrivateAppToken authentication.
OrderAssociations Retrieve the IDs of all the objects associated to specific Orders objects in HubSpot. This table supports both OAuth and PrivateAppToken authentications.
OrderPropertiesHistory Retrieve the available Order properties history in HubSpot.
Orders Retrieve the available Orders in HubSpot.
Products Retrieve the available Products in HubSpot. This table supports both OAuth and PrivateAppToken authentication.
QuoteAssociations Retrieve the IDs of all the objects associated to specific Quotes objects in HubSpot.
Quotes Retrieve the available Quotes in HubSpot.
TicketAssociations Retrieve the IDs of all the objects associated to specific Tickets objects in HubSpot. This table supports both OAuth and PrivateAppToken authentication.
TicketPropertiesHistory Retrieve the available ticket properties history in HubSpot.
Tickets Retrieve the available Tickets in HubSpot. This table supports both OAuth and PrivateAppToken authentication.

AssociationsLabels

Name Type ReadOnly References FilterOnly Description
TypeId [KEY] String True No The numeric ID for the association type.
Category [KEY] String False No The category of the association type for the specified object pair.
Label String False No The name of the association type for the specified object pair.
FromObjectType [KEY] String False No The first object's type to retrieve association types for.
ToObjectType [KEY] String False No The second object's type to retrieve association types for.

Return to Top

Companies

Name Type ReadOnly References FilterOnly Description
Id [KEY] Long False No Unique identifier of the object.
Archived Bool True No Whether the object is archived or not.
CreatedAt Datetime True No When the object was created.
UpdatedAt Datetime True No When the object was last updated.
ItemURL String True No Url that points directly to the HubSpot item.
About Us String False No Short about_company.
ClosedateTimestampEarliestValueA2a17e6e Datetime True No Calculation context property providing timestamp for rollup property closedate calculated as EARLIESTVALUE via values of closedate on object type ObjectTypeId_legacyObjectType_CONTACT
Facebook Fans Decimal False No Number of Facebook fans.
FirstContactCreatedateTimestampEarliestValue78b50eea Datetime True No Calculation context property providing timestamp for rollup property firstcontact_createdate calculated as EARLIEST_VALUE via values of createdate on object type ObjectTypeId_legacyObjectType_CONTACT
First Conversion Date Datetime True No The first conversion date across all contacts associated this company or organization.
FirstConversionDateTimestampEarliestValue61f58f2c Datetime True No Calculation context property providing timestamp for rollup property firstconversion_date calculated as EARLIEST_VALUE via values of first_conversion_date on object type ObjectTypeId_legacyObjectType_CONTACT
First Conversion String True No The first form submitted across all contacts associated this company or organization.
FirstConversionEventNameTimestampEarliestValue68ddae0a Datetime True No Calculation context property providing timestamp for rollup property firstconversion_event_name calculated as EARLIEST_VALUE via values of first_conversion_event_name on object type ObjectTypeId_legacyObjectType_CONTACT
First Deal Created Date Datetime True No Date the first deal was associated with this company record.
Year Founded String False No The year the company was created. Powered by HubSpot Insights.
Additional Domains String False No Additional domains belonging to this company.
Business units String False No The business units this record is assigned to.
Time First Seen Datetime True No The first activity for any contact associated with this company or organization.
HsAnalyticsFirstTimestampTimestampEarliestValue11e3a63a Datetime True No Calculation context property providing timestamp for rollup property hsanalytics_first_timestamp calculated as EARLIEST_VALUE via values of hs_analytics_first_timestamp on object type ObjectTypeId_legacyObjectType_CONTACT
First Touch Converting Campaign String True No The campaign responsible for the first touch creation of the first contact associated with this company.
HsAnalyticsFirstTouchConvertingCampaignTimestampEarliestValue4757fe10 Datetime True No Calculation context property providing timestamp for rollup property hsanalytics_first_touch_converting_campaign calculated as EARLIEST_VALUE via values of hs_analytics_first_touch_converting_campaign on object type ObjectTypeId_legacyObjectType_CONTACT
Time of First Session Datetime True No Time of first session across all contacts associated with this company or organization.
HsAnalyticsFirstVisitTimestampTimestampEarliestValueAccc17ae Datetime True No Calculation context property providing timestamp for rollup property hsanalytics_first_visit_timestamp calculated as EARLIEST_VALUE via values of hs_analytics_first_visit_timestamp on object type ObjectTypeId_legacyObjectType_CONTACT
Time Last Seen Datetime True No Time last seen across all contacts associated with this company or organization.
HsAnalyticsLastTimestampTimestampLatestValue4e16365a Datetime True No Calculation context property providing timestamp for rollup property hsanalytics_last_timestamp calculated as LATEST_VALUE via values of hs_analytics_last_timestamp on object type ObjectTypeId_legacyObjectType_CONTACT
Last Touch Converting Campaign String True No The campaign responsible for the last touch creation of the first contact associated with this company.
HsAnalyticsLastTouchConvertingCampaignTimestampLatestValue81a64e30 Datetime True No Calculation context property providing timestamp for rollup property hsanalytics_last_touch_converting_campaign calculated as LATEST_VALUE via values of hs_analytics_last_touch_converting_campaign on object type ObjectTypeId_legacyObjectType_CONTACT
Time of Last Session Datetime True No Time of the last session attributed to any contacts that are associated with this company record.
HsAnalyticsLastVisitTimestampTimestampLatestValue999a0fce Datetime True No Calculation context property providing timestamp for rollup property hsanalytics_last_visit_timestamp calculated as LATEST_VALUE via values of hs_analytics_last_visit_timestamp on object type ObjectTypeId_legacyObjectType_CONTACT
Latest Source String True No Source of the last session attributed to any contacts that are associated with this company.
Latest Source Data 1 String True No Additional source details of the last session attributed to any contacts that are associated with this company.
Latest Source Data 2 String True No Additional source details of the last session attributed to any contacts that are associated with this company.
Latest Source Timestamp Datetime True No Timestamp of when latest source occurred.
Number of Pageviews Decimal True No Total number of page views across all contacts associated with this company or organization.
HsAnalyticsNumPageViewsCardinalitySumE46e85b0 Decimal True No Calculation context property providing cardinality for rollup property hsanalytics_num_page_views calculated as SUM via values of hs_analytics_num_page_views on object type ObjectTypeId_legacyObjectType_CONTACT
Number of Sessions Decimal True No Total number of sessions across all contacts associated with this company or organization.
HsAnalyticsNumVisitsCardinalitySum53d952a6 Decimal True No Calculation context property providing cardinality for rollup property hsanalytics_num_visits calculated as SUM via values of hs_analytics_num_visits on object type ObjectTypeId_legacyObjectType_CONTACT
Original Source Type String False No Original source for the contact with the earliest activity for this company or organization.
Original Source Data 1 String True No Additional information about the original source for the contact with the earliest activity for this company or organization.
HsAnalyticsSourceData1TimestampEarliestValue9b2f1fa1 Datetime True No Calculation context property providing timestamp for rollup property hsanalytics_source_data_1 calculated as EARLIEST_VALUE via values of hs_analytics_source_data_1 on object type ObjectTypeId_legacyObjectType_CONTACT
Original Source Data 2 String True No Additional information about the original source for the contact with the earliest activity for this company or organization.
HsAnalyticsSourceData2TimestampEarliestValue9b2f9400 Datetime True No Calculation context property providing timestamp for rollup property hsanalytics_source_data_2 calculated as EARLIEST_VALUE via values of hs_analytics_source_data_2 on object type ObjectTypeId_legacyObjectType_CONTACT
HsAnalyticsSourceTimestampEarliestValue25a3a52c Datetime True No Calculation context property providing timestamp for rollup property hsanalytics_source calculated as EARLIEST_VALUE via values of hs_analytics_source on object type ObjectTypeId_legacyObjectType_CONTACT
Avatar FileManager key String True No The path in the FileManager CDN for this company's avatar override image. Automatically set by HubSpot.
Created by user ID Decimal True No The user that created this object. This value is automatically set by HubSpot and may not be modified.
Object create date_time Datetime True No The date and time at which this object was created. This value is automatically set by HubSpot and may not be modified.
Date entered 'Customer Lifecycle Stage Pipeline' Datetime True No The date and time when the company entered the 'Customer' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date entered 'Evangelist Lifecycle Stage Pipeline' Datetime True No The date and time when the company entered the 'Evangelist' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date entered 'Lead Lifecycle Stage Pipeline' Datetime True No The date and time when the company entered the 'Lead' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date entered 'Marketing Qualified Lead Lifecycle Stage Pipeline' Datetime True No The date and time when the company entered the 'Marketing Qualified Lead' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date entered 'Opportunity Lifecycle Stage Pipeline' Datetime True No The date and time when the company entered the 'Opportunity' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date entered 'Other Lifecycle Stage Pipeline' Datetime True No The date and time when the company entered the 'Other' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date entered 'Sales Qualified Lead Lifecycle Stage Pipeline' Datetime True No The date and time when the company entered the 'Sales Qualified Lead' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date entered 'Subscriber Lifecycle Stage Pipeline' Datetime True No The date and time when the company entered the 'Subscriber' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date exited 'Customer Lifecycle Stage Pipeline' Datetime True No The date and time when the company exited the 'Customer' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date exited 'Evangelist Lifecycle Stage Pipeline' Datetime True No The date and time when the company exited the 'Evangelist' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date exited 'Lead Lifecycle Stage Pipeline' Datetime True No The date and time when the company exited the 'Lead' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date exited 'Marketing Qualified Lead Lifecycle Stage Pipeline' Datetime True No The date and time when the company exited the 'Marketing Qualified Lead' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date exited 'Opportunity Lifecycle Stage Pipeline' Datetime True No The date and time when the company exited the 'Opportunity' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date exited 'Other Lifecycle Stage Pipeline' Datetime True No The date and time when the company exited the 'Other' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date exited 'Sales Qualified Lead Lifecycle Stage Pipeline' Datetime True No The date and time when the company exited the 'Sales Qualified Lead' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date exited 'Subscriber Lifecycle Stage Pipeline' Datetime True No The date and time when the company exited the 'Subscriber' stage_ 'Lifecycle Stage Pipeline' pipeline.
Ideal Customer Profile Tier String False No How well this company matches your Ideal Customer Profile. Tier 1 means a great fit for your productsservices Tier 3 might be acceptable_ but low priority.
Target Account Bool False No Identifies whether this company is being marketed and sold to as part of your account_based strategy.
Last Booked Meeting Date Datetime True No The last date of booked meetings associated with the company.
Last Logged Call Date Datetime True No The last date of logged calls associated with the company.
Last Open Task Date Datetime True No The last due date of open tasks associated with the company.
last sales activity date old Datetime True No The date of the last sales activity with the company in seconds.
Last Engagement Date Datetime True No The last time a contact engaged with your site or a form* document* meetings link_ or tracked email. This doesn't include marketing emails or emails to multiple contacts.
Last Engagement Type String True No The type of the last engagement a company performed. This doesn't include marketing emails or emails to multiple contacts.
Last Modified Date Datetime True No Most recent timestamp of any property update for this company. This includes HubSpot internal properties_ which can be visible or hidden. This property is updated automatically.
Latest create date of active subscriptions Datetime True No Latest created date of all associated active Subscriptions.
Merged object IDs String True No The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.
Number of blockers Decimal True No The number of contacts associated with this company with the role of blocker.
Number of contacts with a buying role Decimal True No The number of contacts associated with this company with a buying role.
Number of decision makers Decimal True No The number of contacts associated with this company with the role of decision maker.
Number of open deals Decimal True No The number of open deals associated with this company.
Record ID Decimal True No The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
Pinned Engagement ID Decimal True No The object ID of the current pinned engagement. This value is automatically set by HubSpot and may not be modified.
Pipeline String False No The pipeline with which this company is currently associated.
Likelihood to close Decimal True No The highest probability that a contact associated with this company will become a customer within the next 90 days. This score is based on standard contact properties and behavior.
HsPredictivecontactscoreV2NextMaxMaxD4e58c1e Decimal True No Calculation context property providing nextmax for rollup property hs_predictivecontactscore_v2 calculated as MAX via values of hs_predictivecontactscore_v2 on object type ObjectTypeId_legacyObjectType_CONTACT
Read Only Object Bool True No Is the object read only.
Target Account2 String False No The Target Account property is a means to flag high priority companies if you are following an account based strategy
Target Account Probability Decimal True No The probability a company is marked as a target account
Target Account Recommendation Snooze Time Datetime False No The date when the target account recommendation is snoozed.
Target Account Recommendation State String False No The state of the target account recommendation.
Time in 'Customer Lifecycle Stage Pipeline' Decimal True No The total time in seconds spent by the company in the 'Customer' stage_ 'Lifecycle Stage Pipeline' pipeline.
Time in 'Evangelist Lifecycle Stage Pipeline' Decimal True No The total time in seconds spent by the company in the 'Evangelist' stage_ 'Lifecycle Stage Pipeline' pipeline.
Time in 'Lead Lifecycle Stage Pipeline' Decimal True No The total time in seconds spent by the company in the 'Lead' stage_ 'Lifecycle Stage Pipeline' pipeline.
Time in 'Marketing Qualified Lead Lifecycle Stage Pipeline' Decimal True No The total time in seconds spent by the company in the 'Marketing Qualified Lead' stage_ 'Lifecycle Stage Pipeline' pipeline.
Time in 'Opportunity Lifecycle Stage Pipeline' Decimal True No The total time in seconds spent by the company in the 'Opportunity' stage_ 'Lifecycle Stage Pipeline' pipeline.
Time in 'Other Lifecycle Stage Pipeline' Decimal True No The total time in seconds spent by the company in the 'Other' stage_ 'Lifecycle Stage Pipeline' pipeline.
Time in 'Sales Qualified Lead Lifecycle Stage Pipeline' Decimal True No The total time in seconds spent by the company in the 'Sales Qualified Lead' stage_ 'Lifecycle Stage Pipeline' pipeline.
Time in 'Subscriber Lifecycle Stage Pipeline' Decimal True No The total time in seconds spent by the company in the 'Subscriber' stage_ 'Lifecycle Stage Pipeline' pipeline.
Total open deal value Decimal True No The total value* in your company's currency* of all open deals associated with this company.
Unique creation key String True No Unique property used for idempotent creates.
Updated by user ID Decimal True No The user that last updated this object. This value is automatically set by HubSpot and may not be modified.
User IDs of all notification followers String True No The user IDs of all users that have clicked follow within the object to opt_in to getting follow notifications.
User IDs of all notification unfollowers String True No The user IDs of all object owners that have clicked unfollow within the object to opt_out of getting follow notifications.
User IDs of all owners String True No The user IDs of all owners of this object.
Owner Assigned Date Datetime True No The timestamp when an owner was assigned to this company.
Is Public Bool False No Indicates if the company is publicly traded. Powered by HubSpot Insights.
Number of Associated Contacts Decimal True No The number of contacts associated with this company.
Number of Associated Deals Decimal True No The number of deals associated with this company.
Number of Form Submissions Decimal True No The number of forms submission for all contacts associated with this company or organization.
NumConversionEventsCardinalitySumD095f14b Decimal True No Calculation context property providing cardinality for rollup property numconversion_events calculated as SUM via values of num_conversion_events on object type ObjectTypeId_legacyObjectType_CONTACT
Recent Conversion Date Datetime True No The most recent conversion date across all contacts associated this company or organization.
RecentConversionDateTimestampLatestValue72856da1 Datetime True No Calculation context property providing timestamp for rollup property recentconversion_date calculated as LATEST_VALUE via values of recent_conversion_date on object type ObjectTypeId_legacyObjectType_CONTACT
Recent Conversion String True No The last form submitted across all contacts associated this company or organization.
RecentConversionEventNameTimestampLatestValue66c820bf Datetime True No Calculation context property providing timestamp for rollup property recentconversion_event_name calculated as LATEST_VALUE via values of recent_conversion_event_name on object type ObjectTypeId_legacyObjectType_CONTACT
Recent Deal Amount Decimal True No The amount of the last deal closed.
Recent Deal Close Date Datetime True No Date of the last .
Time Zone String False No Time zone where the company or organization is located. Powered by HubSpot Insights.
Total Money Raised String False No The total amount of money raised by the company. Powered by HubSpot Insights.
Total Revenue Decimal True No The total amount of closed won deals.
Company name String False No The name of the company or organization. Powered by HubSpot Insights.
HubSpot Owner Email String False No HubSpot owner email for this company or organization.
Twitter Handle String False No The main twitter account of the company or organization.
HubSpot Owner Name String False No HubSpot owner name for this company or organization.
Phone Number String False No Company primary phone number. Powered by HubSpot Insights.
Twitter Bio String False No The Twitter bio of the company or organization.
Twitter Followers Decimal False No The number of Twitter followers of the company or organization.
Street Address String False No Street address of the company or organization_ including unit number. Powered by HubSpot Insights.
Street Address 2 String False No Additional address of the company or organization. Powered by HubSpot Insights.
Facebook Company Page String False No The URL of the Facebook company page for the company or organization
City String False No City where the company is located. Powered by HubSpot Insights.
LinkedIn Company Page String False No The URL of the LinkedIn company page for the company or organization.
LinkedIn Bio String False No The LinkedIn bio for the company or organization.
State_Region String False No State or region in which the company or organization is located. Powered by HubSpot Insights.
Google Plus Page String False No The URL of the Google Plus page for the company or organization.
Date of last meeting booked in meetings tool Datetime True No Last Meeting Booked for any contact associated with this Company_Organization.
Campaign of last booking in meetings tool String True No This UTM parameter shows which marketing campaign e.g. a specific email referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.
Medium of last booking in meetings tool String True No This UTM parameter shows which channel e.g. email referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.
Source of last booking in meetings tool String True No This UTM parameter shows which site e.g. Twitter referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.
Latest meeting activity Datetime True No The date of the most recent meeting past or upcoming logged for* scheduled with* or booked by a contact associated with this company.
Recent Sales Email Replied Date Datetime True No The last time a tracked sales email was replied to by this company.
Company owner String False No The owner of the company.
Last Contacted Datetime True No Timestamp of the last call* email* or meeting that was logged for a contact at this company.
Last Activity Date Datetime True No The last time a note* call* meeting_ or task was logged for a company. This is set automatically by HubSpot based on user actions in the company record.
Next Activity Date Datetime True No Date of the next upcoming scheduled sales activity for this company record.
Number of times contacted Decimal True No The number of times a call_ email or meeting was logged for this company.
Number of Sales Activities Decimal True No Number of sales activities for this company. For example* a call* email or meeting logged.
Postal Code String False No Postal or zip code of the company or organization. Powered by HubSpot Insights.
Country_Region String False No Country in which the company or organization is located. Powered by HubSpot Insights.
HubSpot Team String True No The team of the owner of the company.
All owner ids String True No The value of all owner referencing properties for this object_ both default and custom.
Website URL String False No The main website of the company or organization. This property is used to identify unique companies. Powered by HubSpot Insights.
Company Domain Name String False No The domain name of the company or organization.
All team ids String True No The team ids corresponding to all owner referencing properties for this object_ both default and custom.
All accessible team ids String True No The team ids* including up the team hierarchy* corresponding to all owner referencing properties for this object_ both default and custom.
Number of Employees Decimal False No The total number of employees who work for the company or organization. Powered by HubSpot Insights.
Industry String False No The type of business the company performs. By default* this property has approximately 150 pre_defined options to select from. While these options cannot be deleted as they used by HubSpot Insights* you can add new custom options to meet your needs.
Annual Revenue Decimal False No The actual or estimated annual revenue of the company. Powered by HubSpot Insights.
Lifecycle Stage String False No The most advanced lifecycle stage across all contacts associated with this company or organization.
Lead Status String False No The company's sales_ prospecting or outreach status.
Parent Company Decimal True No The parent company of this company.
Type String False No The optional classification of this company record _ prospect_ partner_ etc.
Description String False No A short statement about the company's mission and goals. Powered by HubSpot Insights.
Number of child companies Decimal True No The number of child companies of this company.
HubSpot Score Decimal True No The sales and marketing score for the company or organization.
Create Date Datetime True No The date the company or organization was added to the database.
Close Date Datetime False No The date the company or organization was closed as a customer.
First Contact Create Date Datetime True No The date that the first contact from this company entered the system_ which could pre_date the company's create date.
Days to Close Decimal True No The number of days between when the company record was created and when they closed as a customer.
Web Technologies String False No The web technologies used by the company or organization. Powered by HubSpot Insights.

Return to Top

CompanyAssociations

Name Type ReadOnly References FilterOnly Description
Id [KEY] Long False Companies.Id No Companies ID.
AssociationId [KEY] Long False No ID of the object that this Company object is associated with.
Type [KEY] String False No Type of the associated object* which can be a contact* deal etc.
TypeId [KEY] String False AssociationsLabels.TypeId No The numeric ID for the association type. This column is empty for more general associations queries.
Category [KEY] String False AssociationsLabels.Category No The category of the association type for the specified object pair. This column is empty for more generic associations queries.
TypeLabel String True AssociationsLabels.Label No The label assigned to the association type between objects.

Return to Top

CompanyPropertiesHistory

Name Type ReadOnly References FilterOnly Description
PropertyName String True No The name of the property.
Value String True No The historical value of the property.
SourceType String True No The method by which the property was changed.
SourceId String True No Additional data related to the source. May not be populated for all sources.
Timestamp Datetime True No Datetime when the property was updated.
CompanyId Long True No The company identifier.

Return to Top

ContactAssociations

Name Type ReadOnly References FilterOnly Description
Id [KEY] Long False Contacts.Id No Contacts ID.
AssociationId [KEY] Long False No ID of the object that this Contact object is associated with.
Type [KEY] String False No Type of the associated object* which can be a contact* deal etc.
TypeId [KEY] String False AssociationsLabels.TypeId No The numeric ID for the association type. This column is empty for more general associations queries.
Category [KEY] String False AssociationsLabels.Category No The category of the association type for the specified object pair. This column is empty for more generic associations queries.
TypeLabel String True AssociationsLabels.Label No The label assigned to the association type between objects.

Return to Top

ContactPropertiesHistory

Name Type ReadOnly References FilterOnly Description
PropertyName String True No The name of the property.
Value String True No The historical value of the property.
SourceType String True No The method by which the property was changed.
SourceId String True No Additional data related to the source. May not be populated for all sources.
Timestamp Datetime True No Datetime when the property was updated.
ContactId Long True No The contact identifier.
ContactEmail String True No The contact's email address.
ContactPhoneNumber String True No The contact's primary phone number.

Return to Top

Contacts

Name Type ReadOnly References FilterOnly Description
Id [KEY] Long False No Unique identifier of the object.
Archived Bool True No Whether the object is archived or not.
CreatedAt Datetime True No When the object was created.
UpdatedAt Datetime True No When the object was last updated.
ItemURL String True No Url that points directly to the HubSpot item.
Company size String False No Contact's company size. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Date of birth String False No Contact's date of birth. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Days To Close Decimal True No Count of days elapsed between creation and being closed as a customer. Set automatically.
Degree String False No Contact's degree. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Field of study String False No Contact's field of study. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
First Conversion Date Datetime True No Date this contact first submitted a form.
First Conversion String True No First form this contact submitted.
First Deal Created Date Datetime True No Date first deal was created for contact. Set automatically.
Gender String False No Contact's gender. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Graduation date String False No Contact's graduation date. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Additional email addresses String True No A set of additional email addresses for a contact.
Business units String False No The business units this record is assigned to.
All vids for a contact String True No A set of all vids* canonical or otherwise* for a contact.
First Touch Converting Campaign String True No Campaign responsible for the first touch creation of this contact.
Last Touch Converting Campaign String True No Campaign responsible for the last touch creation of this contact.
Avatar FileManager key String True No The path in the FileManager CDN for this contact's avatar override image. Automatically set by HubSpot.
Buying Role String False No Role the contact plays during the sales process. Contacts can have multiple roles_ and can share roles with others.
All form submissions for a contact String True No A set of all form submissions for a contact.
Merged vids with timestamps of a contact String True No Merged vids with timestamps of a contact.
Calculated Mobile Number in International Format String True No Mobile number in international format.
Calculated Phone Number in International Format String True No Phone number in international format.
Calculated Phone Number Area Code String True No Area Code of the calculated phone number.
Calculated Phone Number Country Code String True No Country code of the calculated phone number.
Calculated Phone Number Region String True No ISO2 Country code for the derived phone number.
Clicked on a LinkedIn Ad String False No Whether contact has clicked on a LinkedIn Ad.
Email Confirmed Bool True No Email Confirmation status of user of Content Membership.
Registration Follow Up Email Enqueued At Datetime False No The time when the first registration follow up email was enqueued.
Membership Notes String False No Notes relating to the contact's content membership.
Registered At Datetime True No Datetime at which this user was set up for Content Membership.
Domain to which registration email was sent String True No Domain to which the registration invitation email for Content Membership was sent to.
Time registration email was sent Datetime True No Datetime at which this user was sent a registration invitation email for Content Membership.
Status String False No Status of the contact's content membership.
Conversations visitor email String True No A Conversations visitor's email address.
Count of unengaged contacts Decimal True No if contact is assigned and unworked* set to 1. if contact is assigned and worked* set to 0.
Count of engaged contacts Decimal True No if contact is assigned and worked* set to 1. if contact is assigned and unworked* set to 0.
Created By Conversations Bool True No Flag indicating this contact was created by the Conversations API.
Created by user ID Decimal True No The user that created this object. This value is automatically set by HubSpot and may not be modified.
Object create date_time Datetime True No The date and time at which this object was created. This value is automatically set by HubSpot and may not be modified.
Date entered 'Customer Lifecycle Stage Pipeline' Datetime True No The date and time when the contact entered the 'Customer' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date entered 'Evangelist Lifecycle Stage Pipeline' Datetime True No The date and time when the contact entered the 'Evangelist' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date entered 'Lead Lifecycle Stage Pipeline' Datetime True No The date and time when the contact entered the 'Lead' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date entered 'Marketing Qualified Lead Lifecycle Stage Pipeline' Datetime True No The date and time when the contact entered the 'Marketing Qualified Lead' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date entered 'Opportunity Lifecycle Stage Pipeline' Datetime True No The date and time when the contact entered the 'Opportunity' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date entered 'Other Lifecycle Stage Pipeline' Datetime True No The date and time when the contact entered the 'Other' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date entered 'Sales Qualified Lead Lifecycle Stage Pipeline' Datetime True No The date and time when the contact entered the 'Sales Qualified Lead' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date entered 'Subscriber Lifecycle Stage Pipeline' Datetime True No The date and time when the contact entered the 'Subscriber' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date exited 'Customer Lifecycle Stage Pipeline' Datetime True No The date and time when the contact exited the 'Customer' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date exited 'Evangelist Lifecycle Stage Pipeline' Datetime True No The date and time when the contact exited the 'Evangelist' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date exited 'Lead Lifecycle Stage Pipeline' Datetime True No The date and time when the contact exited the 'Lead' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date exited 'Marketing Qualified Lead Lifecycle Stage Pipeline' Datetime True No The date and time when the contact exited the 'Marketing Qualified Lead' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date exited 'Opportunity Lifecycle Stage Pipeline' Datetime True No The date and time when the contact exited the 'Opportunity' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date exited 'Other Lifecycle Stage Pipeline' Datetime True No The date and time when the contact exited the 'Other' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date exited 'Sales Qualified Lead Lifecycle Stage Pipeline' Datetime True No The date and time when the contact exited the 'Sales Qualified Lead' stage_ 'Lifecycle Stage Pipeline' pipeline.
Date exited 'Subscriber Lifecycle Stage Pipeline' Datetime True No The date and time when the contact exited the 'Subscriber' stage_ 'Lifecycle Stage Pipeline' pipeline.
Recent Document Revisit Date Datetime True No The last time a shared document presentation was accessed by this contact.
Invalid email address Bool True No The email address associated with this contact is invalid.
Email address quarantine reason String False No The reason why the email address has been quarantined.
Email Domain String True No A contact's email address domain.
Email hard bounce reason String True No The issue that caused a contact to hard bounce from your emails. If this is an error or a temporary issue_ you can unbounce this contact from the contact record.
Email hard bounce reason2 String True No The issue that caused a contact to hard bounce from your emails. If this is an error or a temporary issue_ you can unbounce this contact from the contact record.
Email Address Quarantined Bool True No Indicates that the current email address has been quarantined for anti_abuse reasons and any marketing email sends to it will be blocked. This is automatically set by HubSpot.
Email address automated quarantine reason String True No The automated reason why the email address has been quarantined.
Email Address Recipient Fatigue Next Available Sending Time Datetime True No When this recipient has reached the limit of email sends per time period_ this property indicates the next available time to send. This is automatically set by HubSpot.
Sends Since Last Engagement Decimal True No The number of marketing emails that have been sent to the current email address since the last engagement open or link click. This is automatically set by HubSpot.
Marketing email confirmation status String True No The status of a contact's eligibility to receive marketing email. This is automatically set by HubSpot.
Clicked Facebook ad Bool False No Whether contact has clicked a Facebook ad.
Facebook click id String False No
Facebook ID String False No A contact's Facebook id.
Last NPS survey comment String True No Last NPS survey comment that this contact gave.
Last NPS survey rating String True No Last NPS survey rating that this contact gave.
Last NPS survey date Datetime True No The time that this contact last submitted a NPS survey response. This is automatically set by HubSpot.
Should be shown an NPS web survey Bool False No Whether or not a contact should be shown an NPS web survey. This is automatically set by HubSpot.
ID of first engagement Decimal True No The object id of the current contact owner's first engagement with the contact. Used in Sales Analytics app.
First subscription create date Datetime True No The create date of the first subscription by the contact.
Google ad click id String False No
googleplus ID String False No A contact's googleplus id.
Contact has an active subscription Decimal True No The rollup property value is 1 when the contact has an active Subscription or 0 otherwise.
IP Timezone String True No The timezone reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
Is a contact Bool True No Is a contact_ has not been deleted and is not a visitor.
Contact unworked Bool True No Contact has not been assigned or has not been engaged after last owner assignment_re_assignment.
last sales activity date old Datetime True No The date of the last sales activity with the contact. This property is set automatically by HubSpot. Note_ This field is only updated for contacts with an owner.
Last Engagement Date Datetime True No The last time a contact engaged with your site or a form* document* meetings link_ or tracked email. This doesn't include marketing emails or emails to multiple contacts.
Last Engagement Type String True No The type of the last engagement a contact performed. This doesn't include marketing emails or emails to multiple contacts.
Object last modified date_time Datetime True No Most recent timestamp of any property update for this contact. This includes HubSpot internal properties_ which can be visible or hidden. This property is updated automatically.
Last sequence ended date Datetime True No The last sequence ended date.
Last sequence enrolled Decimal True No The last sequence enrolled.
Last sequence enrolled date Datetime True No The last sequence enrolled date.
Last sequence finished date Datetime True No The last sequence finished date.
Last sequence unenrolled date Datetime True No The last sequence unenrolled date.
Latest Source Date Date False No The time of the latest session for a contact.
Latest subscription create date Datetime True No The create date of the latest subscription by the contact.
Lead Status String False No The contact's sales_ prospecting or outreach status.
Legal basis for processing contact's data String False No Legal basis for processing contact's data_ 'Not applicable' will exempt the contact from GDPR protections.
Clicked LinkedIn Ad String False No
Linkedin ID String False No A contact's linkedin id.
Marketing contact status source name String True No The ID of the activity that set the contact as a marketing contact.
Marketing contact status source type String True No The type of the activity that set the contact as a marketing contact.
Marketing contact status String True No The marketing status of a contact.
Marketing contact until next update String True No Specifies if this contact will be set as non_marketing on renewal.
Merged object IDs String True No The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.
Record ID Decimal True No The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
Pinned engagement ID Decimal True No
Pipeline String False No The pipeline with which this contact is currently associated.
Likelihood to close Decimal True No The probability that a contact will become a customer within the next 90 days. This score is based on standard contact properties and behavior.
Contact priority String True No A ranking system of contacts evenly assigned into four tiers. Contacts in tier one are more likely to become customers than contacts in tier four.
Read Only Object Bool True No Is the object read only.
Date of first engagement Datetime True No The date the current contact owner first engaged with the contact. Used in Sales Analytics app.
Description of first engagement String True No A description of the current contact owner's first engagement with the contact. Used in the Sales Analytics app.
Type of first engagement String True No The object type of the current contact owner's first engagement with the contact. Used in the Sales Analytics app.
Recent Sales Email Clicked Date Datetime True No The last time a tracked sales email was clicked by this user.
Recent Sales Email Opened Date Datetime True No The last time a tracked sales email was opened by this contact. This property does not update for emails that were sent to more than one contact.
Calculated Mobile Number with country code String True No Mobile number with country code.
Calculated Phone Number with country code String True No Phone number with country code.
Calculated Mobile Number without country code String True No Mobile number without country code.
Calculated Phone Number without country code String True No Phone number without country code.
Number of sequences actively enrolled Decimal True No The number of sequences actively enrolled.
Number of sequences enrolled Decimal True No The number of sequences enrolled.
Currently in Sequence Bool True No A yes_no field that indicates whether the contact is currently in a Sequence.
testpurge String True No Testing purge.
testrollback String True No Testing rollback.
Time between contact creation and deal close Decimal False No
Time between contact creation and deal creation Decimal False No
Time in 'Customer Lifecycle Stage Pipeline' Decimal True No The total time in seconds spent by the contact in the 'Customer' stage_ 'Lifecycle Stage Pipeline' pipeline.
Time in 'Evangelist Lifecycle Stage Pipeline' Decimal True No The total time in seconds spent by the contact in the 'Evangelist' stage_ 'Lifecycle Stage Pipeline' pipeline.
Time in 'Lead Lifecycle Stage Pipeline' Decimal True No The total time in seconds spent by the contact in the 'Lead' stage_ 'Lifecycle Stage Pipeline' pipeline.
Time in 'Marketing Qualified Lead Lifecycle Stage Pipeline' Decimal True No The total time in seconds spent by the contact in the 'Marketing Qualified Lead' stage_ 'Lifecycle Stage Pipeline' pipeline.
Time in 'Opportunity Lifecycle Stage Pipeline' Decimal True No The total time in seconds spent by the contact in the 'Opportunity' stage_ 'Lifecycle Stage Pipeline' pipeline.
Time in 'Other Lifecycle Stage Pipeline' Decimal True No The total time in seconds spent by the contact in the 'Other' stage_ 'Lifecycle Stage Pipeline' pipeline.
Time in 'Sales Qualified Lead Lifecycle Stage Pipeline' Decimal True No The total time in seconds spent by the contact in the 'Sales Qualified Lead' stage_ 'Lifecycle Stage Pipeline' pipeline.
Time in 'Subscriber Lifecycle Stage Pipeline' Decimal True No The total time in seconds spent by the contact in the 'Subscriber' stage_ 'Lifecycle Stage Pipeline' pipeline.
Lead response time Decimal True No Time it took current owner to do first qualifying engagement ms. Used in Sales Analytics app.
Time to move from lead to customer Decimal False No How long it takes for a contact to move from the HubSpot lead stage to the HubSpot customer stage.
Time to move from marketing qualified lead to customer Decimal False No How long it takes for a contact to move from the HubSpot marketing qualified lead stage to the HubSpot customer stage.
Time to move from opportunity to customer Decimal False No How long it takes for a contact to move from the HubSpot opportunity stage to the HubSpot customer stage.
Time to move from sales qualified lead to customer Decimal False No How long it takes for a contact to move from the HubSpot sales qualified lead stage to the HubSpot customer stage.
Time to move from subscriber to customer Decimal False No How long it takes for a contact to move from the HubSpot subscriber stage to the HubSpot customer stage.
Time Zone String False No The contact_s time zone. This can be set automatically by HubSpot based on other contact properties. It can also be set manually for each contact.
Twitter ID String False No A contact's Twitter id.
Unique creation key String True No Unique property used for idempotent creates.
Updated by user ID Decimal True No The user that last updated this object. This value is automatically set by HubSpot and may not be modified.
User IDs of all notification followers String True No The user IDs of all users that have clicked follow within the object to opt_in to getting follow notifications.
User IDs of all notification unfollowers String True No The user IDs of all object owners that have clicked unfollow within the object to opt_out of getting follow notifications.
User IDs of all owners String True No The user IDs of all owners of this object.
WhatsApp Phone Number String False No The phone number associated with the contact_s WhatsApp account.
Owner Assigned Date Datetime True No The most recent date a HubSpot Owner was assigned to a contact. This is set automatically by HubSpot and can be used for segmentation and reporting.
IP City String True No The city reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
IP Country String True No The country reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
IP Country Code String True No The country code reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
IP Latitude _ Longitude String True No
IP State_Region String True No The state or region reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
IP State Code_Region Code String True No The state code or region code reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
IP Zipcode String True No The zipcode reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
Job function String False No Contact's job function. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Last Modified Date Datetime True No The date any property on this contact was modified.
Marital Status String False No Contact's marital status. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Military status String False No Contact's military status. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Number of Associated Deals Decimal True No Count of deals associated with this contact. Set automatically by HubSpot.
Number of Form Submissions Decimal True No The number of forms this contact has submitted.
Number of Unique Forms Submitted Decimal True No The number of different forms this contact has submitted.
Recent Conversion Date Datetime True No The date this contact last submitted a form.
Recent Conversion String True No The last form this contact submitted.
Recent Deal Amount Decimal True No Amount of last closed won deal associated with a contact. Set automatically.
Recent Deal Close Date Datetime True No Date last deal associated with contact was closed_won. Set automatically.
Relationship Status String False No Contact's relationship status. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
School String False No Contact's school. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Seniority String False No Contact's seniority. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Start date String False No Contact's start date. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Total Revenue Decimal True No Sum of all closed_won deal revenue associated with the contact. Set automatically.
Work email String False No Contact's work email. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
First Name String False No A contact's first name.
First Page Seen String True No First page the contact visited on your website. Set automatically.
Marketing emails delivered Decimal True No The number of marketing emails delivered for the current email address. This is automatically set by HubSpot.
Opted out of emailCustomer Service Communication String True No Indicates that the current email address has opted out of this email type.
Opted out of emailOne to One String True No This column is a custom field. Indicates that the current email address has opted out of this email type.
Twitter Username String False No The contact's Twitter handle.
Currently in workflow String True No True when contact is enrolled in a workflow.
Follower Count Decimal False No The number of Twitter followers a contact has.
Last Page Seen String True No Last page the contact visited on your website. Set automatically.
Marketing emails opened Decimal True No The number of marketing emails opened for the current email address. This is automatically set by HubSpot.
Last Name String False No A contact's last name.
Number of Pageviews Decimal True No Total number of page views this contact has had on your website. Set automatically.
Marketing emails clicked Decimal True No The number of marketing emails which have had link clicks for the current email address. This is automatically set by HubSpot.
Salutation String False No The title used to address a contact.
Twitter Profile Photo String False No The contact's Twitter profile photo. This is set by HubSpot using the contact's email address.
Email String False No A contact's email address.
Number of Sessions Decimal True No Number of times a contact has come to your website. Set automatically.
Marketing emails bounced Decimal True No The number of marketing emails that bounced for the current email address. This is automatically set by HubSpot.
Persona String False No A contact's persona.
Most Recent Social Click Datetime True No The date of the most recent click on a published social message. This is set automatically by HubSpot for each contact.
Number of event completions Decimal True No Total number of events for this contact. Set automatically.
Unsubscribed from all email Bool True No Indicates that the current email address has opted out of all email.
Twitter Clicks Decimal True No The number of times a contact clicked on links you shared on Twitter through HubSpot. This is set automatically by HubSpot and can be used for segmentation.
Mobile Phone Number String False No A contact's mobile phone number.
Phone Number String False No A contact's primary phone number.
Fax Number String False No A contact's primary fax number.
Time First Seen Datetime True No First time the contact has been seen. Set automatically.
Last marketing email name String True No The name of the last marketing email sent to the current email address. This is automatically set by HubSpot.
Last marketing email send date Datetime True No The date of the most recent delivery for any marketing email to the current email address. This is automatically set by HubSpot.
Facebook Clicks Decimal True No The number clicks on links shared on Facebook.
Street Address String False No Contact's street address_ including apartment or unit number.
Date of last meeting booked in meetings tool Datetime True No The date of the last meeting that has been scheduled by a contact through the meetings tool. If multiple meetings have been scheduled_ the date of the last chronological meeting in the timeline is shown.
Campaign of last booking in meetings tool String True No UTM parameter for marketing campaign e.g. a specific email responsible for recent meeting booking. Only populated when tracking parameters are included in meeting link.
Medium of last booking in meetings tool String True No UTM parameter for the channel e.g. email responsible for most recent meeting booking. Only populated when tracking parameters are included in meeting link.
Source of last booking in meetings tool String True No UTM parameter for the site e.g. Twitter responsible for most recent meeting booking. Only populated when tracking parameters are included in meeting link.
Time of First Session Datetime True No First time the contact visited your website. Set automatically.
Last marketing email open date Datetime True No The date of the most recent open for any marketing email to the current email address. This is automatically set by HubSpot.
Latest meeting activity Datetime True No The date of the most recent meeting past or upcoming logged for* scheduled with* or booked by this contact.
Recent Sales Email Replied Date Datetime True No The last time a tracked sales email was replied to by this user. This is set automatically by HubSpot based on user actions in the contact record.
LinkedIn Clicks Decimal True No The number clicks on links shared on LinkedIn.
Contact owner String False No The owner of a contact. This can be any HubSpot user or Salesforce integration user_ and can be set manually or via Workflows.
Last Contacted Datetime True No The last time a call* email* or meeting was logged for a contact. This is set automatically by HubSpot based on user actions in the contact record.
Last Activity Date Datetime True No The last time a note* call* email* meeting* or task was logged for a contact. This is set automatically by HubSpot based on user actions in the contact record.
Next Activity Date Datetime True No The date of the next upcoming activity for a contact. This is set automatically by HubSpot based on user actions in the contact record.
Number of times contacted Decimal True No The number of times a call* email* or meeting was logged for a contact. This is set automatically by HubSpot based on user actions in the contact record.
Number of Sales Activities Decimal True No The number of sales activities for a contact. This is set automatically by HubSpot based on user actions in the contact record.
HubSpot Owner Email legacy String False No A legacy property used to identify the email address of the owner of the contact. This property is no longer in use.
HubSpot Owner Name legacy String False No A legacy property used to identify the name of the owner of the contact. This property is no longer in use.
SurveyMonkey Event Last Updated Decimal True No This field is meaningless on its own_ and is solely used for triggering dynamic list updates when SurveyMonkey information is updated.
Webinar Event Last Updated Decimal True No This field is meaningless on its own_ and is solely used for triggering dynamic list updates when webinar information is updated.
City String False No A contact's city of residence.
Time Last Seen Datetime True No Timestamp for most recent webpage view on your website.
Last marketing email click date Datetime True No The date of the most recent link click for any marketing email to the current email address. This is automatically set by HubSpot.
Google Plus Clicks Decimal True No The number clicks on links shared on Google Plus.
HubSpot Team String True No The team of the owner of a contact.
LinkedIn Bio String False No A contact's LinkedIn bio.
Twitter Bio String False No The contact's Twitter bio. This is set by HubSpot using the contact's email address.
All owner ids String True No The value of all owner referencing properties for this object_ both default and custom.
Time of Last Session Datetime True No Timestamp for start of the most recent session for this contact to your website.
First marketing email send date Datetime True No The date of the earliest delivery for any marketing email to the current email address. This is automatically set by HubSpot.
Broadcast Clicks Decimal True No The number of clicks on published social messages. This is set automatically by HubSpot for each contact.
State_Region String False No The contact's state of residence. This might be set via import* form* or integration.
All team ids String True No The team ids corresponding to all owner referencing properties for this object_ both default and custom.
Original Source String False No First known source the contact used to find your website. Set automatically_ but may be updated manually.
First marketing email open date Datetime True No The date of the earliest open for any marketing email to the current email address. This is automatically set by HubSpot.
Latest Source String False No The source of the latest session for a contact.
Postal Code String False No The contact's zip code. This might be set via import* form* or integration.
Country_Region String False No The contact's countryregion of residence. This might be set via import form_ or integration.
All accessible team ids String True No The team ids* including up the team hierarchy* corresponding to all owner referencing properties for this object_ both default and custom.
Original Source DrillDown 1 String True No Additional information about the source the contact used to find your website. Set automatically.
First marketing email click date Datetime True No The date of the earliest link click for any marketing email to the current email address. This is automatically set by HubSpot.
Latest Source DrillDown 1 String True No Additional information about the latest source for the last session the contact used to find your website. Set automatically.
LinkedIn Connections Decimal False No How many LinkedIn connections they have.
Original Source DrillDown 2 String True No Additional information about the source the contact used to find your website. Set automatically.
Is globally ineligible Bool True No Indicates the contact is globally ineligible for email.
Preferred language String False No Set your contact's preferred language for communications. This property can be changed from an import* form* or integration.
Latest Source DrillDown 2 String True No Additional information about the source for the last session the contact used to find your website. Set automatically.
Klout Score Decimal False No A contact's Klout score_ a measure of Internet influence.
First Referring Site String True No URL that referred the contact to your website. Set automatically.
First marketing email reply date Datetime True No The date of the earliest reply for any marketing email to the current email address. This is automatically set by HubSpot.
Job Title String False No A contact's job title.
Photo String False No Social Media photo.
Last Referring Site String True No Last URL that referred contact to your website. Set automatically.
Last marketing email reply date Datetime True No The date of the latest reply for any marketing email to the current email address. This is automatically set by HubSpot.
Message String False No A default property to be used for any message or comments a contact may want to leave on a form.
Close Date Datetime False No Date the contact became a customer. Set automatically when a deal or opportunity is marked as closed_won. It can also be set manually or programmatically.
Average Pageviews Decimal True No Average number of pageviews per session for this contact. Set automatically.
Marketing emails replied Decimal True No The number of marketing emails replied to by the current email address. This is automatically set by HubSpot.
Event Revenue Decimal True No Set event revenue on a contact though the Enterprise Events feature. http___help.hubspot.com_articles_KCS_Article_Reports_How_do_I_create_Events_in_HubSpot
Became a Lead Date Datetime True No The date when a contact's lifecycle stage changed to Lead. This is automatically set by HubSpot for each contact.
Became a Marketing Qualified Lead Date Datetime True No The date when a contact's lifecycle stage changed to MQL. This is automatically set by HubSpot for each contact.
Became an Opportunity Date Datetime True No The date when a contact's lifecycle stage changed to Opportunity. This is automatically set by HubSpot for each contact.
Lifecycle Stage String False No The qualification of contacts to sales readiness. It can be set through imports* forms* workflows_ and manually on a per contact basis.
Became a Sales Qualified Lead Date Datetime True No The date when a contact's lifecycle stage changed to SQL. This is automatically set by HubSpot for each contact.
Create Date Datetime True No The date that a contact entered the system.
Became an Evangelist Date Datetime True No The date when a contact's lifecycle stage changed to Evangelist. This is automatically set by HubSpot for each contact.
Became a Customer Date Datetime True No The date when a contact's lifecycle stage changed to Customer. This is automatically set by HubSpot for each contact.
HubSpot Score Decimal True No The number that shows qualification of contacts to sales readiness. It can be set in HubSpot's Lead Scoring app.
Company Name String False No Name of the contact's company. This can be set independently from the name property on the contact's associated company.
Became a Subscriber Date Datetime True No The date when a contact's lifecycle stage changed to Subscriber. This is automatically set by HubSpot for each contact.
Became an Other Lifecycle Date Datetime True No The date when a contact's lifecycle stage changed to Other. This is automatically set by HubSpot for each contact.
Website URL String False No Associated company website.
Number of Employees String False No The number of company employees.
Annual Revenue String False No Annual company revenue.
Industry String False No The Industry a contact is in.
Primary Associated Company ID Decimal False No HubSpot defined ID of a contact's primary associated company in HubSpot.
Associated Company Last Updated Decimal True No This field is meaningless on its own_ and is solely used for triggering dynamic list updates when a company is updated.
Lead Rating String True No The rating of this contact based on their predictive lead score.
Predictive Lead Score Decimal True No A score calculated by HubSpot that represents a contact's likelihood to become a customer.

Return to Top

ContactsToDealsAssociations

Name Type ReadOnly References FilterOnly Description
ContactsId [KEY] Long False Contacts.Id No Contacts ID
DealsId [KEY] Long False Deals.Id No Deals ID
TypeId [KEY] String False AssociationsLabels.TypeId No The numeric ID for the association type. This column is empty for more general associations queries.
Category [KEY] String False AssociationsLabels.Category No The category of the association type for the specified object pair. This column is empty for more generic associations queries.
TypeLabel String True AssociationsLabels.Label No The label assigned to the association type between objects.

Return to Top

DealAssociations

Name Type ReadOnly References FilterOnly Description
Id [KEY] Long False Deals.Id No Deals ID.
AssociationId [KEY] Long False No ID of the object that this Deal object is associated with.
Type [KEY] String False No Type of the associated object* which can be a contact* deal etc.
TypeId [KEY] String False AssociationsLabels.TypeId No The numeric ID for the association type. This column is empty for more general associations queries.
Category [KEY] String False AssociationsLabels.Category No The category of the association type for the specified object pair. This column is empty for more generic associations queries.
TypeLabel String True AssociationsLabels.Label No The label assigned to the association type between objects.

Return to Top

DealPropertiesHistory

Name Type ReadOnly References FilterOnly Description
PropertyName String True No The name of the property.
Value String True No The historical value of the property.
SourceType String True No The method by which the property was changed.
SourceId String True No Additional data related to the source. May not be populated for all sources.
Timestamp Datetime True No Datetime when the property was updated.
DealId Long True No The deal identifier.

Return to Top

Deals

Name Type ReadOnly References FilterOnly Description
Id [KEY] Long False No Unique identifier of the object.
Archived Bool True No Whether the object is archived or not.
CreatedAt Datetime True No When the object was created.
UpdatedAt Datetime True No When the object was last updated.
ItemURL String True No Url that points directly to the HubSpot item.
Amount in company currency Decimal True No The amount of the deal* using the exchange rate* in your company's currency.
Days to close Decimal True No The number of days the deal took to close.
Currency String False No Currency code for the deal.
Annual contract value Decimal True No The annual contract value ACV of this deal.
Business units String False No The business units this record is assigned to.
Deal Collaborator String True No Owner ids of the users involved in closing the deal.
Deal Split Users String True No The owner ids of all associated Deal Splits. This property is set automatically by HubSpot.
Latest Source String True No Source for the contact either directly or indirectly associated with the last session activity for this deal.
Latest Source Company String True No Source for the company with an associated contact with the last session activity for this deal.
Latest Source Contact String True No Source for the directly associated contact with the last session activity for this deal.
Latest Source Data 1 String True No Additional source details of the last session attributed to any contacts that are directly or indirectly associated with this deal.
Latest Source Data 1 Company String True No Additional source details of the last session attributed to any contacts that are indirectly associated with this deal via a company association.
Latest Source Data 1 Contact String True No Additional source details of the last session attributed to any contacts that are directly associated with this deal.
Latest Source Data 2 String True No Additional source details of the last session attributed to any contacts that are directly or indirectly associated with this deal.
Latest Source Data 2 Company String True No Additional source details of the last session attributed to any contacts that are indirectly associated with this deal.
Latest Source Data 2 Contact String True No Additional source details of the last session attributed to any contacts that are directly associated with this deal.
Latest Source Timestamp Datetime True No Timestamp of when latest source occurred for either a directly or indirectly associated contact.
Latest Source Timestamp Company Datetime True No Timestamp of when latest source occurred for an indirectly associated contact.
Latest Source Timestamp Contact Datetime True No Timestamp of when latest source occurred for a directly associated contact.
Original Source Type String False No Original source for the contact with the earliest activity for this deal.
Original Source Data 1 String True No Additional information about the original source for the associated contact* or associated company if there is no contact* with the oldest value for the Time first seen property.
Original Source Data 2 String True No Additional information about the original source for the associated contact* or associated company if there is no contact* with the oldest value for the Time first seen property.
Annual recurring revenue Decimal True No The annual recurring revenue ARR of this deal.
HubSpot Campaign String False No The marketing campaign the deal is associated with.
Closed Deal Amount Decimal True No Returns the amount if the deal is closed. Else_ returns 0.
Closed Deal Amount In Home Currency Decimal True No Returns the amount in home currency if the deal is closed. Else_ returns 0.
Created by user ID Decimal True No The user that created this object. This value is automatically set by HubSpot and may not be modified.
Date entered 'Appointment Scheduled Sales Pipeline' Datetime True No The date and time when the deal entered the 'Appointment Scheduled' stage_ 'Sales Pipeline' pipeline.
Date entered 'Closed Lost Sales Pipeline' Datetime True No The date and time when the deal entered the 'Closed Lost' stage_ 'Sales Pipeline' pipeline.
Date entered 'Closed Won Sales Pipeline' Datetime True No The date and time when the deal entered the 'Closed Won' stage_ 'Sales Pipeline' pipeline.
Date entered 'Contract Sent Sales Pipeline' Datetime True No The date and time when the deal entered the 'Contract Sent' stage_ 'Sales Pipeline' pipeline.
Date entered 'Decision Maker BoughtIn Sales Pipeline' Datetime True No The date and time when the deal entered the 'Decision Maker BoughtIn' stage 'Sales Pipeline' pipeline.
Date entered 'Presentation Scheduled Sales Pipeline' Datetime True No The date and time when the deal entered the 'Presentation Scheduled' stage_ 'Sales Pipeline' pipeline.
Date entered 'Qualified To Buy Sales Pipeline' Datetime True No The date and time when the deal entered the 'Qualified To Buy' stage_ 'Sales Pipeline' pipeline.
Date exited 'Appointment Scheduled Sales Pipeline' Datetime True No The date and time when the deal exited the 'Appointment Scheduled' stage_ 'Sales Pipeline' pipeline.
Date exited 'Closed Lost Sales Pipeline' Datetime True No The date and time when the deal exited the 'Closed Lost' stage_ 'Sales Pipeline' pipeline.
Date exited 'Closed Won Sales Pipeline' Datetime True No The date and time when the deal exited the 'Closed Won' stage_ 'Sales Pipeline' pipeline.
Date exited 'Contract Sent Sales Pipeline' Datetime True No The date and time when the deal exited the 'Contract Sent' stage_ 'Sales Pipeline' pipeline.
Date exited 'Decision Maker BoughtIn Sales Pipeline' Datetime True No The date and time when the deal exited the 'Decision Maker BoughtIn' stage 'Sales Pipeline' pipeline.
Date exited 'Presentation Scheduled Sales Pipeline' Datetime True No The date and time when the deal exited the 'Presentation Scheduled' stage_ 'Sales Pipeline' pipeline.
Date exited 'Qualified To Buy Sales Pipeline' Datetime True No The date and time when the deal exited the 'Qualified To Buy' stage_ 'Sales Pipeline' pipeline.
Deal amount calculation preference String False No Specifies how deal amount should be calculated from line items.
Deal probability Decimal False No The probability a deal will close. This defaults to the deal stage probability setting.
Deal stage probability shadow Decimal True No Fall back property for calculating the deal stage when no customer override exist. Probability between 0 and 1 of deal stage. Defaults to 0 for unknown deal stages.
Exchange rate Decimal True No This is the exchange rate used to convert the deal amount into your company currency.
Forecast amount Decimal True No The custom forecasted deal value calculated by multiplying the forecast probability and deal amount in your company_s currency.
Forecast probability Decimal False No The custom percent probability a deal will close.
Is Deal Closed_ Bool True No True if the deal was won or lost.
Is Closed Won Bool True No True if the deal is in the closed won state_ false otherwise.
Deal Split Added Bool True No Indicates if the deal is split between multiple users.
Last Modified Date Datetime True No Most recent timestamp of any property update for this deal. This includes HubSpot internal properties_ which can be visible or hidden. This property is updated automatically.
Likelihood to close by the close date Decimal True No Hubspot predicted likelihood between 0 and 1 of the deal to close by the close date.
Global Term Line Item Discount Percentage String False No For internal HubSpot Application use only. Global term for the discount percentage applied.
Global Term Line Item Discount Percentage Enabled Bool False No For internal HubSpot Application use only. Indicates if the Global term for the discount percentage is enabled.
Global Term Line Item Recurring Billing Period String False No For internal HubSpot Application use only. Global term for product recurring billing duration.
Global Term Line Item Recurring Billing Period Enabled Bool False No For internal HubSpot Application use only. Indicates if the Global term for product recurring billing duration is enabled.
Global Term Line Item Recurring Billing Start Date String False No For internal HubSpot Application use only. Global term for recurring billing start date for a line item.
Global Term Line Item Recurring Billing Start Date Enabled Bool False No For internal HubSpot Application use only. Indicates if the Global term for recurring billing start date for a line item is enabled.
Global Term Line Item Recurring Billing Frequency String False No For internal HubSpot Application use only. Global term for how frequently the product is billed.
Global Term Line Item Recurring Billing Frequency Enabled Bool False No For internal HubSpot Application use only. Indicates if the Global term for how frequently the product is billed is enabled.
Forecast category String False No The likelihood a deal will close. This property is used for manual forecasting your deals.
Merged object IDs String True No The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.
Monthly recurring revenue Decimal True No The monthly recurring revenue MRR of this deal.
Next step String False No A short description of the next step for the deal.
Number of Active Deal Registrations Decimal True No The number of active deal registrations associated with this deal. This property is set automatically by HubSpot.
Number of Deal Registrations Decimal True No The number of deal registrations associated with this deal. This property is set automatically by HubSpot.
Number of Deal Splits Decimal True No The number of deal splits associated with this deal. This property is set automatically by HubSpot.
Number of target accounts Decimal True No The number of target account companies associated with this deal. This property is set automatically by HubSpot.
Record ID Decimal True No The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
Pinned Engagement ID Decimal True No The object ID of the current pinned engagement. This value is automatically set by HubSpot and may not be modified.
The predicted deal amount Decimal True No Returns the multiplication of the deal amount times the predicted likelihood of the deal to close by the close date.
The predicted deal amount in your company's currency Decimal True No Returns the multiplication of the deal amount in your company's currency times the predicted likelihood of the deal to close by the close date.
Priority String False No
Weighted amount Decimal True No Returns the multiplication of the amount times the probability of the deal closing.
Weighted amount in company currency Decimal True No Returns the multiplication of the amount in home currency times the probability of the deal closing.
Read Only Object Bool True No Is the object read only.
Total contract value Decimal True No The total contract value TCV of this deal.
Time in 'Appointment Scheduled Sales Pipeline' Decimal True No The total time in seconds spent by the deal in the 'Appointment Scheduled' stage_ 'Sales Pipeline' pipeline.
Time in 'Closed Lost Sales Pipeline' Decimal True No The total time in seconds spent by the deal in the 'Closed Lost' stage_ 'Sales Pipeline' pipeline.
Time in 'Closed Won Sales Pipeline' Decimal True No The total time in seconds spent by the deal in the 'Closed Won' stage_ 'Sales Pipeline' pipeline.
Time in 'Contract Sent Sales Pipeline' Decimal True No The total time in seconds spent by the deal in the 'Contract Sent' stage_ 'Sales Pipeline' pipeline.
Time in 'Decision Maker BoughtIn Sales Pipeline' Decimal True No The total time in seconds spent by the deal in the 'Decision Maker BoughtIn' stage 'Sales Pipeline' pipeline.
Time in 'Presentation Scheduled Sales Pipeline' Decimal True No The total time in seconds spent by the deal in the 'Presentation Scheduled' stage_ 'Sales Pipeline' pipeline.
Time in 'Qualified To Buy Sales Pipeline' Decimal True No The total time in seconds spent by the deal in the 'Qualified To Buy' stage_ 'Sales Pipeline' pipeline.
Unique creation key String True No Unique property used for idempotent creates.
Updated by user ID Decimal True No The user that last updated this object. This value is automatically set by HubSpot and may not be modified.
User IDs of all notification followers String True No The user IDs of all users that have clicked follow within the object to opt_in to getting follow notifications.
User IDs of all notification unfollowers String True No The user IDs of all object owners that have clicked unfollow within the object to opt_out of getting follow notifications.
User IDs of all owners String True No The user IDs of all owners of this object.
Owner Assigned Date Datetime True No The date the most recent deal owner was assigned to a deal. This is updated automatically by HubSpot.
Deal Name String False No The name given to this deal.
Amount Decimal False No The total amount of the deal.
Deal Stage String False No The stage of the deal. Deal stages allow you to categorize and track the progress of the deals that you are working on.
Pipeline String False No The pipeline the deal is in. This determines which stages are options for the deal.
Close Date Datetime False No Date the deal was closed. This property is set automatically by HubSpot.
Create Date Datetime False No Date the deal was created. This property is set automatically by HubSpot.
Date of last meeting booked in meetings tool Datetime True No The date of the most recent meeting an associated contact has booked through the meetings tool.
Campaign of last booking in meetings tool String True No This UTM parameter shows which marketing campaign e.g. a specific email referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.
Medium of last booking in meetings tool String True No This UTM parameter shows which channel e.g. email referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.
Source of last booking in meetings tool String True No This UTM parameter shows which site e.g. Twitter referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.
Latest meeting activity Datetime True No The date of the most recent meeting past or upcoming logged for* scheduled with* or booked by a contact associated with this deal.
Recent Sales Email Replied Date Datetime True No The last time a tracked sales email was replied to for this deal.
Deal owner String False No User the deal is assigned to. Assign additional users to a deal record by creating a custom user property.
Last Contacted Datetime True No The last time a call* sales email* or meeting was logged for this deal. This is set automatically by HubSpot based on user actions.
Last Activity Date Datetime True No The last time a note* call* email* meeting* or task was logged for a deal. This is updated automatically by HubSpot.
Next Activity Date Datetime True No The date of the next upcoming activity for a deal. This property is set automatically by HubSpot based on user action. This includes logging a future call* sales email* or meeting using the Log feature_ as well as creating a future task or scheduling a future meeting. This is updated automatically by HubSpot.
Number of times contacted Decimal True No The total number of sales activities notes calls* emails* meetings* or tasks* logged for a deal. This is updated automatically by HubSpot.
Number of Sales Activities Decimal True No The total number of times a sales email or call has been logged for a deal. This is updated automatically by HubSpot.
HubSpot Create Date Datetime True No The date the deal was created. This property is set automatically by HubSpot.
HubSpot Team String True No Primary team of the deal owner. This property is set automatically by HubSpot.
Deal Type String False No The type of deal. By default_ categorize your deal as either a New Business or Existing Business.
All owner ids String True No The value of all owner referencing properties for this object_ both default and custom.
Deal Description String False No Description of the deal.
All team ids String True No The team ids corresponding to all owner referencing properties for this object_ both default and custom.
All accessible team ids String True No The team ids* including up the team hierarchy* corresponding to all owner referencing properties for this object_ both default and custom.
Number of Associated Contacts Decimal True No The number of contacts associated with this deal. This property is set automatically by HubSpot.
Closed Lost Reason String False No Reason why this deal was lost.
Closed Won Reason String False No Reason why this deal was won.

Return to Top

EngagementsCalls

Name Type ReadOnly References FilterOnly Description
Id [KEY] Long False No Unique identifier of the object.
Archived Bool True No Whether the object is archived or not.
CreatedAt Datetime True No When the object was created.
UpdatedAt Datetime True No When the object was last updated.
Call and meeting type String False No The activity type of the engagement.
Business units String False No The business units this record is assigned to.
AtMentioned Owner Ids String False No The owners that have been at_mentioned on the engagement.
Attached file IDs String False No The IDs of the files that are attached to the engagement.
Call notes preview String True No A truncated preview of the call notes.
HTML Body Preview String True No The HTML representation of the engagement body preview.
Body Preview Truncated Bool True No Indicates if the engagement body was truncated for the preview.
Integrating App ID Decimal False No The App ID associated with the integrating app.
Authenticated recording files url provider String True No URL which returns Authenticated audio_video URL of the recording.
Call notes String False No The body of the call.
Callee object id Decimal False No The id of the callee.
Callee object type String False No The type of callee.
Call direction String False No The direction of a call.
Call outcome String False No The outcome of the call.
Call duration Decimal False No The duration of the call_ in milliseconds.
External Account ID String False No External Account ID.
External ID String False No The external ID of the call.
From Number String False No The phone number of the person that initiated the call.
From Number Name String True No The name of the phone number that initiated the call.
Transcript Available Bool False No Flag to indicate if the call has an associated transcript.
Voicemail Available String True No Flag to indicate if the call has an associated voicemail.
Recording URL String False No The URL of the recorded call audio.
Call Source String False No The source of the call to differentiate VoIP vs Video Conferencing Apps.
Call status String False No The status of the call.
Call Title String False No The title of the call.
To Number String False No The phone number of the person that was called.
To Number Name String True No The name of the phone number that was called.
Tracked terms String True No A list of any tracked terms contained in the call transcript.
Call transcription id Decimal False No The id of the transcription.
Video url String False No Video URL of the recording.
Unique Zoom Meeting ID String False No The Zoom meeting unique identifier of the call.
Calls Service Call ID Decimal True No The Calls Service specific global unique identifier for a call.
Activity created by Decimal True No The user who created the engagement.
Created by user ID Decimal True No The user that created this object. This value is automatically set by HubSpot and may not be modified.
Create date Datetime True No The date that an engagement was created.
Engagement Source String False No The source that created this engagement.
Engagement Source ID String False No The specific ID of the process that created this engagement.
Follow up action String False No What action should be performed during follow up.
GDPR deleted Bool True No Indicates the body of this engagement has been cleared because of a GDPR delete request.
Last modified date Datetime True No The date any property on this engagement was modified.
Merged object IDs String True No The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.
Updated by Decimal True No The user who last updated the engagement.
Record ID Decimal True No The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
Product name String False No The name of the product associated with this engagement.
Queue Memberships String False No The list of queues that contain this engagement.
Read Only Object Bool True No Is the object read only.
Activity date Datetime False No The date that an engagement occurred.
Unique creation key String True No Unique property used for idempotent creates.
Unique ID String False No The unique ID of the engagement.
Unknown Visitor Conversation Bool False No Whether or not this communication was made with an unknown visitor.
Updated by user ID Decimal True No The user that last updated this object. This value is automatically set by HubSpot and may not be modified.
User IDs of all notification followers String True No The user IDs of all users that have clicked follow within the object to opt_in to getting follow notifications.
User IDs of all notification unfollowers String True No The user IDs of all object owners that have clicked unfollow within the object to opt_out of getting follow notifications.
User IDs of all owners String True No The user IDs of all owners of this object.
Owner Assigned Date Datetime True No The timestamp when an owner was assigned to this engagement.
Activity assigned to String False No The user that the activity is assigned to in HubSpot. This can be any HubSpot user or Salesforce integration user_ and can be set manually or via Workflows.
HubSpot Team String True No The team of the owner of an engagement.
All owner ids String True No The value of all owner referencing properties for this object_ both default and custom.
All team ids String True No The team ids corresponding to all owner referencing properties for this object_ both default and custom.
All accessible team ids String True No The team ids* including up the team hierarchy* corresponding to all owner referencing properties for this object_ both default and custom.

Return to Top

EngagementsEmails

Name Type ReadOnly References FilterOnly Description
Id [KEY] Long False No Unique identifier of the object.
Archived Bool True No Whether the object is archived or not.
CreatedAt Datetime True No When the object was created.
UpdatedAt Datetime True No When the object was last updated.
Business units String False No The business units this record is assigned to.
AtMentioned Owner Ids String False No The owners that have been at_mentioned on the engagement.
Attached file IDs String False No The IDs of the files that are attached to the engagement.
Body preview String True No A truncated preview of the engagement body.
HTML Body Preview String True No The HTML representation of the engagement body preview.
Body Preview Truncated Bool True No Indicates if the engagement body was truncated for the preview.
Activity created by String True No The user who created the engagement.
Created by user ID Decimal True No The user that created this object. This value is automatically set by HubSpot and may not be modified.
Create date Datetime True No The date that an engagement was created.
Email direction and unique ID String True No The direction and unique ID of the email.
Attached Video String False No The ID of a video optionally attached to an email.
Attached Video Name String False No The name of a video optionally attached to an email.
Attached Video Opened Bool False No Has the video attachment been opened.
Attached Video Watched Bool False No Has the video attachement been watched.
Email BCC Address String True No Email addresses of the email's BCC recipients.
Email BCC First Name String True No First names of the email's BCC recipients.
Email BCC Last Name String True No Last names of the email's BCC recipients.
Email BCC String True No Raw header values of the email's BCC recipients.
Email Bounce Error Detail Message String False No The message from the bounce error.
Email Bounce Error Detail Status Code Decimal False No The status code from the bounce error.
Email CC Address String True No Email addresses of the email's CC recipients.
Email CC First Name String True No First names of the email's CC recipients.
Email CC Last Name String True No Last names of the email's CC recipients.
Email CC String True No Raw header values of the email's CC recipients.
Email Direction String False No The direction the email was sent in.
Encoded Email Associations Request String True No Encoded email associations request.
Error Message String False No The error that occurred while sending the email.
Email Send Id String True No The ID of the email send event sent through Facsimile.
Email From Address String True No Email address of the email's sender.
Email From First Name String True No First name of the email's sender.
Email From Last Name String True No Last name of the email's sender.
Email From String True No Raw header value of the email's sender.
Email Headers String False No The sender and receivers of the email.
Email body String False No This is the body of any email sent from a record. It doesn't include emails received from contacts.
Logged From String False No Where the email was logged.
Media Processing Status String False No Processing status for this email's images and attachments.
Email is member of forwarded subthread Bool False No Whether this email is a member of a forwarded subthread.
Message ID String False No The ID of the message.
EmailMigratedViaPortalDataMigration String False No Indicates that the email was migrated from another portal using DataMigration tool.
Email pending inline image file IDs String False No File IDs of pending inline images in the email's HTML.
PostSend Status String False No A description of what happened to the email successful send bounced* dropped* and why.
RecipientDrop Reasons String False No A list of the dropped recipients paired with the reason each was dropped.
Email Send Event Id String False No The ID of the email send event.
Email Send Event Id Created Datetime False No The date when the email send event ID was created.
Email Sender Address String True No Email address of the email's sender.
Email Sender First Name String True No First name of the email's sender.
Email Sender Last Name String True No Last name of the email's sender.
Email Sender String True No Raw header value of the email's sender.
Sent Via String False No How the email was sent.
Email send status String False No The send status of the email.
Email subject String False No The subject of the email.
Text String False No The plaintext of the email.
Thread ID String False No The thread that the email belongs to.
Email To Address String True No Email addresses of the email's recipients.
Email To First Name String True No First names of the email's recipients.
Email To Last Name String True No Last names of the email's recipients.
Email To String True No Raw header values of the email's recipients.
Tracker Key String False No The tracker key of the email.
Validation Skipped String False No Validation skipped that would have otherwise rejected logging.
Engagement Source String False No The source that created this engagement.
Engagement Source ID String False No The specific ID of the process that created this engagement.
Follow up action String False No What action should be performed during follow up.
GDPR deleted Bool True No Indicates the body of this engagement has been cleared because of a GDPR delete request.
Last modified date Datetime True No The date any property on this engagement was modified.
Merged object IDs String True No The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.
Updated by String True No The user who last updated the engagement.
Record ID Decimal True No The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
Product name String False No The name of the product associated with this engagement.
Queue Memberships String False No The list of queues that contain this engagement.
Read Only Object Bool True No Is the object read only.
Activity date Datetime False No The date that an engagement occurred.
Unique creation key String True No Unique property used for idempotent creates.
Unique ID String False No The unique ID of the engagement.
Updated by user ID Decimal True No The user that last updated this object. This value is automatically set by HubSpot and may not be modified.
User IDs of all notification followers String True No The user IDs of all users that have clicked follow within the object to opt_in to getting follow notifications.
User IDs of all notification unfollowers String True No The user IDs of all object owners that have clicked unfollow within the object to opt_out of getting follow notifications.
User IDs of all owners String True No The user IDs of all owners of this object.
Owner Assigned Date Datetime True No The timestamp when an owner was assigned to this engagement.
Activity assigned to String False No The user that the activity is assigned to in HubSpot. This can be any HubSpot user or Salesforce integration user_ and can be set manually or via Workflows.
HubSpot Team String True No The team of the owner of an engagement.
All owner ids String True No The value of all owner referencing properties for this object_ both default and custom.
All team ids String True No The team ids corresponding to all owner referencing properties for this object_ both default and custom.
All accessible team ids String True No The team ids* including up the team hierarchy* corresponding to all owner referencing properties for this object_ both default and custom.

Return to Top

EngagementsMeetings

Name Type ReadOnly References FilterOnly Description
Id [KEY] Long False No Unique identifier of the object.
Archived Bool True No Whether the object is archived or not.
CreatedAt Datetime True No When the object was created.
UpdatedAt Datetime True No When the object was last updated.
Call and meeting type String False No The activity type of the engagement.
Business units String False No The business units this record is assigned to.
AtMentioned Owner Ids String False No The owners that have been at_mentioned on the engagement.
Attached file IDs String False No The IDs of the files that are attached to the engagement.
HubSpot attendee owner IDs String False No List of HubSpot owner IDs for additional attendees.
Body preview String True No A truncated preview of the engagegement body.
HTML Body Preview String True No The HTML representation of the engagement body preview.
Body Preview Truncated Bool True No Indicates if the engagement body was truncated for the preview.
Activity created by Decimal True No The user who created the engagement.
Created by user ID Decimal True No The user that created this object. This value is automatically set by HubSpot and may not be modified.
Create date Datetime True No The date that an engagement was created.
Engagement Source String False No The source that created this engagement.
Engagement Source ID String False No The specific ID of the process that created this engagement.
Follow up action String False No What action should be performed during follow up.
GDPR deleted Bool True No Indicates the body of this engagement has been cleared because of a GDPR delete request.
iCalUid String True No The iCalUid of the synced event.
Internal Meeting Notes String False No
Last modified date Datetime True No The date any property on this engagement was modified.
Meeting description String False No The text description of the meeting.
Meeting calendar event hash String False No The unique hash for the meeting.
Meeting change id String False No The unique change id for the meeting.
Created From Link ID String False No Created From Link ID.
Meeting end time Datetime False No The date when the meeting ends.
External URL String False No The external URL for the meeting.
Meeting location String False No Where the meeting takes place.
Location type String False No The type of location for the meeting event.
Meeting outcome String False No The outcome of this meeting.
Payments session id String False No The payments session id for the meeting.
PreMeeting prospect reminders String False No A list of dates when meeting reminders should be sent to prospects.
Meeting source String True No The source where the meeting was booked.
Source ID String False No The source ID of the meeting.
Meeting start time Datetime False No The date when the meeting starts.
Meeting name String False No The title of the meeting.
Web conference meeting ID String False No The meeting ID of the web conference.
Merged object IDs String True No The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.
Updated by Decimal True No The user who last updated the engagement.
Record ID Decimal True No The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
Product name String False No The name of the product associated with this engagement.
Queue Memberships String False No The list of queues that contain this engagement.
Read Only Object Bool True No Is the object read only.
Scheduled tasks String True No
Activity date Datetime False No The date that an engagement occurred.
Unique creation key String True No Unique property used for idempotent creates.
Unique ID String False No The unique ID of the engagement.
Updated by user ID Decimal True No The user that last updated this object. This value is automatically set by HubSpot and may not be modified.
User IDs of all notification followers String True No The user IDs of all users that have clicked follow within the object to opt_in to getting follow notifications.
User IDs of all notification unfollowers String True No The user IDs of all object owners that have clicked unfollow within the object to opt_out of getting follow notifications.
User IDs of all owners String True No The user IDs of all owners of this object.
Owner Assigned Date Datetime True No The timestamp when an owner was assigned to this engagement.
Activity assigned to String False No The user that the activity is assigned to in HubSpot. This can be any HubSpot user or Salesforce integration user_ and can be set manually or via Workflows.
HubSpot Team String True No The team of the owner of an engagement.
All owner ids String True No The value of all owner referencing properties for this object_ both default and custom.
All team ids String True No The team ids corresponding to all owner referencing properties for this object_ both default and custom.
All accessible team ids String True No The team ids* including up the team hierarchy* corresponding to all owner referencing properties for this object_ both default and custom.

Return to Top

EngagementsNotes

Name Type ReadOnly References FilterOnly Description
Id [KEY] Long False No Unique identifier of the object.
Archived Bool True No Whether the object is archived or not.
CreatedAt Datetime True No When the object was created.
UpdatedAt Datetime True No When the object was last updated.
Business units String False No The business units this record is assigned to.
AtMentioned Owner Ids String False No The owners that have been at_mentioned on the engagement.
Attached file IDs String False No The IDs of the files that are attached to the engagement.
Body preview String True No A truncated preview of the engagegement body.
HTML Body Preview String True No The HTML representation of the engagement body preview.
Body Preview Truncated Bool True No Indicates if the engagement body was truncated for the preview.
Activity created by Decimal True No The user who created the engagement.
Created by user ID Decimal True No The user that created this object. This value is automatically set by HubSpot and may not be modified.
Create date Datetime True No The date that an engagement was created.
Engagement Source String False No The source that created this engagement.
Engagement Source ID String False No The specific ID of the process that created this engagement.
Follow up action String False No What action should be performed during follow up.
GDPR deleted Bool True No Indicates the body of this engagement has been cleared because of a GDPR delete request.
Last modified date Datetime True No The date any property on this engagement was modified.
Merged object IDs String True No The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.
Updated by Decimal True No The user who last updated the engagement.
Note body String False No The body of the note.
Record ID Decimal True No The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
Product name String False No The name of the product associated with this engagement.
Queue Memberships String False No The list of queues that contain this engagement.
Read Only Object Bool True No Is the object read only.
Activity date Datetime False No The date that an engagement occurred.
Unique creation key String True No Unique property used for idempotent creates.
Unique ID String False No The unique ID of the engagement.
Updated by user ID Decimal True No The user that last updated this object. This value is automatically set by HubSpot and may not be modified.
User IDs of all notification followers String True No The user IDs of all users that have clicked follow within the object to opt_in to getting follow notifications.
User IDs of all notification unfollowers String True No The user IDs of all object owners that have clicked unfollow within the object to opt_out of getting follow notifications.
User IDs of all owners String True No The user IDs of all owners of this object.
Owner Assigned Date Datetime True No The timestamp when an owner was assigned to this engagement.
Activity assigned to String False No The user that the activity is assigned to in HubSpot. This can be any HubSpot user or Salesforce integration user_ and can be set manually or via Workflows.
HubSpot Team String True No The team of the owner of an engagement.
All owner ids String True No The value of all owner referencing properties for this object_ both default and custom.
All team ids String True No The team ids corresponding to all owner referencing properties for this object_ both default and custom.
All accessible team ids String True No The team ids* including up the team hierarchy* corresponding to all owner referencing properties for this object_ both default and custom.

Return to Top

EngagementsTasks

Name Type ReadOnly References FilterOnly Description
Id [KEY] Long False No Unique identifier of the object.
Archived Bool True No Whether the object is archived or not.
CreatedAt Datetime True No When the object was created.
UpdatedAt Datetime True No When the object was last updated.
Business units String False No The business units this record is assigned to.
AtMentioned Owner Ids String False No The owners that have been at_mentioned on the engagement.
Attached file IDs String False No The IDs of the files that are attached to the engagement.
Notes preview String True No A plain_text preview of the notes field on a task.
HTML Body Preview String True No The HTML representation of the engagement body preview.
Body Preview Truncated Bool True No Indicates if the engagement body was truncated for the preview.
Calendar Event ID String True No The event ID for the synced task.
Created by Decimal True No The user who created the engagement.
Created by user ID Decimal True No The user that created this object. This value is automatically set by HubSpot and may not be modified.
Created at Datetime True No The date that an engagement was created.
Source String False No The source that created this engagement.
Source ID String False No The specific ID of the process that created this engagement.
Follow up action String False No What action should be performed during follow up.
GDPR deleted Bool True No Indicates the body of this engagement has been cleared because of a GDPR delete request.
Last modified at Datetime True No The date any property on this engagement was modified.
Merged object IDs String True No The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.
Last modified by Decimal True No The user who last updated the engagement.
MS Teams message ID String True No The message ID for the created task.
Associated Companies Decimal True No The number of companies associated with this task.
Associated Contacts Decimal True No The number of contacts associated with this task.
Associated Deals Decimal True No The number of deals associated with this task.
Associated Queue Objects Decimal True No The number of objects associated with this task that support task queues.
Associated Tickets Decimal True No The number of tickets associated with this task.
Record ID Decimal True No The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
Product name String False No The name of the product associated with this engagement.
Queue String False No The list of queues that contain this engagement.
Read Only Object Bool True No Is the object read only.
Task repeat status String True No Indicates whether the task is currently repeating .
Scheduled tasks String True No
Notes String False No The content in the notes field on a task.
Completed at Datetime True No The date that the task was completed.
Contact Time Zone String True No The time zone of the associated contact.
For Object Type String False No The object type for the task.
Task is all day Bool False No Determines if the task is due all day or at a specific time.
Last contacted Datetime True No The last time a call* email* or meeting was logged for the associated contact. This is set automatically by HubSpot based on user actions in the contact record.
Last engagement Datetime True No The date of the last sales activity with the associated contact. This is set automatically by HubSpot based on user actions in the contact record.
Priority String False No The priority of the task.
Task probability to complete Decimal True No The probability the task will be completed.
Relative Task Reminders String False No The dates relative to the due date when reminders will be sent.
Reminder String False No The dates when reminders will be sent.
Interval String True No How often the task should repeat.
Send Default Reminder Bool False No Whether or not a reminder should be sent when the task is due.
Sequence Enrollment Is Active Bool True No Whether the sequence enrollment this task is a part of is currently active.
Sequence step enrollment Id String True No The id of the sequence step that created the task.
Sequence step number Decimal True No The order of this task in the sequence at time of enrollment.
Task Status String False No The status of the task.
Task Title String False No The subject text for the task.
Task template id Decimal True No The id of template the task was created from.
Task Type String False No The type of task.
Due date Datetime False No The date that an engagement occurred.
Unique creation key String True No Unique property used for idempotent creates.
Unique ID String False No The unique ID of the engagement.
Updated by user ID Decimal True No The user that last updated this object. This value is automatically set by HubSpot and may not be modified.
User IDs of all notification followers String True No The user IDs of all users that have clicked follow within the object to opt_in to getting follow notifications.
User IDs of all notification unfollowers String True No The user IDs of all object owners that have clicked unfollow within the object to opt_out of getting follow notifications.
User IDs of all owners String True No The user IDs of all owners of this object.
Owner Assigned Date Datetime True No The timestamp when an owner was assigned to this engagement.
Assigned to String False No The user that the activity is assigned to in HubSpot. This can be any HubSpot user or Salesforce integration user_ and can be set manually or via Workflows.
HubSpot Team String True No The team of the owner of an engagement.
All owner ids String True No The value of all owner referencing properties for this object_ both default and custom.
All team ids String True No The team ids corresponding to all owner referencing properties for this object_ both default and custom.
All accessible team ids String True No The team ids* including up the team hierarchy* corresponding to all owner referencing properties for this object_ both default and custom.

Return to Top

FeedbackSubmissionAssociations

Name Type ReadOnly References FilterOnly Description
Id [KEY] Long False Deals.Id No Deals ID.
AssociationId [KEY] Long False No ID of the object that this Deals object is associated with.
Type [KEY] String False No Type of the associated object* which can be a contact* deal etc.
TypeId [KEY] String False AssociationsLabels.Id No The numeric ID for the association type. This column is empty for more general associations queries.
Category [KEY] String False AssociationsLabels.Type No The category of the association type for the specified object pair. This column is empty for more generic associations queries.

Return to Top

FeedbackSubmissions

Name Type ReadOnly References FilterOnly Description
Id [KEY] Long False No Unique identifier of the object.
Archived Bool True No Whether the object is archived or not.
CreatedAt Datetime True No When the object was created.
UpdatedAt Datetime True No When the object was last updated.
Agent email String True No Conversation agent's email.
Agent responsible for the conversation Decimal True No Agent responsible for the conversation which led to the feedback.
Agent name String True No Conversation agent's full name.
All accessible team IDs String True No The team IDs* including up the team hierarchy* corresponding to all owner referencing properties for this object_ both default and custom.
Business units String False No The business units this record is assigned to.
All owner ids String True No The value of all owner referencing properties for this object_ both default and custom.
All team ids String True No The team ids corresponding to all owner referencing properties for this object_ both default and custom.
Chatflow ID Decimal True No Chatflow ID of the conversation associated to the submission.
Chatflow name String True No The name of the chatflow associated to the submission.
Chatflow object id Decimal True No Chatflow object id of the conversation associated to the submission.
Contact first name String True No First name of the contact associated with the submission.
Contact Id Decimal True No The id of the contact most recently associated with this submission.
Contact last name String True No Last name of the contact associated with the submission.
Conversation thread id Decimal True No Thread id of the conversation associated to the submission.
Created by user ID Decimal True No The user that created this object. This value is automatically set by HubSpot and may not be modified.
Object create date_time Datetime True No The date and time at which this object was created. This value is automatically set by HubSpot and may not be modified.
Object last modified date_time Datetime True No Most recent timestamp of any property update for this object. This includes HubSpot internal properties_ which can be visible or hidden. This property is updated automatically.
Merged object IDs String True No The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.
Record ID Decimal True No The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
Read Only Object Bool True No Is the object read only.
Tag IDs String True No Tag IDs assigned to this submission.
Tags String True No Tags assigned to this submission.
Ticket id Decimal True No ID of the ticket associated with the submission.
Ticket owner avatar uri String True No Avatar URI of the ticket associated to the feedback's owner.
Ticket owner Decimal True No User the ticket is assigned to which is associated to feedback submission.
Ticket name String True No Short summary of ticket associated with the submission.
Unique creation key String True No Unique property used for idempotent creates.
Updated by user ID Decimal True No The user that last updated this object. This value is automatically set by HubSpot and may not be modified.
User IDs of all notification followers String True No The user IDs of all users that have clicked follow within the object to opt_in to getting follow notifications.
User IDs of all notification unfollowers String True No The user IDs of all object owners that have clicked unfollow within the object to opt_out of getting follow notifications.
User IDs of all owners String True No The user IDs of all owners of this object.
Owner Assigned Date Datetime True No The most recent date an owner was assigned to this object. This is set automatically by HubSpot and can be used for segmentation and reporting.
Owner String False No The owner of the object.
HubSpot Team String True No The primary team of the owner.
Industry Standard Question Type String True No Industry standard question type for custom surveys.
Sentiment String True No This column is a custom field. Sentiment of feedback submission based on survey type.
Survey ID Decimal True No The survey id that the feedback submission is linked with.
Survey Type String True No The type of the survey.
Source String True No The channel of the survey when the feedback submission occurred.
Date Datetime True No The timestamp of the feedback submission.
Rating Decimal True No The value of the feedback submission.
Feedback sentiment String True No The sentiment of the feedback submission.
Response String False No The follow_up response of the feedback submission.
Ingestion id String True No The identifier we use when we initially capture a feedback submission.
Knowledge article id Decimal True No The id of the knowledge article this submission was for.
Visitor id Decimal True No The id of the visitor who submitted this feedback.
Engagement id Decimal True No The id of the equivalent engagement object.
Submission URL String True No The URL of the page the submission was made from.
Survey Name String True No The name of the feedback survey the submission is linked with.
Form guid String True No The form guid that the feedback submission is linked with.
Email String True No The email of the contact associated with a feedback submission.
Submission Name String True No The email of the contact associated with a feedback submission.

Return to Top

Goals

Name Type ReadOnly References FilterOnly Description
Id [KEY] Long False No Unique identifier of the object.
Archived Bool True No Whether the object is archived or not.
CreatedAt Datetime True No When the object was created.
UpdatedAt Datetime True No When the object was last updated.
MigrationSoftDeleteDeprecated String False No Describes if the goal target can be treated as deleted.
Ad account asset IDs String False No A list of ';'-separated universally unique IDs of ad accounts, each formatted: {AD_NETWORK}-{ACCOUNT_ID}
Ad campaign asset ids String False No A list of ';'-separated universally unique IDs of ad campaigns, each formatted: {NETWORK}-{CAMPAIGN_ID}
All teams String True No The team IDs, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom.
Business units String False No The business units this record is assigned to.
All owner ids String True No The value of all owner referencing properties for this object, both default and custom.
Team ids String False No Which team owns the goal (there should only ever be one team).
Assignee team ID Decimal False No The team ID of the assigned team of the goal (unpopulated if the goal is not team-assigned or team-by-user-assigned).
Assignee user ID Decimal False No The user ID of the assigned user of the goal (unpopulated if the goal is not user-assigned).
Campaign asset ids String False No List of marketing campaign asset ids.
Contact lifecycle stage String False No The lifecycle stage selected for the contact lifecycle goal.
Created by user ID Decimal True No The user that created this object. This value is automatically set by HubSpot and may not be modified.
Object create date/time Datetime True No The date and time at which this object was created. This value is automatically set by HubSpot and may not be modified.
currency String False No DEPRECATED - DO NOT USE! Code for the currency conversion.
Currency Exchange Rate Decimal False No Exchange rate to be used for calculated properties reflecting currency-based values in home currencies. Value is automatically set for in-progress goals. Once a goal has ended, the value should be alterable by admins only.
Deal pipelines String False No A serialized list of DEAL pipeline IDs used to filter the KPI value calculation.
Edit updates notification frequency String False No The frequency of goal edit update notifications.
End date Date False No The last day covered by the Goal Target's date range.
End datetime Datetime False No The last day covered by the Goal Target's date range.
Fiscal year offset Decimal False No Represents the number of months the fiscal year is away from a standard calendar year (0 means the fiscal year starts in January).
Goal name String False No The name of the goal.
Goal target currency code String False No Currency code for the goal target.
Goal Target Group ID Decimal False No Object ID of the associated Goal Target Group.
Goal type String False No The goal type.
Group correlation UUID String False No Unique ID set on all Goal Targets and Goal Target Groups created by a single request.
Is forecastable String False No READ ME! (kind of) indicates whether the goal should appear in the forecasting app - this property may be true even if the goal should NOT appear in the forecasting app. As of April 2023, this property will be true if hs_milestone is either \“monthly\” or \“quarterly\“, and if the count of pipelines in hs_pipelines 0 or 1. No other checks are made!
IsLegacy String False No Describes if the object was created during the migration process and it comes from the old app.
KPI Display Unit String False No Display units for goals based on duration properties.
KpiFilterGroups String False No Filter groups for KPI calculations.
KPI is team rollup Bool False No Indicates whether this is a rollup goal: whether the KPI allows contributions from child teams (in addition to the assigned team).
KpiMetricType String False No Type of metric used to aggregate the property name.
KpiObjectType String False No The name of the CrmObject the KPI values are based on.
Kpi object type id String False No The ObjectTypeId of the object the KPI values are based on.
KpiPropertyName String False No Name of the property on the object type aggregated as the KPI value.
KpiSingleObjectCustomGoalTypeName String False No Single object custom goal components (metric type, object type, property name).
KpiTimePeriodProperty String False No Time period property.
KpiTrackingMethod String False No Tracking method for progress directionality.
Kpi unit type String False No Unit type of the kpi calculation.
KPI value Decimal False No The latest KPI value for this goal target.
KPI value calculated at Decimal False No The time that latest KPI value was calculated.
KPI value last calculated at Datetime False No The time that latest KPI value was calculated.
Object last modified date/time Datetime True No Most recent timestamp of any property update for this object. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically.
LegacyActive String False No Migrated value describing if the goal is active or soft deleted.
LegacyCreatedAt Decimal False No Migrated value of created at.
LegacyCreatedBy Decimal False No Migrated value of created by.
LegacyQuarterlyTargetCompositeId String False No Concatenated value of the 3 sql_ids that form a quarterly GT separated by a '-'. Used to be able to update both monthly and quarterly legacy Goal Targets.
LegacySqlId Decimal False No Id of the migrated goal target in the old system. This has been deprecated for legacy_unique_sql_id.
LegacyUniqueSqlId Decimal False No Id of the migrated goal target in the old system. This property has a unique value to ensure no duplicate migrated goals.
LegacyUpdatedAt Decimal False No Migrated value of updated at.
LegacyUpdatedBy Decimal False No Migrated value of updated by.
Merged record IDs String True No The list of record IDs that have been merged into this record. This value is automatically set by HubSpot and may not be modified.
MigrationSoftDelete String False No Describes if the goal target can be treated as deleted.
Milestone String False No The period during which a Goal Target is active.
Record ID Decimal True No The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
Record Creation Source String True No Source (PropertySource) that created this object record.
Record Creation Source ID String True No The sourceId -- further detail -- of the source that created this object record.
Record Creation Source User ID Decimal True No User ID of the user who initiated creation of this object record.
Outcome String False No Goal Target outcome.
Owner ids of all owners String False No The owner IDs of all owners of this object.
Participant type String False No The type of participant for the Goal Target.
Pipeline ids String False No List of deal pipelines that the quota applies to. Used to calculate kpi values.
Pipelines String False No A serialized list of pipeline IDs used to filter the KPI value calculation.
Progress updates notification frequency String False No The frequency of goal progress update notifications.
Read Only Object Bool True No Is the object read only.
Notify on goal achieved String False No Opt into notifications when goal is achieved.
Notify with goal edit updates String False No Opt into goal edit update notifications.
Notify on goal exceeded String False No Opt into notifications when goal is exceeded.
Notify on goal kickoff String False No Opt into notifications when a goal is kicked off.
Notify on goal missed String False No Opt into notifications when a goal is missed.
Notify with progress updates String False No Opt into goal progress updates notifications.
ShouldRecalculate String False No Property used to flag Goal targets that need to be recalculated.
Start datetime Datetime False No The first day that goal target's date range covers.
Static KPI Filter Groups String False No Goal Target Filter Group(s) for all filters except time-based filters.
Status String False No The status of the Goal Target.
Status display order Decimal True No The goal status display order.
Target amount Decimal False No The target amount for this goal target.
Target amount in company currency Decimal True No The amount of the goal target, using the exchange rate, in your company's currency.
Team ID Decimal False No The team ID associated with the Goal Target.
Ticket pipelines String False No A serialized list of TICKET pipeline IDs used to filter the KPI value calculation.
Unique creation key String True No Unique property used for idempotent creates.
Updated by user ID Decimal True No The user that last updated this object. This value is automatically set by HubSpot and may not be modified.
User ID Decimal False No The user ID associated with the Goal Target.
User IDs of all notification followers String True No The user IDs of all users that have clicked follow within the object to opt-in to getting follow notifications.
User IDs of all notification unfollowers String True No The user IDs of all object owners that have clicked unfollow within the object to opt-out of getting follow notifications.
User IDs of all owners String True No The user IDs of all owners of this object.
Performed in an import Bool True No Object is part of an import.
Owner Assigned Date Datetime True No The most recent date an owner was assigned to this object. This is set automatically by HubSpot and can be used for segmentation and reporting.
Owner String False No The owner of the object.
HubSpot Team String True No The primary team of the owner.
Start date Date False No The first day that goal target's date range covers.
Kpi progress percent Decimal True No Progress percent is represented by the kpi value as a percent of the target amount.

Return to Top

LeadAssociations

Name Type ReadOnly References FilterOnly Description
Id [KEY] Long False Leads.Id No Leads ID
AssociationId [KEY] Long False No ID of the object that this Leads object is associated with.
Type [KEY] String False No Type of the associated object, which can be a contact, deal etc.

Return to Top

LeadPropertiesHistory

Name Type ReadOnly References FilterOnly Description
PropertyName String True No The name of the property.
Value String True No The historical value of the property.
SourceType String True No The method by which the property was changed.
SourceId String True No Additional data related to the source. May not be populated for all sources.
Timestamp Datetime True No Datetime when the property was updated.
LeadId Long True No The lead identifier.

Return to Top

Leads

Name Type ReadOnly References FilterOnly Description
Id [KEY] Long False No Unique identifier of the object.
Archived Bool True No Whether the object is archived or not.
CreatedAt Datetime True No When the object was created.
UpdatedAt Datetime True No When the object was last updated.
All teams String True No The team IDs, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom
Business units String False No The business units this record is assigned to.
All owner ids String True No The value of all owner referencing properties for this object, both default and custom.
All team ids String True No The team ids corresponding to all owner referencing properties for this object, both default and custom.
Associated Company Domain String True No Domain of the associated company if present.
Associated Company Name String True No Name of the associated company if present.
Associated Contact Email String True No Email of the associated contact if present.
Associated Contact First Name String True No First name of the associated contact if present.
Associated Contact Last Name String True No Last name of the associated contact if present.
Calls Connected Count Decimal True No The number of associated calls that are considered to be 'connected'
Primary company analytics source String True No The latest analytics source from the lead's primary company at the time when the company was associated with the lead. This property will not be updated after the first rollup.
Primary company analytics source first drilldown String True No The first drilldown of the latest analytics source from the lead's primary company at the time when the company was associated with the lead. This property will not be updated after the first rollup.
Primary company analytics source second drilldown String True No The second drilldown of the latest analytics source from the lead's primary company at the time when the company was associated with the lead. This property will not be updated after the first rollup.
Company Avatar FileManager key String True No The path in the FileManager CDN for the lead's primary company's avatar override image.
Is Target Account String True No Associated company's status about being marketed or sold to.
Company Last Activity Date Datetime True No The date of the last activity, rolled up from the primary associated company.
Company Last Engagement Date Datetime True No The last time a contact engaged with your site or a form, document, meetings link, or tracked email. This doesn't include marketing emails or emails to multiple contacts.
Company Last Engagement Type String True No The type of the last engagement a company performed. This doesn't include marketing emails or emails to multiple contacts.
Company Time of Last Session Datetime True No Time of the last session attributed to any contacts that are associated with this lead's primary company
Company Next Activity Date Datetime True No The date of the next activity, rolled up from the primary associated company.
Company Next Activity Type String True No The type of the next activity, rolled up from the primary associated company.
Company Number of Pageviews Decimal True No Total number of page views across all contacts associated with this lead's primary company
Associated company timezone String True No The associated company's timezone, if present.
Primary contact analytics source String True No The latest analytics source from the lead's primary contact at the time when the contact was associated with the lead. This property will not be updated after the first rollup.
Primary contact analytics source first drilldown String True No The first drilldown of the latest analytics source from the lead's primary contact at the time when the contact was associated with the lead. This property will not be updated after the first rollup.
Primary contact analytics source second drilldown String True No The second drilldown of the latest analytics source from the lead's primary contact at the time when the contact was associated with the lead. This property will not be updated after the first rollup.
Contact Avatar FileManager key String True No The path in the FileManager CDN for the lead's primary contact's avatar override image.
Contact Buying Role String True No Associated contact's role during the sales process.
Associated contact job title String True No Job title of the associated contact if present.
Contact Last Activity Date Datetime True No The date of the last activity, rolled up from the primary associated contact.
Contact Last Engagement Date Datetime True No The last time a contact engaged with your site or a form, document, meetings link, or tracked email. This doesn't include marketing emails or emails to multiple contacts.
Contact Last Engagement Type String True No The type of the last engagement a contact performed. This doesn't include marketing emails or emails to multiple contacts.
Contact Time of Last Session Datetime True No Timestamp for start of the most recent session for this lead's primary contact to your website.
Contact Next Activity Date Datetime True No The date of the next activity, rolled up from the primary associated contact.
Contact Next Activity Type String True No The type of the next activity, rolled up from the primary associated contact.
Contact Number of Pageviews Decimal True No Total number of page views this lead's primary contact has had on your website
Associated contact timezone String True No The associated contact's timezone, if present.
Created by user ID Decimal True No The user that created this object. This value is automatically set by HubSpot and may not be modified.
Object create date/time Datetime True No The date and time at which this object was created. This value is automatically set by HubSpot and may not be modified.
Emails Connected Count Decimal True No The number of associated emails that are considered to be 'connected'
Initial Assign Notification State String True No Determines the status of sending the initial lead assign notification upon object creation
Last Activity Date Datetime True No The date of the last activity. Defaults to the date of the primary associated contact. If not present, looks to the date of the primary associated company.
Last Engagement Date Datetime True No If primary contact exists, the last time the contact engaged with your site or a form, document, meetings link, or tracked email. This doesn't include marketing emails or emails to multiple contacts. Otherwise it is the last time for the associated company
Last Engagement Type String True No If primary contact exists, the type of the last engagement the contact performed. This doesn't include marketing emails or emails to multiple contacts. Otherwise it is the type of the last engagement for the associated company
Lead Time of Last Session Datetime True No If the associated contact exists, the timestamp for the start of the most recent session for this contact to your website. Otherwise the timestamp for the start of the most recent session for the associated company to your website.
Object last modified date/time Datetime True No Most recent timestamp of any property update for this object. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically.
Associated Deal Pipeline Stage String True No The pipeline stage of the primary associated deal
Associated deals Decimal True No Number of associated deals for a given lead.
Call Count Decimal True No The number of calls made to this lead
Closed won deal amount Decimal True No The total amount of the lead's associated deals that are closed-won
Message Thread Count Decimal True No The number of message threads (SMS, LinkedIn, WhatsApp) opened with this lead
Currency String True No Currency code for most recent associated deal
Lead Disqualification Note String False No A note on why the lead was disqualified
Disqualification Reason String False No Dropdown list of reasons for disqualification
Email Count Decimal True No The number of emails sent to this lead
First Outreach Date Datetime True No The date of the first outreach (call, email, meeting or other communication) from the sales rep to the lead.
Lead Inferred Pseudostage String True No This indicates the inferred lead pipeline pseudostage based on underlying activities taken by the user or lead.
Is Disqualified Decimal True No Indicates whether the lead is disqualified (with a value of 1) or not (with a value of 0). Hidden property that exists for the purpose of reporting.
In progress leads Decimal True No Indicates whether the lead is in progress (with a value of 1) or not (with a value of 0). Hidden property that exists for the purpose of reporting.
Is New Decimal True No Indicates whether the lead is new (with a value of 1) or not (with a value of 0). Hidden property that exists for the purpose of reporting.
Open leads Decimal True No Whether the lead's pipeline stage has any category other than QUALIFIED or UNQUALIFIED
Is Qualified Decimal True No Indicates whether the lead is qualified (with a value of 1) or not (with a value of 0). Hidden property that exists for the purpose of reporting.
Lead Label String False No Current status of a given lead
Meeting Count Decimal True No The number of meetings booked with this lead
Lead Name String False No The full name of the lead.
Lead name calculated String True No The calculated full name of the lead.
Outreach activity count Decimal True No The total number of outreach activities (call, email, meeting or other communication) from the sales rep to the lead.
Open deal amount Decimal True No The total value of any open deals associated with this lead
Primary Company Owner String True No The owner ID of the associated primary company
Primary Contact Owner String True No The owner ID of the associated primary contact
Lead Source String True No The analytics source of the lead, inherited from primary associated contact or company at the time of lead creation
Initial company lifecycle stage String True No The first detected lifecycle stage on a company associated with the lead as that lead's primary company. Not updated after initial value set.
Initial contact lifecycle stage String True No The first detected lifecycle stage on a contact associated with the lead as that lead's primary contact. Not updated after initial value set.
Lead Source DrillDown 1 String True No Second tier of specificity on the lead source
Lead Source DrillDown 2 String True No Third tier of specificity on the lead source
Initial source lifecycle stage String True No The lifecycle stage of the primary associated contact or company at the time of lead creation
Time to First Touch Decimal True No Time between lead creation and first outreach activity
Lead Title (DEPRECATEDUse hsLeadName) String True No The title of the lead
Lead Type String False No The type of lead. By default, categorize your lead as either a New Business, Existing Business, or Re-attempting
Meetings Connected Count Decimal True No The number of associated meetings that are considered to be 'connected'
Merged record IDs String True No The list of record IDs that have been merged into this record. This value is automatically set by HubSpot and may not be modified.
Next Activity Date Datetime True No The date of the next activity. Defaults to the date of the primary associated contact. If not present, looks to the date of the primary associated company.
Next Activity Type String True No The type of the next activity. Defaults to the type of the primary associated contact. If not present, looks to the type of the primary associated company.
Lead Number of Pageviews Decimal True No Number of pageviews for the associated contact if it exists. Otherwise the number of pageviews for the associated company.
Record ID Decimal True No The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
Record Creation Source String True No Raw internal propertySource present in the RequestMeta when this record was created
Record Source Detail 1 String True No First level of detail on how this record was created
Record Source Detail 2 String True No Second level of detail on how this record was created
Record Source Detail 3 String True No Third level of detail on how this record was created
Record Creation Source ID String True No Raw internal sourceId present in the RequestMeta when this record was created
Record Source String True No How this record was created
Record Creation Source User ID Decimal True No Raw internal userId present in the RequestMeta when this record was created
Lead owner calculated String True No The calculated owner of the lead. Owner of the primary contact if it exists, owner of primary company otherwise.
Lead Pipeline String False No The pipeline that the lead is in
Lead Pipeline Stage String False No
Pipeline Stage Category String True No The category assigned to the lead's current pipeline stage
Pipeline Stage Category Last Updated At Datetime True No Timestamp of the most recent update to the lead's pipeline stage category
Primary Associated Object Name String True No The primary associated contact or company name
Primary Associated Company Object ID Decimal False No The object ID of the primary associated company
Primary contact enrolled in sequence Bool True No Indicates whether the lead's primary contact is currently enrolled in a sequence
Primary Associated Contact Object ID Decimal False No The object ID of the primary associated contact
Read Only Object Bool True No Is the object read only
Shared Team IDs String True No The team IDs of all teams that have shared access to this object
Shared User IDs String True No The user IDs of all users that have shared access to this object
Lead tags String True No List of tag ids applicable to a lead. This property is set automatically by HubSpot.
Time in 'Attempting (Lead pipeline)' Decimal True No The total time in seconds spent by the lead in the 'Attempting' stage, 'Lead pipeline' pipeline
Time in 'Connected (Lead pipeline)' Decimal True No The total time in seconds spent by the lead in the 'Connected' stage, 'Lead pipeline' pipeline
Time in 'New (Lead pipeline)' Decimal True No The total time in seconds spent by the lead in the 'New' stage, 'Lead pipeline' pipeline
Time in 'Qualified (Lead pipeline)' Decimal True No The total time in seconds spent by the lead in the 'Qualified' stage, 'Lead pipeline' pipeline
Time in 'Disqualified (Lead pipeline)' Decimal True No The total time in seconds spent by the lead in the 'Disqualified' stage, 'Lead pipeline' pipeline
Unique creation key String True No Unique property used for idempotent creates
Updated by user ID Decimal True No The user that last updated this object. This value is automatically set by HubSpot and may not be modified.
User IDs of all notification followers String True No The user IDs of all users that have clicked follow within the object to opt-in to getting follow notifications
User IDs of all notification unfollowers String True No The user IDs of all object owners that have clicked unfollow within the object to opt-out of getting follow notifications
User IDs of all owners String True No The user IDs of all owners of this object
Cumulative time in Attempting (Lead pipeline) Decimal True No The cumulative time in seconds spent by the lead in the 'Attempting' stage, 'Lead pipeline' pipeline
Cumulative time in Connected (Lead pipeline) Decimal True No The cumulative time in seconds spent by the lead in the 'Connected' stage, 'Lead pipeline' pipeline
Cumulative time in New (Lead pipeline) Decimal True No The cumulative time in seconds spent by the lead in the 'New' stage, 'Lead pipeline' pipeline
Cumulative time in Qualified (Lead pipeline) Decimal True No The cumulative time in seconds spent by the lead in the 'Qualified' stage, 'Lead pipeline' pipeline
Cumulative time in Disqualified (Lead pipeline) Decimal True No The cumulative time in seconds spent by the lead in the 'Disqualified' stage, 'Lead pipeline' pipeline
Date entered Attempting (Lead pipeline) Datetime True No The date and time when the lead entered the 'Attempting' stage, 'Lead pipeline' pipeline
Date entered Connected (Lead pipeline) Datetime True No The date and time when the lead entered the 'Connected' stage, 'Lead pipeline' pipeline
Date entered New (Lead pipeline) Datetime True No The date and time when the lead entered the 'New' stage, 'Lead pipeline' pipeline
Date entered Qualified (Lead pipeline) Datetime True No The date and time when the lead entered the 'Qualified' stage, 'Lead pipeline' pipeline
Date entered Disqualified (Lead pipeline) Datetime True No The date and time when the lead entered the 'Disqualified' stage, 'Lead pipeline' pipeline
Date exited Attempting (Lead pipeline) Datetime True No The date and time when the lead exited the 'Attempting' stage, 'Lead pipeline' pipeline
Date exited Connected (Lead pipeline) Datetime True No The date and time when the lead exited the 'Connected' stage, 'Lead pipeline' pipeline
Date exited New (Lead pipeline) Datetime True No The date and time when the lead exited the 'New' stage, 'Lead pipeline' pipeline
Date exited Qualified (Lead pipeline) Datetime True No The date and time when the lead exited the 'Qualified' stage, 'Lead pipeline' pipeline
Date exited Disqualified (Lead pipeline) Datetime True No The date and time when the lead exited the 'Disqualified' stage, 'Lead pipeline' pipeline
Latest time in Attempting (Lead pipeline) Decimal True No The total time in seconds spent by the lead in the 'Attempting' stage, 'Lead pipeline' pipeline since it last entered this stage
Latest time in Connected (Lead pipeline) Decimal True No The total time in seconds spent by the lead in the 'Connected' stage, 'Lead pipeline' pipeline since it last entered this stage
Latest time in New (Lead pipeline) Decimal True No The total time in seconds spent by the lead in the 'New' stage, 'Lead pipeline' pipeline since it last entered this stage
Latest time in Qualified (Lead pipeline) Decimal True No The total time in seconds spent by the lead in the 'Qualified' stage, 'Lead pipeline' pipeline since it last entered this stage
Latest time in Disqualified (Lead pipeline) Decimal True No The total time in seconds spent by the lead in the 'Disqualified' stage, 'Lead pipeline' pipeline since it last entered this stage
Performed in an import Bool True No Object is part of an import
Workflow updated lifecycle stage of company Bool False No Indicates whether a workflow updated the lifecycle stage of the lead's associated company.
Workflow updated lifecycle stage of contact Bool False No Indicates whether a workflow updated the lifecycle stage of the lead's associated contact.
Owner Assigned Date Datetime True No The most recent date an owner was assigned to this object. This is set automatically by HubSpot and can be used for segmentation and reporting.
Lead Owner String False No Owner of the lead. Defaults to the owner of the primary associated contact. If not present, looks to the owner of the primary associated company.
HubSpot Team String True No The primary team of the owner.
lead custom field String False No This column is a custom field. desc

Return to Top

LineitemAssociations

Name Type ReadOnly References FilterOnly Description
Id [KEY] Long False LineItems.Id No LineItems ID.
AssociationId [KEY] Long False No ID of the object that this LineItem object is associated with.
Type [KEY] String False No Type of the associated object* which can be a contact* deal etc.
TypeId [KEY] String False AssociationsLabels.TypeId No The numeric ID for the association type. This column is empty for more general associations queries.
Category [KEY] String False AssociationsLabels.Category No The category of the association type for the specified object pair. This column is empty for more generic associations queries.
TypeLabel String True AssociationsLabels.Label No The label assigned to the association type between objects.

Return to Top

Lineitems

Name Type ReadOnly References FilterOnly Description
Id [KEY] Long False No Unique identifier of the object.
Archived Bool True No Whether the object is archived or not.
CreatedAt Datetime True No When the object was created.
UpdatedAt Datetime True No When the object was last updated.
Net price Decimal True No The amount of a line item.
Create Date Datetime False No The date the line item was created.
Description String False No Full description of product.
Unit discount Decimal False No The discount amount applied.
Annual contract value Decimal True No The annual contract value ACV of this product.
All accessible team IDs String True No The team IDs* including up the team hierarchy* corresponding to all owner referencing properties for this object_ both default and custom.
Business units String False No The business units this record is assigned to.
All owner ids String True No The value of all owner referencing properties for this object_ both default and custom.
All team ids String True No The team ids corresponding to all owner referencing properties for this object_ both default and custom.
Allow buyer selected quantity String True No Whether buyer selected quantity is to be enabled or not for a LineItem.
Annual recurring revenue Decimal True No The annual recurring revenue ARR of this product.
Delayed billing start by days Decimal False No Number of days billing should be delayed by. It allows the customers to start billing sometime in the future.
Delayed billing start by months Decimal False No Number of months billing should be delayed by. It allows the customers to start billing sometime in the future.
Start billing terms String True No The type of billing start delay. It can be a fixed date in the future_ relative delay in number of days or months.
Unit cost Decimal False No The amount that sold goods cost the HubSpot customer.
Created by user ID Decimal True No The user that created this object. This value is automatically set by HubSpot and may not be modified.
Object create date_time Datetime True No The date and time at which this object was created. This value is automatically set by HubSpot and may not be modified.
Discount Percentage Decimal False No The discount percentage applied.
External LineItem id Decimal True No The ID of a line item.
Image URL String False No Product images.
Last Modified Date Datetime True No The date any property on this product was modified.
Currency String False No Currency code for the line item.
Margin Decimal True No The margin value of this product.
Annual contract value margin Decimal True No The margin annual contract value of this product.
Annual recurring revenue margin Decimal True No The margin annual recurring revenue of this product.
Monthly recurring revenue margin Decimal True No The margin monthly recurring revenue of this product.
Total contract value margin Decimal True No The margin total contract value of this product.
Merged object IDs String True No The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.
Monthly recurring revenue Decimal True No The monthly recurring revenue MRR of this product.
Record ID Decimal True No The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
Position on quote Decimal False No The order which the line item appears on the quotes.
Pre Discount Amount Decimal True No The pre_discount amount of a line item.
Product ID Decimal False No ID of the product this was copied from.
Read Only Object Bool True No Is the object read only.
End Date Date True No Recurring billing end date for a line item.
Number of payments Decimal True No Number of payments for the given period on a Line Item.
Term String False No Product recurring billing duration.
Billing start date Date False No Recurring billing start date for a line item.
Billing terms String True No If there are fixed number payments or it goes on until cancelled.
SKU String False No Unique product identifier.
Sync amount Decimal True No The amount set by Ecommerce sync.
Total contract value Decimal True No The total contract value TCV of this product.
Term in months Decimal True No The number of months in the term of this product.
Calculated Total Discount Decimal True No Calculated total Discount for the line item taking in consideration the flat amount and discount percentage.
Unique creation key String True No Unique property used for idempotent creates.
Updated by user ID Decimal True No The user that last updated this object. This value is automatically set by HubSpot and may not be modified.
URL String False No Product url.
User IDs of all notification followers String True No The user IDs of all users that have clicked follow within the object to opt_in to getting follow notifications
User IDs of all notification unfollowers String True No The user IDs of all object owners that have clicked unfollow within the object to opt_out of getting follow notifications
User IDs of all owners String True No The user IDs of all owners of this object.
Variant id of the product Decimal True No Varient id of the shopify product.
Owner Assigned Date Datetime True No The most recent date an owner was assigned to this object. This is set automatically by HubSpot and can be used for segmentation and reporting.
Owner String False No The owner of the object.
HubSpot Team String True No The primary team of the owner.
Name String False No Product name.
Unit price Decimal False No Cost of product.
Quantity Decimal False No How many units of a product are in this line item.
Billing frequency String False No How often a line item with recurring billing is billed. It informs the pricing calculation for deals and quotes. Line items with one_time billing aren_t included.
Tax Decimal False No The tax amount applied.

Return to Top

OrderAssociations

Name Type ReadOnly References FilterOnly Description
Id [KEY] Long False Orders.Id No Orders ID
AssociationId [KEY] Long False No ID of the object that this Orders object is associated with.
Type [KEY] String False No Type of the associated object* which can be a contact* Order etc.

Return to Top

OrderPropertiesHistory

Name Type ReadOnly References FilterOnly Description
PropertyName String True No The name of the property.
Value String True No The historical value of the property.
SourceType String True No The method by which the property was changed.
SourceId String True No Additional data related to the source. May not be populated for all sources.
Timestamp Datetime True No Datetime when the property was updated.
OrderId Long True No The order identifier.

Return to Top

Orders

Name Type ReadOnly References FilterOnly Description
Id [KEY] Long False No Unique identifier of the object.
Archived Bool True No Whether the object is archived or not.
CreatedAt Datetime True No When the object was created.
UpdatedAt Datetime True No When the object was last updated.
All teams String True No The team IDs, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom
Business units String False No The business units this record is assigned to.
All owner ids String True No The value of all owner referencing properties for this object, both default and custom.
All team ids String True No The team ids corresponding to all owner referencing properties for this object, both default and custom.
Billing City String False No The city for the billing address.
Billing Country String False No The country for the billing address.
Billing Email String False No Customer's email from billing information
Billing First Name String False No Customer's first name from billing information
Billing Last Name String False No Customer's last name from billing information
Billing Phone Number String False No The phone number for the billing address.
Billing ZIP/Postal Code String False No The ZIP/postal code for the billing address.
Billing State String False No The state for the billing address.
Billing Street String False No The street for the billing address.
Buyer Accepts Marketing Bool False No Indicates if the customer has opted in/out of receiving marketing emails.
Cancellation Reason String False No The reason given for cancelling the order.
Closed Date Datetime True No Date when the order was closed, null otherwise, set automatically
Created by user ID Decimal True No The user that created this object. This value is automatically set by HubSpot and may not be modified.
Object create date/time Datetime True No The date and time at which this object was created. This value is automatically set by HubSpot and may not be modified.
Currency Code String False No The currency code used in the order.
Customer Phone String False No Phone number of Customer placing the Order
Date entered 'Stage 1 (Pipeline 1)' Datetime True No The date and time when the order entered the 'Stage 1' stage, 'Pipeline 1' pipeline
Date exited 'Stage 1 (Pipeline 1)' Datetime True No The date and time when the order exited the 'Stage 1' stage, 'Pipeline 1' pipeline
Discount Codes String False No Discount Codes on an order.
Exchange rate Decimal False No This is the exchange rate used to convert the cart amount into your company currency.
Canceled Date Datetime False No Date the order is canceled.
Cart ID String False No Unique identifier in an external system for the cart associated with the order.
Checkout ID String False No Unique identifier in an external system for the checkout associated with the order.
Created Date Datetime False No Date the order is created.
Modified Date Datetime False No Most recent order modified date.
Order ID String False No Unique identifier in an external system for the order.
Status String False No Current status of the order as recorded on the source system.
Order URL String False No An URL that links to an external site where the orders details can be viewed.
Fulfillment Status String False No Current fulfillment/shipping status of the order.
Amount in company currency Decimal False No The amount of the order, using the exchange rate, in your company's currency
Landing Site String False No The URL of the first page on the sellers site that the customer landed on prior to them placing the order.
Object last modified date/time Datetime True No Most recent timestamp of any property update for this object. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically.
Merged record IDs String True No The list of record IDs that have been merged into this record. This value is automatically set by HubSpot and may not be modified.
Record ID Decimal True No The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
Record Creation Source String True No Raw internal propertySource present in the RequestMeta when this record was created
Record Source Detail 1 String True No First level of detail on how this record was created
Record Source Detail 2 String True No Second level of detail on how this record was created
Record Source Detail 3 String True No Third level of detail on how this record was created
Record Creation Source ID String True No Raw internal sourceId present in the RequestMeta when this record was created
Record Source String True No How this record was created
Record Creation Source User ID Decimal True No Raw internal userId present in the RequestMeta when this record was created
Discount Decimal False No Total Discount on an order as an amount.
Name String False No Unique ID as represented by a number.
Notes String False No A block of text associated with the order.
Payment Processing Method String False No Type of payment processing method.
Payment Status String False No Current Payment status of the order.
Pinned engagement ID Decimal False No The object ID of the current pinned engagement. This will only be shown if there is already an association to the engagement.
Pipeline String False No The pipeline that contains this order
Stage String False No The order pipeline stage.
Processed Date Datetime False No The date/time the order was imported into HubSpot.
Read Only Object Bool True No Is the object read only
Referring Site String False No The URL of the site that the customer came from to arrive at the sellers site prior to placing their order.
Refund Amount Decimal False No Refunded amount, if any, associated with an order.
Shared Team IDs String True No The team IDs of all teams that have shared access to this object
Shared User IDs String True No The user IDs of all users that have shared access to this object
Shipping City String False No The city for the shipping address.
Shipping Country String False No The country for the shipping address.
Shipping Phone Number String False No The phone number for the shipping address.
Shipping ZIP/Postal Code String False No The ZIP/postal code for the shipping address.
Shipping State String False No The state for the shipping address.
Shipping Street String False No The street for the shipping address.
Shipping Cost Decimal False No The base cost (i.e. undiscounted), in the orders associated currency, associated with shipping the order.
Shipping Status URL String False No URL to Shipping status for the order.
Shipping Tracking Number String False No List of Shipment tracking IDs associated with the order.
Source ID Decimal True No HubSpot developer App ID from where this order data is first synced.
Source Store String False No Data used to identify which store the order came from.
Subtotal Price Decimal False No Total order amount before discounts, tax, duties etc.
Tags String False No A collection of tag strings associated with the order.
Tax Price Decimal False No Tax amount associated with the order, including duties.
Time in 'Stage 1 (Pipeline 1)' Decimal True No The total time in seconds spent by the order in the 'Stage 1' stage, 'Pipeline 1' pipeline
Total Price Decimal False No Sum Total amount associated with this order.
Total Weight String False No The total weight of the order for shipping purposes.
Unique creation key String True No Unique property used for idempotent creates
Updated by user ID Decimal True No The user that last updated this object. This value is automatically set by HubSpot and may not be modified.
User IDs of all notification followers String True No The user IDs of all users that have clicked follow within the object to opt-in to getting follow notifications
User IDs of all notification unfollowers String True No The user IDs of all object owners that have clicked unfollow within the object to opt-out of getting follow notifications
User IDs of all owners String True No The user IDs of all owners of this object
Performed in an import Bool True No Object is part of an import
Owner Assigned Date Datetime True No The most recent date an owner was assigned to this object. This is set automatically by HubSpot and can be used for segmentation and reporting.
Owner String False No The owner of the object.
HubSpot Team String True No The primary team of the owner.

Return to Top

Products

Name Type ReadOnly References FilterOnly Description
Id [KEY] Long False No Unique identifier of the object.
Archived Bool True No Whether the object is archived or not.
CreatedAt Datetime True No When the object was created.
UpdatedAt Datetime True No When the object was last updated.
Net price Decimal True No Internal placeholder to prevent conflicts with line item property of same name.
Create Date Datetime False No The date the product was created.
Product description String False No Full description of product.
Unit discount Decimal False No The discount amount applied.
All accessible team IDs String True No The team IDs* including up the team hierarchy* corresponding to all owner referencing properties for this object_ both default and custom.
Business units String False No The business units this record is assigned to.
All owner ids String True No The value of all owner referencing properties for this object_ both default and custom.
All team ids String True No The team ids corresponding to all owner referencing properties for this object_ both default and custom.
Avatar FileManager key String True No The path in the FileManager CDN for this product's image. Automatically set by HubSpot.
Unit cost Decimal False No The amount that sold goods cost the HubSpot customer.
Created by user ID Decimal True No The user that created this object. This value is automatically set by HubSpot and may not be modified.
Object create date_time Datetime True No The date and time at which this object was created. This value is automatically set by HubSpot and may not be modified.
Discount Percentage Decimal False No The discount percentage applied.
Folder Id Decimal False No The ID of the folder that has this product.
Image Url String False No Product images.
Last Modified Date Datetime True No The date any property on this product was modified.
Merged object IDs String True No The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.
Record ID Decimal True No The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
Product Type String False No The type of product. By default* categorize your product as either Inventory* Non_Inventory or Service.
Read Only Object Bool True No Is the object read only.
Term String False No Product recurring billing duration.
Start Date Date False No Recurring billing start date for a line item.
SKU String False No Unique product identifier.
Unique creation key String True No Unique property used for idempotent creates.
Updated by user ID Decimal True No The user that last updated this object. This value is automatically set by HubSpot and may not be modified.
URL String False No Product url.
User IDs of all notification followers String True No The user IDs of all users that have clicked follow within the object to opt_in to getting follow notifications.
User IDs of all notification unfollowers String True No The user IDs of all object owners that have clicked unfollow within the object to opt_out of getting follow notifications.
User IDs of all owners String True No The user IDs of all owners of this object.
Owner Assigned Date Datetime True No The most recent date an owner was assigned to this object. This is set automatically by HubSpot and can be used for segmentation and reporting.
Owner String False No The owner of the object.
HubSpot Team String True No The primary team of the owner.
Name String False No Product name.
Unit price Decimal False No Cost of product.
Quantity Decimal True No Internal placeholder to prevent conflicts with line item property of same name.
Recurring billing frequency String False No How often a product with recurring billing is billed. It informs the pricing calculation for deals and quotes. Products with one_time billing aren_t included.
Tax Decimal False No The tax amount applied.

Return to Top

QuoteAssociations

Name Type ReadOnly References FilterOnly Description
Id [KEY] Long False Quotes.Id No Quotes ID.
AssociationId [KEY] Long False No ID of the object that this Quote object is associated with.
Type [KEY] String False No Type of the associated object* which can be a contact* deal etc.
TypeId [KEY] String False AssociationsLabels.TypeId No The numeric ID for the association type. This column is empty for more general associations queries.
Category [KEY] String False AssociationsLabels.Category No The category of the association type for the specified object pair. This column is empty for more generic associations queries.
TypeLabel String True AssociationsLabels.Label No The label assigned to the association type between objects.

Return to Top

Quotes

Name Type ReadOnly References FilterOnly Description
Id [KEY] Long False No Unique identifier of the object.
Archived Bool True No Whether the object is archived or not.
CreatedAt Datetime True No When the object was created.
UpdatedAt Datetime True No When the object was last updated.
Business units String False No The business units this record is assigned to.
Allowed Payment Methods String False No Accepted forms of payment if quote is using HubSpot Payment.
Quote Approver String False No
Collect Billing Address Bool False No Indicates if billing address should be collected with this quote.
Created by user ID Decimal True No The user that created this object. This value is automatically set by HubSpot and may not be modified.
Create date Datetime True No The date the quote was created.
Quote Domain String False No Domain this quote should be served from.
ESign Date Datetime True No The date and time the document was signed by all signers.
Expiration Template Path String False No Path of the expiration template for the quote.
Quote approval feedback String False No Feedback about this quote during the approval process.
Language String False No The language for displaying this quote publicly.
Last modified date Datetime True No The last time any property on the quote was modified.
Global Term Line Item Discount Percentage String False No For internal HubSpot Application use only. Global term for the discount percentage applied.
Global Term Line Item Discount Percentage Enabled Bool False No For internal HubSpot Application use only. Indicates if the Global term for the discount percentage is enabled.
Global Term Line Item Recurring Billing Period String False No For internal HubSpot Application use only. Global term for product recurring billing duration.
Global Term Line Item Recurring Billing Period Enabled Bool False No For internal HubSpot Application use only. Indicates if the Global term for product recurring billing duration is enabled.
Global Term Line Item Recurring Billing Start Date String False No For internal HubSpot Application use only. Global term for recurring billing start date for a line item.
Global Term Line Item Recurring Billing Start Date Enabled Bool False No For internal HubSpot Application use only. Indicates if the Global term for recurring billing start date for a line item is enabled.
Global Term Line Item Recurring Billing Frequency String False No For internal HubSpot Application use only. Global term for how frequently the product is billed.
Global Term Line Item Recurring Billing Frequency Enabled Bool False No For internal HubSpot Application use only. Indicates if the Global term for how frequently the product is billed is enabled.
Locale String False No The locale for displaying this quote publicly.
Locked Bool True No Indicates if this quote is locked and can never be updated.
Merged object IDs String True No The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.
Record ID Decimal True No The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
Payment date Datetime True No The date the quote was paid by the customer.
Payment Status String True No Payment status for the quote.
Payment Type String False No Payment type for the quote if payment is enabled.
Quote PDF download link String True No The link to download a pdf of a quote.
Proposal Domain String True No Domain this proposal should be served from.
Proposal Slug String True No Path to serve this proposal from.
Proposal Template String False No Template Path this proposal is rendered with.
Public URL key String True No Key for accessing quote document URL.
Quote Total Preference String False No What LineItem property will be used to calculate the Quote Amount.
Read Only Object Bool True No Is the object read only.
Sender image URL String False No URL to image of the sender avatar image to be set on the quote.
Quote Slug String False No Path to serve this quote from.
Template Type String False No Whether this Quote is rendered with the default templates.
Test mode Bool False No Indicates if the quote is in test mode.
Unique creation key String True No Unique property used for idempotent creates.
Updated by user ID Decimal True No The user that last updated this object. This value is automatically set by HubSpot and may not be modified.
User IDs of all notification followers String True No The user IDs of all users that have clicked follow within the object to opt_in to getting follow notifications.
User IDs of all notification unfollowers String True No The user IDs of all object owners that have clicked unfollow within the object to opt_out of getting follow notifications.
User IDs of all owners String True No The user IDs of all owners of this object.
Owner assigned date Datetime True No The date an owner was assigned to the quote.
Sender company name String False No The name of the company sending this quote.
Sender first name String False No First name of the sender of this quote.
Quote title String False No The title of this quote.
Expiration date Datetime False No The date that this quote expires.
Sender company domain String False No The domain of the company sending this quote.
Sender last name String False No Last name of the sender of this quote.
Comments to buyer String False No Comments to the buyer.
Sender company street address String False No The street address of the company sending this quote.
Sender email String False No Email address of the sender of this quote.
Sender company street address 2 String False No The second line of the street address of the company sending this quote.
Sender phone number String False No Phone number of the sender of this quote.
Terms String False No Any relevant information about pricing* purchasing terms* and_or master agreements.
Logo URL String False No URL to image of the logo displayed on the quote.
Sender company city String False No The city in which the company sending this quote is located.
Sender job title String False No Job title of the sender of this quote.
Sender company state_region String False No The state_region in which the company sending this quote is located.
Space for written signature Bool False No Indicates if the quote document should have a place for a written signature.
Branding color String False No Color value used on the quote document.
Recent Sales Email Replied Date Datetime True No The last time a tracked sales email was replied to for this quote.
Sender company postal code String False No The zip code in which the company sending this quote is located.
Space for written countersignature Bool False No Indicates if the quote document should have a place for a written countersignature.
Quote owner String False No The owner of the quote.
Last Contacted Datetime True No The last timestamp when a call_ email or meeting was logged for this quote.
Last Activity Date Datetime True No The last time a note* call* email* meeting* or task was logged for a quote. This is set automatically by HubSpot based on user actions in the quote record.
Next Activity Date Datetime True No The date of the next upcoming activity for this quote.
Number of times contacted Decimal True No The number of times a call_ email or meeting was logged for this quote.
Number of Sales Activities Decimal True No Number of sales activities for this quote.
Currency String False No Currency code for the quote.
Sender company country String False No The country in which the company sending this quote is located.
HubSpot team String True No The name of the team associated with the owner of the quote.
All owner ids String True No The value of all owner referencing properties for this object_ both default and custom.
Sender company image URL String False No URL to image of the sender company image to be set on the quote.
Time zone String False No Timezone for displaying dates on the quote.
All team ids String True No The team ids corresponding to all owner referencing properties for this object_ both default and custom.
Payment enabled Bool False No Indicates if payment can be collected via the quote link.
All accessible team ids String True No The team ids* including up the team hierarchy* corresponding to all owner referencing properties for this object_ both default and custom.
ESign enabled Bool False No Indicates if esign is enabled for quote.
Associated Deals Decimal True No The number of deals associated with this quote. This is set automatically by HubSpot.
ESign number of signers required Decimal True No Total number of signers required for this quote to be fully signed.
Legacy Quote Template String False No The legacy quote template used to generate a quote. These templates will be sunset on Dec. 12th 2022.
ESign completed signatures Decimal True No Number of completed signatures collected so far.
Quote amount Decimal True No The total due for the quote.
Quote approval status String False No Approval status of the quote.
Quote number String False No Reference number shown on quote document.
Collect shipping address Bool False No Indicates if shipping address should be collected with this quote.

Return to Top

TicketAssociations

Name Type ReadOnly References FilterOnly Description
Id [KEY] Long False Tickets.Id No Tickets ID.
AssociationId [KEY] Long False No ID of the object that this Ticket object is associated with.
Type [KEY] String False No Type of the associated object* which can be a contact* deal etc.
TypeId [KEY] String False AssociationsLabels.TypeId No The numeric ID for the association type. This column is empty for more general associations queries.
Category [KEY] String False AssociationsLabels.Category No The category of the association type for the specified object pair. This column is empty for more generic associations queries.
TypeLabel String True AssociationsLabels.Label No The label assigned to the association type between objects.

Return to Top

TicketPropertiesHistory

Name Type ReadOnly References FilterOnly Description
PropertyName String True No The name of the property.
Value String True No The historical value of the property.
SourceType String True No The method by which the property was changed.
SourceId String True No Additional data related to the source. May not be populated for all sources.
Timestamp Datetime True No Datetime when the property was updated.
TicketId Long True No The ticket identifier.

Return to Top

Tickets

Name Type ReadOnly References FilterOnly Description
Id [KEY] Long False No Unique identifier of the object.
Archived Bool True No Whether the object is archived or not.
CreatedAt Datetime True No When the object was created.
UpdatedAt Datetime True No When the object was last updated.
ItemURL String True No Url that points directly to the HubSpot item.
Close date Datetime False No The date the ticket was closed.
Created by Decimal False No VID of contact that created the ticket.
Create date Datetime False No The date the ticket was created.
First agent email response date Datetime True No The date of the first email response from an agent after a ticket was created.
Business units String False No The business units this record is assigned to.
Assignment Method String False No defines how the Object Assignment is done.
AutoGenerated from thread id Decimal True No Thread that this ticket was automatically created for using ticket rules.
Originating Conversations Message Id String False No Conversations Message Id of the message that originated this ticket.
Conversations originating thread id Decimal False No Thread that this ticket was originally created for.
Created by user ID Decimal True No The user that created this object. This value is automatically set by HubSpot and may not be modified.
HubSpot create date Datetime True No Internal read_only property representing the date the ticket was created in HubSpot.
Custom inbox ID Decimal False No ID of the custom inbox the ticket is associated with.
Date entered 'New Support Pipeline' Datetime True No The date and time when the ticket entered the 'New' stage_ 'Support Pipeline' pipeline.
Date entered 'Waiting on contact Support Pipeline' Datetime True No The date and time when the ticket entered the 'Waiting on contact' stage_ 'Support Pipeline' pipeline.
Date entered 'Waiting on us Support Pipeline' Datetime True No The date and time when the ticket entered the 'Waiting on us' stage_ 'Support Pipeline' pipeline.
Date entered 'Closed Support Pipeline' Datetime True No The date and time when the ticket entered the 'Closed' stage_ 'Support Pipeline' pipeline.
Date exited 'New Support Pipeline' Datetime True No The date and time when the ticket exited the 'New' stage_ 'Support Pipeline' pipeline.
Date exited 'Waiting on contact Support Pipeline' Datetime True No The date and time when the ticket exited the 'Waiting on contact' stage_ 'Support Pipeline' pipeline.
Date exited 'Waiting on us Support Pipeline' Datetime True No The date and time when the ticket exited the 'Waiting on us' stage_ 'Support Pipeline' pipeline.
Date exited 'Closed Support Pipeline' Datetime True No The date and time when the ticket exited the 'Closed' stage_ 'Support Pipeline' pipeline.
External object ids String False No Unique ids corresponding to tickets in a system outside of HubSpot.
Last CES survey comment String True No Last CES survey comment that this contact gave for this ticket.
Last CES survey rating String True No Last CES survey rating that this contact gave for this ticket.
Last CES survey date Datetime True No The time that this contact last submitted a CES survey response. This is automatically set by HubSpot.
File upload String False No Files attached to a support form by a contact.
First agent response date Datetime True No The date of the first response from an agent out of all associated conversations.
In Help Desk Bool False No Is this Ticket rendered in the Help Desk.
Inbox ID Decimal True No Inbox the ticket is in.
Last email activity String True No The type of the last email activity with the contact associated with the ticket.
Last email date Datetime True No The date of the last email activity with the contact associated with the ticket.
Last message received date Datetime True No The date of the last response from the visitor.
Last response date Datetime True No The date of the last response from an agent or bot.
Last activity date Datetime True No The last time a note* call* email* meeting* or task was logged for a ticket. This is updated automatically by HubSpot.
Last contacted date Datetime True No The last time a call* chat conversation* LinkedIn message* postal mail* meeting* sales email* SMS_ or WhatsApp message was logged for a ticket. This is set automatically by HubSpot based on user actions in the ticket record.
Last modified date Datetime True No Most recent timestamp of any property update for this ticket. This includes HubSpot internal properties_ which can be visible or hidden. This property is updated automatically.
Latest message seen by agent ids String True No Agents who have seen the newest message across all conversations associated to the ticket.
Merged ticket ids String True No All ticket ids for this ticket.
Microsoft Teams message ID for this ticket. String True No Microsoft Teams message ID for this ticket.
Next activity date Datetime True No The date of the next upcoming activity for a ticket. This property is set automatically by HubSpot based on user action. This includes logging a future call* email* or meeting using the Log feature_ as well as creating a future task or scheduling a future meeting. This is updated automatically by HubSpot.
Number of Associated Companies Decimal True No Number of companies associated with this ticket.
Number of times contacted Decimal True No The number of times a call* email* or meeting was logged on the ticket.
Record ID Decimal True No The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
Originating channel account String True No First channel account used when conversation was started.
Originating email engagement id Decimal True No Engagement id of the email originating this ticket.
Originating channel type String True No The channel the conversation is in.
Pinned Engagement ID Decimal True No The object ID of the current pinned engagement. This value is automatically set by HubSpot and may not be modified.
Pipeline String False No The pipeline that contains this ticket.
Ticket status String False No The pipeline stage that contains this ticket.
Read Only Object Bool True No Is the object read only.
Resolution String False No The action taken to resolve the ticket.
Thread IDs To Restore String False No Thread IDs from cv_threads used to implement custom cascading delete_restore.
Category String False No Main reason customer reached out for help.
Ticket ID Decimal True No The unique id for this ticket. This unique id is automatically populated by HubSpot.
Priority String False No The level of attention needed on the ticket.
Time in 'New Support Pipeline' Decimal True No The total time in seconds spent by the ticket in the 'New' stage_ 'Support Pipeline' pipeline.
Time in 'Waiting on contact Support Pipeline' Decimal True No The total time in seconds spent by the ticket in the 'Waiting on contact' stage_ 'Support Pipeline' pipeline.
Time in 'Waiting on us Support Pipeline' Decimal True No The total time in seconds spent by the ticket in the 'Waiting on us' stage_ 'Support Pipeline' pipeline.
Time in 'Closed Support Pipeline' Decimal True No The total time in seconds spent by the ticket in the 'Closed' stage_ 'Support Pipeline' pipeline.
Time to Close SLA Due Date Datetime True No When the ticket falls out of Time to Close SLA.
Time to Close SLA Ticket Status String True No Current Time to Close SLA status of ticket.
Time to First Response SLA Due Date Datetime True No When the ticket falls out of the Time to First Response SLA.
Time to First Response SLA Status String True No Current Time to First Response SLA status.
Unique creation key String True No Unique property used for idempotent creates.
Updated by user ID Decimal True No The user that last updated this object. This value is automatically set by HubSpot and may not be modified.
User IDs of all notification followers String True No The user IDs of all users that have clicked follow within the object to opt_in to getting follow notifications.
User IDs of all notification unfollowers String True No The user IDs of all object owners that have clicked unfollow within the object to opt_out of getting follow notifications.
User IDs of all owners String True No The user IDs of all owners of this object.
Owner assigned date Datetime True No The date an owner was assigned to the ticket.
Date of last engagement Datetime True No The date of the last reply or note.
Last customer reply date Datetime True No The date of the last customer response.
NPS follow up String False No Answer to NPS follow up question.
NPS follow up question Decimal False No Specific version of NPS follow up question that was asked.
Conversation NPS score String False No NPS score received after ticket resolution.
Reference to email thread String False No The id of an email thread with ticket conversation.
Time to close Decimal True No The time between when the ticket was created and closed.
Time to first agent email reply Decimal True No The time from the ticket create date to the first agent email reply.
Ticket name String False No Short summary of ticket.
Ticket description String False No Description of the ticket.
Source String False No Channel where ticket was originally submitted.
Reference to sourceSpecific object String False No The id of a connected source object.
Tags String False No Tags associated with your tickets.
Recent Sales Email Replied Date Datetime True No The last time a tracked sales email was replied to for this ticket.
Ticket owner String False No User the ticket is assigned to. Assign additional users to a ticket record by creating a custom user property.
Last Contacted Ticket Note Datetime True No The last timestamp when a call_ email or meeting was logged for this ticket.
Last Activity Date Ticket Note Datetime True No The last time a note* call* email* meeting* or task was logged for a ticket. This is set automatically by HubSpot based on user actions in the ticket record.
Next Activity Date Ticket Note Datetime True No The date of the next upcoming activity for this ticket.
Number of times contacted Ticket Note Decimal True No The number of times a call_ email or meeting was logged for this ticket.
Number of Sales Activities Decimal True No Number of sales activities for this ticket.
HubSpot team String True No Primary team of the ticket owner. This property is set automatically by HubSpot.
All owner ids String True No The value of all owner referencing properties for this object_ both default and custom.
All team ids String True No The team IDs* including up the team hierarchy* corresponding to all owner referencing properties for this object_ both default and custom.
All accessible team ids String True No The team IDs* including up the team hierarchy* corresponding to all owner referencing properties for this object_ both default and custom.

Return to Top