HubSpot Connector Objects (hubspotv4 Schema)

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.

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

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

Name	Type	ReadOnly	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

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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

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

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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

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

Name	Type	ReadOnly	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

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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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

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

Name	Type	ReadOnly	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

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

Name	Type	ReadOnly	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

Name	Type	ReadOnly	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