HubSpot → Google BigQuery: data schema

campaigns

Field name	Type
appId	INTEGER
appName	STRING
contentId	INTEGER
counters	OBJECT
counters.bounce	INTEGER
counters.click	INTEGER
counters.deferred	INTEGER
counters.delivered	INTEGER
counters.dropped	INTEGER
counters.forward	INTEGER
counters.mta_dropped	INTEGER
counters.open	INTEGER
counters.print	INTEGER
counters.processed	INTEGER
counters.reply	INTEGER
counters.sent	INTEGER
counters.spamreport	INTEGER
counters.statuschange	INTEGER
counters.suppressed	INTEGER
counters.unsubscribed	INTEGER
id	INTEGER
lastUpdatedTime	INTEGER
name	STRING
numIncluded	INTEGER
numQueued	INTEGER
subType	STRING
subject	STRING
type	STRING

companies

Field name	Type
archived	BOOLEAN
contacts	ARRAY
createdAt	STRING
id	STRING
properties	OBJECT
properties.about_us	STRING
properties.address	STRING
properties.address2	STRING
properties.affiliate	STRING
properties.an_order_has_not_yet_done_because_	STRING
properties.annualrevenue	NUMBER
properties.b2d	STRING
properties.city	STRING
properties.closedate	STRING
properties.closedate_timestamp_earliest_value_a2a17e6e	STRING
properties.country	STRING
properties.createdate	STRING
properties.days_to_close	NUMBER
properties.description	STRING
properties.description_info__from_sales	STRING
properties.domain	STRING
properties.e_mail	STRING
properties.engagements_last_meeting_booked	STRING
properties.engagements_last_meeting_booked_campaign	STRING
properties.engagements_last_meeting_booked_medium	STRING
properties.engagements_last_meeting_booked_source	STRING
properties.facebook_company_page	STRING
properties.facebookfans	NUMBER
properties.first_contact_createdate	STRING
properties.first_contact_createdate_timestamp_earliest_value_78b50eea	STRING
properties.first_conversion_date	STRING
properties.first_conversion_date_timestamp_earliest_value_61f58f2c	STRING
properties.first_conversion_event_name	STRING
properties.first_conversion_event_name_timestamp_earliest_value_68ddae0a	STRING
properties.first_deal_created_date	STRING
properties.founded_year	STRING
properties.googleplus_page	STRING
properties.hs_additional_domains	STRING
properties.hs_all_accessible_team_ids	STRING
properties.hs_all_assigned_business_unit_ids	STRING
properties.hs_all_owner_ids	STRING
properties.hs_all_team_ids	STRING
properties.hs_analytics_first_timestamp	STRING
properties.hs_analytics_first_timestamp_timestamp_earliest_value_11e3a63a	STRING
properties.hs_analytics_first_touch_converting_campaign	STRING
properties.hs_analytics_first_touch_converting_campaign_timestamp_earliest_value_4757fe10	STRING
properties.hs_analytics_first_visit_timestamp	STRING
properties.hs_analytics_first_visit_timestamp_timestamp_earliest_value_accc17ae	STRING
properties.hs_analytics_last_timestamp	STRING
properties.hs_analytics_last_timestamp_timestamp_latest_value_4e16365a	STRING
properties.hs_analytics_last_touch_converting_campaign	STRING
properties.hs_analytics_last_touch_converting_campaign_timestamp_latest_value_81a64e30	STRING
properties.hs_analytics_last_visit_timestamp	STRING
properties.hs_analytics_last_visit_timestamp_timestamp_latest_value_999a0fce	STRING
properties.hs_analytics_latest_source	STRING
properties.hs_analytics_latest_source_data_1	STRING
properties.hs_analytics_latest_source_data_2	STRING
properties.hs_analytics_latest_source_timestamp	STRING
properties.hs_analytics_num_page_views	NUMBER
properties.hs_analytics_num_page_views_cardinality_sum_e46e85b0	NUMBER
properties.hs_analytics_num_visits	NUMBER
properties.hs_analytics_num_visits_cardinality_sum_53d952a6	NUMBER
properties.hs_analytics_source	STRING
properties.hs_analytics_source_data_1	STRING
properties.hs_analytics_source_data_1_timestamp_earliest_value_9b2f1fa1	STRING
properties.hs_analytics_source_data_2	STRING
properties.hs_analytics_source_data_2_timestamp_earliest_value_9b2f9400	STRING
properties.hs_analytics_source_timestamp_earliest_value_25a3a52c	STRING
properties.hs_avatar_filemanager_key	STRING
properties.hs_created_by_user_id	NUMBER
properties.hs_createdate	STRING
properties.hs_date_entered_customer	STRING
properties.hs_date_entered_evangelist	STRING
properties.hs_date_entered_lead	STRING
properties.hs_date_entered_marketingqualifiedlead	STRING
properties.hs_date_entered_opportunity	STRING
properties.hs_date_entered_other	STRING
properties.hs_date_entered_salesqualifiedlead	STRING
properties.hs_date_entered_subscriber	STRING
properties.hs_date_exited_customer	STRING
properties.hs_date_exited_evangelist	STRING
properties.hs_date_exited_lead	STRING
properties.hs_date_exited_marketingqualifiedlead	STRING
properties.hs_date_exited_opportunity	STRING
properties.hs_date_exited_other	STRING
properties.hs_date_exited_salesqualifiedlead	STRING
properties.hs_date_exited_subscriber	STRING
properties.hs_ideal_customer_profile	STRING
properties.hs_is_target_account	BOOLEAN
properties.hs_last_booked_meeting_date	STRING
properties.hs_last_logged_call_date	STRING
properties.hs_last_open_task_date	STRING
properties.hs_last_sales_activity_date	STRING
properties.hs_last_sales_activity_timestamp	STRING
properties.hs_last_sales_activity_type	STRING
properties.hs_lastmodifieddate	STRING
properties.hs_latest_createdate_of_active_subscriptions	STRING
properties.hs_latest_meeting_activity	STRING
properties.hs_lead_status	STRING
properties.hs_merged_object_ids	STRING
properties.hs_num_blockers	NUMBER
properties.hs_num_child_companies	NUMBER
properties.hs_num_contacts_with_buying_roles	NUMBER
properties.hs_num_decision_makers	NUMBER
properties.hs_num_open_deals	NUMBER
properties.hs_object_id	NUMBER
properties.hs_parent_company_id	NUMBER
properties.hs_pinned_engagement_id	NUMBER
properties.hs_pipeline	STRING
properties.hs_predictivecontactscore_v2_next_max_max_d4e58c1e	NUMBER
properties.hs_read_only	BOOLEAN
properties.hs_sales_email_last_replied	STRING
properties.hs_target_account	STRING
properties.hs_target_account_probability	NUMBER
properties.hs_target_account_recommendation_snooze_time	STRING
properties.hs_target_account_recommendation_state	STRING
properties.hs_time_in_customer	NUMBER
properties.hs_time_in_evangelist	NUMBER
properties.hs_time_in_lead	NUMBER
properties.hs_time_in_marketingqualifiedlead	NUMBER
properties.hs_time_in_opportunity	NUMBER
properties.hs_time_in_other	NUMBER
properties.hs_time_in_salesqualifiedlead	NUMBER
properties.hs_time_in_subscriber	NUMBER
properties.hs_total_deal_value	NUMBER
properties.hs_unique_creation_key	STRING
properties.hs_updated_by_user_id	NUMBER
properties.hs_user_ids_of_all_notification_followers	STRING
properties.hs_user_ids_of_all_notification_unfollowers	STRING
properties.hs_user_ids_of_all_owners	STRING
properties.hubspot_owner_assigneddate	STRING
properties.hubspot_owner_id	STRING
properties.hubspot_team_id	STRING
properties.hubspotscore	NUMBER
properties.industry	STRING
properties.is_public	BOOLEAN
properties.lifecyclestage	STRING
properties.linkedin_company_page	STRING
properties.linkedinbio	STRING
properties.name	STRING
properties.notes_last_contacted	STRING
properties.notes_last_updated	STRING
properties.notes_next_activity_date	STRING
properties.num_associated_contacts	NUMBER
properties.num_associated_deals	NUMBER
properties.num_contacted_notes	NUMBER
properties.num_conversion_events	NUMBER
properties.num_conversion_events_cardinality_sum_d095f14b	NUMBER
properties.num_notes	NUMBER
properties.number_of_stores	NUMBER
properties.numberofemployees	NUMBER
properties.phone	STRING
properties.recent_conversion_date	STRING
properties.recent_conversion_date_timestamp_latest_value_72856da1	STRING
properties.recent_conversion_event_name	STRING
properties.recent_conversion_event_name_timestamp_latest_value_66c820bf	STRING
properties.recent_deal_amount	NUMBER
properties.recent_deal_close_date	STRING
properties.state	STRING
properties.timezone	STRING
properties.total_money_raised	STRING
properties.total_revenue	NUMBER
properties.twitterbio	STRING
properties.twitterfollowers	NUMBER
properties.twitterhandle	STRING
properties.type	STRING
properties.web_technologies	STRING
properties.website	STRING
properties.zip	STRING
updatedAt	STRING

contact_lists

Field name	Type
archived	BOOLEAN
createdAt	INTEGER
deleteable	BOOLEAN
dynamic	BOOLEAN
filters	ARRAY
internalListId	INTEGER
listId	INTEGER
listType	STRING
metaData	OBJECT
metaData.error	STRING
metaData.lastProcessingStateChangeAt	INTEGER
metaData.lastSizeChangeAt	INTEGER
metaData.processing	STRING
metaData.size	INTEGER
name	STRING
parentId	INTEGER
portalId	INTEGER
readOnly	BOOLEAN
updatedAt	INTEGER

contacts

Field name	Type
archived	BOOLEAN
companies	ARRAY
createdAt	STRING
id	STRING
properties	OBJECT
properties.account_creation_date	STRING
properties.additional_info	STRING
properties.address	STRING
properties.affiliate_id	STRING
properties.affiliates_program	STRING
properties.age	NUMBER
properties.an_order_has_not_yet_done_because_	STRING
properties.annualrevenue	STRING
properties.associatedcompanyid	NUMBER
properties.associatedcompanylastupdated	NUMBER
properties.average_days_between_orders	NUMBER
properties.average_order_value	NUMBER
properties.bike_description	STRING
properties.bike_usage	STRING
properties.blog_default_hubspot_blog_6183776915_subscription	STRING
properties.checkout	STRING
properties.city	STRING
properties.client_type	STRING
properties.closedate	STRING
properties.company	STRING
properties.company_size	STRING
properties.complaint_description	STRING
properties.country	STRING
properties.county	STRING
properties.createdate	STRING
properties.currentlyinworkflow	STRING
properties.customer_group	STRING
properties.date_of_birth	STRING
properties.date_of_visit	STRING
properties.days_to_close	NUMBER
properties.degree	STRING
properties.description_info__from_sales	STRING
properties.do_you_currently_own_an_electric_mobility_device_of_any_kind__in_your_household_	STRING
properties.ebike_model_selection	STRING
properties.email	STRING
properties.engagements_last_meeting_booked	STRING
properties.engagements_last_meeting_booked_campaign	STRING
properties.engagements_last_meeting_booked_medium	STRING
properties.engagements_last_meeting_booked_source	STRING
properties.fax	STRING
properties.field_of_study	STRING
properties.first_conversion_date	STRING
properties.first_conversion_event_name	STRING
properties.first_deal_created_date	STRING
properties.first_order_date	STRING
properties.first_order_value	NUMBER
properties.firstname	STRING
properties.followercount	NUMBER
properties.frame_number	STRING
properties.full_name	STRING
properties.ga	STRING
properties.gender	STRING
properties.graduation_date	STRING
properties.hs_additional_emails	STRING
properties.hs_all_accessible_team_ids	STRING
properties.hs_all_contact_vids	STRING
properties.hs_all_owner_ids	STRING
properties.hs_all_team_ids	STRING
properties.hs_analytics_average_page_views	NUMBER
properties.hs_analytics_first_referrer	STRING
properties.hs_analytics_first_timestamp	STRING
properties.hs_analytics_first_touch_converting_campaign	STRING
properties.hs_analytics_first_url	STRING
properties.hs_analytics_first_visit_timestamp	STRING
properties.hs_analytics_last_referrer	STRING
properties.hs_analytics_last_timestamp	STRING
properties.hs_analytics_last_touch_converting_campaign	STRING
properties.hs_analytics_last_url	STRING
properties.hs_analytics_last_visit_timestamp	STRING
properties.hs_analytics_num_event_completions	NUMBER
properties.hs_analytics_num_page_views	NUMBER
properties.hs_analytics_num_visits	NUMBER
properties.hs_analytics_revenue	NUMBER
properties.hs_analytics_source	STRING
properties.hs_analytics_source_data_1	STRING
properties.hs_analytics_source_data_2	STRING
properties.hs_avatar_filemanager_key	STRING
properties.hs_buying_role	STRING
properties.hs_calculated_form_submissions	STRING
properties.hs_calculated_merged_vids	STRING
properties.hs_calculated_mobile_number	STRING
properties.hs_calculated_phone_number	STRING
properties.hs_calculated_phone_number_area_code	STRING
properties.hs_calculated_phone_number_country_code	STRING
properties.hs_calculated_phone_number_region_code	STRING
properties.hs_clicked_linkedin_ad	STRING
properties.hs_content_membership_email_confirmed	BOOLEAN
properties.hs_content_membership_follow_up_enqueued_at	STRING
properties.hs_content_membership_notes	STRING
properties.hs_content_membership_registered_at	STRING
properties.hs_content_membership_registration_domain_sent_to	STRING
properties.hs_content_membership_registration_email_sent_at	STRING
properties.hs_content_membership_status	STRING
properties.hs_conversations_visitor_email	STRING
properties.hs_count_is_unworked	NUMBER
properties.hs_count_is_worked	NUMBER
properties.hs_created_by_conversations	BOOLEAN
properties.hs_created_by_user_id	NUMBER
properties.hs_createdate	STRING
properties.hs_date_entered_customer	STRING
properties.hs_date_entered_evangelist	STRING
properties.hs_date_entered_lead	STRING
properties.hs_date_entered_marketingqualifiedlead	STRING
properties.hs_date_entered_opportunity	STRING
properties.hs_date_entered_other	STRING
properties.hs_date_entered_salesqualifiedlead	STRING
properties.hs_date_entered_subscriber	STRING
properties.hs_date_exited_customer	STRING
properties.hs_date_exited_evangelist	STRING
properties.hs_date_exited_lead	STRING
properties.hs_date_exited_marketingqualifiedlead	STRING
properties.hs_date_exited_opportunity	STRING
properties.hs_date_exited_other	STRING
properties.hs_date_exited_salesqualifiedlead	STRING
properties.hs_date_exited_subscriber	STRING
properties.hs_document_last_revisited	STRING
properties.hs_email_bad_address	BOOLEAN
properties.hs_email_bounce	NUMBER
properties.hs_email_click	NUMBER
properties.hs_email_customer_quarantined_reason	STRING
properties.hs_email_delivered	NUMBER
properties.hs_email_domain	STRING
properties.hs_email_first_click_date	STRING
properties.hs_email_first_open_date	STRING
properties.hs_email_first_reply_date	STRING
properties.hs_email_first_send_date	STRING
properties.hs_email_hard_bounce_reason	STRING
properties.hs_email_hard_bounce_reason_enum	STRING
properties.hs_email_is_ineligible	BOOLEAN
properties.hs_email_last_click_date	STRING
properties.hs_email_last_email_name	STRING
properties.hs_email_last_open_date	STRING
properties.hs_email_last_reply_date	STRING
properties.hs_email_last_send_date	STRING
properties.hs_email_open	NUMBER
properties.hs_email_optout	BOOLEAN
properties.hs_email_optout_12252300	STRING
properties.hs_email_optout_12635413	STRING
properties.hs_email_optout_38192992	STRING
properties.hs_email_optout_5219978	STRING
properties.hs_email_optout_5360075	STRING
properties.hs_email_optout_5361073	STRING
properties.hs_email_optout_6599242	STRING
properties.hs_email_optout_6903142	STRING
properties.hs_email_quarantined	BOOLEAN
properties.hs_email_quarantined_reason	STRING
properties.hs_email_replied	NUMBER
properties.hs_email_sends_since_last_engagement	NUMBER
properties.hs_emailconfirmationstatus	STRING
properties.hs_eventbrite_lastregisteredevent	STRING
properties.hs_eventbrite_lastregisteredeventdate	STRING
properties.hs_facebook_ad_clicked	BOOLEAN
properties.hs_facebook_click_id	STRING
properties.hs_facebookid	STRING
properties.hs_feedback_last_nps_follow_up	STRING
properties.hs_feedback_last_nps_rating	STRING
properties.hs_feedback_last_survey_date	STRING
properties.hs_feedback_show_nps_web_survey	BOOLEAN
properties.hs_first_engagement_object_id	NUMBER
properties.hs_first_subscription_create_date	STRING
properties.hs_google_click_id	STRING
properties.hs_googleplusid	STRING
properties.hs_has_active_subscription	NUMBER
properties.hs_ip_timezone	STRING
properties.hs_is_contact	BOOLEAN
properties.hs_is_unworked	BOOLEAN
properties.hs_language	STRING
properties.hs_last_sales_activity_date	STRING
properties.hs_last_sales_activity_timestamp	STRING
properties.hs_last_sales_activity_type	STRING
properties.hs_lastmodifieddate	STRING
properties.hs_latest_meeting_activity	STRING
properties.hs_latest_sequence_ended_date	STRING
properties.hs_latest_sequence_enrolled	NUMBER
properties.hs_latest_sequence_enrolled_date	STRING
properties.hs_latest_sequence_finished_date	STRING
properties.hs_latest_sequence_unenrolled_date	STRING
properties.hs_latest_source	STRING
properties.hs_latest_source_data_1	STRING
properties.hs_latest_source_data_2	STRING
properties.hs_latest_source_timestamp	STRING
properties.hs_latest_subscription_create_date	STRING
properties.hs_lead_status	STRING
properties.hs_legal_basis	STRING
properties.hs_lifecyclestage_customer_date	STRING
properties.hs_lifecyclestage_evangelist_date	STRING
properties.hs_lifecyclestage_lead_date	STRING
properties.hs_lifecyclestage_marketingqualifiedlead_date	STRING
properties.hs_lifecyclestage_opportunity_date	STRING
properties.hs_lifecyclestage_other_date	STRING
properties.hs_lifecyclestage_salesqualifiedlead_date	STRING
properties.hs_lifecyclestage_subscriber_date	STRING
properties.hs_linkedin_ad_clicked	STRING
properties.hs_linkedinid	STRING
properties.hs_marketable_reason_id	STRING
properties.hs_marketable_reason_type	STRING
properties.hs_marketable_status	STRING
properties.hs_marketable_until_renewal	STRING
properties.hs_merged_object_ids	STRING
properties.hs_object_id	NUMBER
properties.hs_persona	STRING
properties.hs_pinned_engagement_id	NUMBER
properties.hs_pipeline	STRING
properties.hs_read_only	BOOLEAN
properties.hs_sa_first_engagement_date	STRING
properties.hs_sa_first_engagement_descr	STRING
properties.hs_sa_first_engagement_object_type	STRING
properties.hs_sales_email_last_clicked	STRING
properties.hs_sales_email_last_opened	STRING
properties.hs_sales_email_last_replied	STRING
properties.hs_searchable_calculated_international_mobile_number	STRING
properties.hs_searchable_calculated_international_phone_number	STRING
properties.hs_searchable_calculated_mobile_number	STRING
properties.hs_searchable_calculated_phone_number	STRING
properties.hs_sequences_actively_enrolled_count	NUMBER
properties.hs_sequences_enrolled_count	NUMBER
properties.hs_sequences_is_enrolled	BOOLEAN
properties.hs_testpurge	STRING
properties.hs_testrollback	STRING
properties.hs_time_in_customer	NUMBER
properties.hs_time_in_evangelist	NUMBER
properties.hs_time_in_lead	NUMBER
properties.hs_time_in_marketingqualifiedlead	NUMBER
properties.hs_time_in_opportunity	NUMBER
properties.hs_time_in_other	NUMBER
properties.hs_time_in_salesqualifiedlead	NUMBER
properties.hs_time_in_subscriber	NUMBER
properties.hs_time_to_first_engagement	NUMBER
properties.hs_timezone	STRING
properties.hs_twitterid	STRING
properties.hs_unique_creation_key	STRING
properties.hs_updated_by_user_id	NUMBER
properties.hs_user_ids_of_all_notification_followers	STRING
properties.hs_user_ids_of_all_notification_unfollowers	STRING
properties.hs_user_ids_of_all_owners	STRING
properties.hs_whatsapp_phone_number	STRING
properties.hubspot_owner_assigneddate	STRING
properties.hubspot_owner_id	STRING
properties.hubspot_team_id	STRING
properties.hubspotscore	NUMBER
properties.important_factors	STRING
properties.industry	STRING
properties.ip__sync_extension__external_source_account_id	STRING
properties.ip__sync_extension__external_source_app_id	STRING
properties.ip_city	STRING
properties.ip_country	STRING
properties.ip_country_code	STRING
properties.ip_latlon	STRING
properties.ip_state	STRING
properties.ip_state_code	STRING
properties.ip_zipcode	STRING
properties.job_function	STRING
properties.jobtitle	STRING
properties.kicstarter_baker	STRING
properties.kloutscoregeneral	NUMBER
properties.language	STRING
properties.last_order_date	STRING
properties.last_order_order_number	STRING
properties.last_order_shipment_carrier	STRING
properties.last_order_shipment_date	STRING
properties.last_order_status	STRING
properties.last_order_tracking_number	STRING
properties.last_order_tracking_url	STRING
properties.last_order_value	NUMBER
properties.lastmodifieddate	STRING
properties.lastname	STRING
properties.lifecyclestage	STRING
properties.linkedinbio	STRING
properties.linkedinconnections	NUMBER
properties.logistic_owner	STRING
properties.logistics_status	STRING
properties.marital_status	STRING
properties.marketing_mail	STRING
properties.media_name	STRING
properties.message	STRING
properties.military_status	STRING
properties.mobilephone	STRING
properties.monetary_rating	STRING
properties.notes_last_contacted	STRING
properties.notes_last_updated	STRING
properties.notes_next_activity_date	STRING
properties.num_associated_deals	NUMBER
properties.num_contacted_notes	NUMBER
properties.num_conversion_events	NUMBER
properties.num_notes	NUMBER
properties.num_unique_conversion_events	NUMBER
properties.number_of_officers	NUMBER
properties.number_of_shops	NUMBER
properties.numemployees	STRING
properties.order_frequency_rating	STRING
properties.order_recency_rating	STRING
properties.partners_program_status	STRING
properties.phone	STRING
properties.phone_activity	STRING
properties.photo	STRING
properties.police_department	STRING
properties.purpose_of_bike_enquiry	STRING
properties.question_perfect_bike	STRING
properties.question_risk_factors	STRING
properties.recent_conversion_date	STRING
properties.recent_conversion_event_name	STRING
properties.recent_deal_amount	NUMBER
properties.recent_deal_close_date	STRING
properties.relationship_status	STRING
properties.sales_category	STRING
properties.sales_owner	STRING
properties.sales_person_name	STRING
properties.salutation	STRING
properties.school	STRING
properties.seniority	STRING
properties.signed_contract_date	STRING
properties.social_contact	STRING
properties.start_date	STRING
properties.state	STRING
properties.support_owner	STRING
properties.support_status	STRING
properties.surveymonkeyeventlastupdated	NUMBER
properties.total_number_of_orders	NUMBER
properties.total_revenue	NUMBER
properties.total_value_of_orders	NUMBER
properties.twitterbio	STRING
properties.twitterhandle	STRING
properties.twitterprofilephoto	STRING
properties.unsubscribe	STRING
properties.usa_state	STRING
properties.webinareventlastupdated	NUMBER
properties.website	STRING
properties.what_brings_you_to_electrify_expo_	STRING
properties.when_do_you_plan_on_purchasing___lectric_vehicle__of_any_kind__	STRING
properties.why_can_t_be_our_dealer	STRING
properties.work_email	STRING
properties.www	STRING
properties.zip	STRING
updatedAt	STRING

contacts_list_memberships

Field name	Type
canonical-vid	INTEGER
internal-list-id	INTEGER
is-member	BOOLEAN
static-list-id	INTEGER
timestamp	INTEGER
vid	INTEGER

deal_pipelines

Field name	Type
active	BOOLEAN
createdAt	INTEGER
default	BOOLEAN
displayOrder	INTEGER
label	STRING
objectType	STRING
objectTypeId	STRING
pipelineId	STRING
stages	ARRAY
updatedAt	INTEGER

deals

Field name	Type
archived	BOOLEAN
companies	ARRAY
contacts	ARRAY
createdAt	STRING
id	STRING
line_items	ARRAY
properties	OBJECT
properties.amount	NUMBER
properties.amount_in_home_currency	NUMBER
properties.closed_lost_reason	STRING
properties.closed_won_reason	STRING
properties.closedate	STRING
properties.createdate	STRING
properties.days_to_close	NUMBER
properties.dealname	STRING
properties.dealstage	STRING
properties.dealtype	STRING
properties.description	STRING
properties.engagements_last_meeting_booked	STRING
properties.engagements_last_meeting_booked_campaign	STRING
properties.engagements_last_meeting_booked_medium	STRING
properties.engagements_last_meeting_booked_source	STRING
properties.hs_acv	NUMBER
properties.hs_all_accessible_team_ids	STRING
properties.hs_all_assigned_business_unit_ids	STRING
properties.hs_all_collaborator_owner_ids	STRING
properties.hs_all_deal_split_owner_ids	STRING
properties.hs_all_owner_ids	STRING
properties.hs_all_team_ids	STRING
properties.hs_analytics_latest_source	STRING
properties.hs_analytics_latest_source_company	STRING
properties.hs_analytics_latest_source_contact	STRING
properties.hs_analytics_latest_source_data_1	STRING
properties.hs_analytics_latest_source_data_1_company	STRING
properties.hs_analytics_latest_source_data_1_contact	STRING
properties.hs_analytics_latest_source_data_2	STRING
properties.hs_analytics_latest_source_data_2_company	STRING
properties.hs_analytics_latest_source_data_2_contact	STRING
properties.hs_analytics_latest_source_timestamp	STRING
properties.hs_analytics_latest_source_timestamp_company	STRING
properties.hs_analytics_latest_source_timestamp_contact	STRING
properties.hs_analytics_source	STRING
properties.hs_analytics_source_data_1	STRING
properties.hs_analytics_source_data_2	STRING
properties.hs_arr	NUMBER
properties.hs_campaign	STRING
properties.hs_closed_amount	NUMBER
properties.hs_closed_amount_in_home_currency	NUMBER
properties.hs_created_by_user_id	NUMBER
properties.hs_createdate	STRING
properties.hs_date_entered_13857944	STRING
properties.hs_date_entered_13857945	STRING
properties.hs_date_entered_13857946	STRING
properties.hs_date_entered_13857947	STRING
properties.hs_date_entered_13857948	STRING
properties.hs_date_entered_13857949	STRING
properties.hs_date_entered_13857950	STRING
properties.hs_date_entered_13858420	STRING
properties.hs_date_entered_45291401	STRING
properties.hs_date_entered_45291402	STRING
properties.hs_date_entered_45291403	STRING
properties.hs_date_entered_45291404	STRING
properties.hs_date_entered_45291406	STRING
properties.hs_date_entered_45291407	STRING
properties.hs_date_entered_appointmentscheduled	STRING
properties.hs_date_entered_closedlost	STRING
properties.hs_date_entered_closedwon	STRING
properties.hs_date_entered_contractsent	STRING
properties.hs_date_entered_decisionmakerboughtin	STRING
properties.hs_date_entered_presentationscheduled	STRING
properties.hs_date_entered_qualifiedtobuy	STRING
properties.hs_date_exited_13857944	STRING
properties.hs_date_exited_13857945	STRING
properties.hs_date_exited_13857946	STRING
properties.hs_date_exited_13857947	STRING
properties.hs_date_exited_13857948	STRING
properties.hs_date_exited_13857949	STRING
properties.hs_date_exited_13857950	STRING
properties.hs_date_exited_13858420	STRING
properties.hs_date_exited_45291401	STRING
properties.hs_date_exited_45291402	STRING
properties.hs_date_exited_45291403	STRING
properties.hs_date_exited_45291404	STRING
properties.hs_date_exited_45291406	STRING
properties.hs_date_exited_45291407	STRING
properties.hs_date_exited_appointmentscheduled	STRING
properties.hs_date_exited_closedlost	STRING
properties.hs_date_exited_closedwon	STRING
properties.hs_date_exited_contractsent	STRING
properties.hs_date_exited_decisionmakerboughtin	STRING
properties.hs_date_exited_presentationscheduled	STRING
properties.hs_date_exited_qualifiedtobuy	STRING
properties.hs_deal_amount_calculation_preference	STRING
properties.hs_deal_stage_probability	NUMBER
properties.hs_deal_stage_probability_shadow	NUMBER
properties.hs_exchange_rate	NUMBER
properties.hs_forecast_amount	NUMBER
properties.hs_forecast_probability	NUMBER
properties.hs_is_closed	BOOLEAN
properties.hs_is_closed_won	BOOLEAN
properties.hs_lastmodifieddate	STRING
properties.hs_latest_meeting_activity	STRING
properties.hs_likelihood_to_close	NUMBER
properties.hs_line_item_global_term_hs_discount_percentage	STRING
properties.hs_line_item_global_term_hs_discount_percentage_enabled	BOOLEAN
properties.hs_line_item_global_term_hs_recurring_billing_period	STRING
properties.hs_line_item_global_term_hs_recurring_billing_period_enabled	BOOLEAN
properties.hs_line_item_global_term_hs_recurring_billing_start_date	STRING
properties.hs_line_item_global_term_hs_recurring_billing_start_date_enabled	BOOLEAN
properties.hs_line_item_global_term_recurringbillingfrequency	STRING
properties.hs_line_item_global_term_recurringbillingfrequency_enabled	BOOLEAN
properties.hs_manual_forecast_category	STRING
properties.hs_merged_object_ids	STRING
properties.hs_mrr	NUMBER
properties.hs_next_step	STRING
properties.hs_num_target_accounts	NUMBER
properties.hs_object_id	NUMBER
properties.hs_pinned_engagement_id	NUMBER
properties.hs_predicted_amount	NUMBER
properties.hs_predicted_amount_in_home_currency	NUMBER
properties.hs_priority	STRING
properties.hs_projected_amount	NUMBER
properties.hs_projected_amount_in_home_currency	NUMBER
properties.hs_read_only	BOOLEAN
properties.hs_sales_email_last_replied	STRING
properties.hs_tcv	NUMBER
properties.hs_time_in_13857944	NUMBER
properties.hs_time_in_13857945	NUMBER
properties.hs_time_in_13857946	NUMBER
properties.hs_time_in_13857947	NUMBER
properties.hs_time_in_13857948	NUMBER
properties.hs_time_in_13857949	NUMBER
properties.hs_time_in_13857950	NUMBER
properties.hs_time_in_13858420	NUMBER
properties.hs_time_in_45291401	NUMBER
properties.hs_time_in_45291402	NUMBER
properties.hs_time_in_45291403	NUMBER
properties.hs_time_in_45291404	NUMBER
properties.hs_time_in_45291406	NUMBER
properties.hs_time_in_45291407	NUMBER
properties.hs_time_in_appointmentscheduled	NUMBER
properties.hs_time_in_closedlost	NUMBER
properties.hs_time_in_closedwon	NUMBER
properties.hs_time_in_contractsent	NUMBER
properties.hs_time_in_decisionmakerboughtin	NUMBER
properties.hs_time_in_presentationscheduled	NUMBER
properties.hs_time_in_qualifiedtobuy	NUMBER
properties.hs_unique_creation_key	STRING
properties.hs_updated_by_user_id	NUMBER
properties.hs_user_ids_of_all_notification_followers	STRING
properties.hs_user_ids_of_all_notification_unfollowers	STRING
properties.hs_user_ids_of_all_owners	STRING
properties.hubspot_owner_assigneddate	STRING
properties.hubspot_owner_id	STRING
properties.hubspot_team_id	STRING
properties.ip__sync_extension__external_source_account_id	STRING
properties.ip__sync_extension__external_source_app_id	STRING
properties.notes_last_contacted	STRING
properties.notes_last_updated	STRING
properties.notes_next_activity_date	STRING
properties.num_associated_contacts	NUMBER
properties.num_contacted_notes	NUMBER
properties.num_notes	NUMBER
properties.pipeline	STRING
properties.recurring_revenue_amount	NUMBER
properties.recurring_revenue_deal_type	STRING
properties.recurring_revenue_inactive_date	STRING
properties.recurring_revenue_inactive_reason	STRING
updatedAt	STRING

email_events

Field name	Type
appId	INTEGER
appName	STRING
attempt	INTEGER
bounced	BOOLEAN
browser	OBJECT
browser.family	STRING
browser.name	STRING
browser.producer	STRING
browser.producerUrl	STRING
browser.type	STRING
browser.url	STRING
browser.version	ARRAY
category	STRING
causedBy	OBJECT
causedBy.created	INTEGER
causedBy.id	STRING
created	INTEGER
deviceType	STRING
dropMessage	STRING
dropReason	STRING
duration	INTEGER
emailCampaignGroupId	INTEGER
emailCampaignId	INTEGER
filteredEvent	BOOLEAN
from	STRING
hmid	STRING
id	STRING
ipAddress	STRING
linkId	INTEGER
location	OBJECT
location.city	STRING
location.country	STRING
location.latitude	NUMBER
location.longitude	NUMBER
location.state	STRING
location.zipcode	STRING
obsoletedBy	OBJECT
obsoletedBy.created	INTEGER
obsoletedBy.id	STRING
portalId	INTEGER
portalSubscriptionStatus	STRING
recipient	STRING
referer	STRING
replyTo	ARRAY
requestedBy	STRING
requestedByUserId	INTEGER
response	STRING
sentBy	OBJECT
sentBy.created	INTEGER
sentBy.id	STRING
smtpId	STRING
source	STRING
sourceId	STRING
status	STRING
subject	STRING
type	STRING
url	STRING
userAgent	STRING

engagements

Field name	Type
active	BOOLEAN
activityType	STRING
allAccessibleTeamIds	ARRAY
associations	OBJECT
associations.companyIds	ARRAY
associations.contactIds	ARRAY
associations.dealIds	ARRAY
associations.ownerIds	ARRAY
associations.ticketIds	ARRAY
associations.workflowIds	ARRAY
attachments	ARRAY
bodyPreview	STRING
bodyPreviewHtml	STRING
bodyPreviewIsTruncated	BOOLEAN
createdAt	INTEGER
createdBy	INTEGER
gdprDeleted	BOOLEAN
id	INTEGER
lastUpdated	INTEGER
metadata	OBJECT
metadata.attachedVideoOpened	BOOLEAN
metadata.attachedVideoWatched	BOOLEAN
metadata.bcc	ARRAY
metadata.body	STRING
metadata.calleeObjectId	INTEGER
metadata.calleeObjectType	STRING
metadata.cc	ARRAY
metadata.completionDate	INTEGER
metadata.disposition	STRING
metadata.durationMilliseconds	INTEGER
metadata.endTime	INTEGER
metadata.errorMessage	STRING
metadata.externalAccountId	STRING
metadata.externalId	STRING
metadata.externalUrl	STRING
metadata.facsimileSendId	STRING
metadata.forObjectType	STRING
metadata.from	OBJECT
metadata.from.email	STRING
metadata.from.firstName	STRING
metadata.from.lastName	STRING
metadata.from.raw	STRING
metadata.fromNumber	STRING
metadata.html	STRING
metadata.isAllDay	BOOLEAN
metadata.loggedFrom	STRING
metadata.mediaProcessingStatus	STRING
metadata.messageId	STRING
metadata.postSendStatus	STRING
metadata.priority	STRING
metadata.recipientDropReasons	STRING
metadata.recordingUrl	STRING
metadata.reminders	ARRAY
metadata.sendDefaultReminder	BOOLEAN
metadata.sender	OBJECT
metadata.sender.email	STRING
metadata.sentVia	STRING
metadata.sequenceStepOrder	INTEGER
metadata.source	STRING
metadata.sourceId	STRING
metadata.startTime	INTEGER
metadata.status	STRING
metadata.subject	STRING
metadata.taskType	STRING
metadata.text	STRING
metadata.threadId	STRING,INTEGER
metadata.title	STRING
metadata.to	ARRAY
metadata.toNumber	STRING
metadata.trackerKey	STRING
metadata.unknownVisitorConversation	BOOLEAN
modifiedBy	INTEGER
ownerId	INTEGER
portalId	INTEGER
source	STRING
sourceId	STRING
teamId	INTEGER
timestamp	INTEGER
type	STRING
uid	STRING

engagements_calls

Field name	Type
archived	BOOLEAN
companies	ARRAY
contacts	ARRAY
createdAt	STRING
deals	ARRAY
id	STRING
properties	OBJECT
properties.hs_activity_type	STRING
properties.hs_all_accessible_team_ids	STRING
properties.hs_all_assigned_business_unit_ids	STRING
properties.hs_all_owner_ids	STRING
properties.hs_all_team_ids	STRING
properties.hs_at_mentioned_owner_ids	STRING
properties.hs_attachment_ids	STRING
properties.hs_body_preview	STRING
properties.hs_body_preview_html	STRING
properties.hs_body_preview_is_truncated	BOOLEAN
properties.hs_call_app_id	NUMBER
properties.hs_call_authed_url_provider	STRING
properties.hs_call_body	STRING
properties.hs_call_callee_object_id	NUMBER
properties.hs_call_callee_object_type	STRING
properties.hs_call_direction	STRING
properties.hs_call_disposition	STRING
properties.hs_call_duration	NUMBER
properties.hs_call_external_account_id	STRING
properties.hs_call_external_id	STRING
properties.hs_call_from_number	STRING
properties.hs_call_has_transcript	BOOLEAN
properties.hs_call_recording_url	STRING
properties.hs_call_source	STRING
properties.hs_call_status	STRING
properties.hs_call_title	STRING
properties.hs_call_to_number	STRING
properties.hs_call_transcript_tracked_terms	STRING
properties.hs_call_transcription_id	NUMBER
properties.hs_call_video_recording_url	STRING
properties.hs_call_zoom_meeting_uuid	STRING
properties.hs_calls_service_call_id	NUMBER
properties.hs_created_by	NUMBER
properties.hs_created_by_user_id	NUMBER
properties.hs_createdate	STRING
properties.hs_engagement_source	STRING
properties.hs_engagement_source_id	STRING
properties.hs_follow_up_action	STRING
properties.hs_gdpr_deleted	BOOLEAN
properties.hs_lastmodifieddate	STRING
properties.hs_merged_object_ids	STRING
properties.hs_modified_by	NUMBER
properties.hs_object_id	NUMBER
properties.hs_product_name	STRING
properties.hs_queue_membership_ids	STRING
properties.hs_read_only	BOOLEAN
properties.hs_timestamp	STRING
properties.hs_unique_creation_key	STRING
properties.hs_unique_id	STRING
properties.hs_unknown_visitor_conversation	BOOLEAN
properties.hs_updated_by_user_id	NUMBER
properties.hs_user_ids_of_all_notification_followers	STRING
properties.hs_user_ids_of_all_notification_unfollowers	STRING
properties.hs_user_ids_of_all_owners	STRING
properties.hubspot_owner_assigneddate	STRING
properties.hubspot_owner_id	STRING
properties.hubspot_team_id	STRING
tickets	ARRAY
updatedAt	STRING

engagements_emails

Field name	Type
archived	BOOLEAN
companies	ARRAY
contacts	ARRAY
createdAt	STRING
deals	ARRAY
id	STRING
properties	OBJECT
properties.hs_all_accessible_team_ids	STRING
properties.hs_all_assigned_business_unit_ids	STRING
properties.hs_all_owner_ids	STRING
properties.hs_all_team_ids	STRING
properties.hs_at_mentioned_owner_ids	STRING
properties.hs_attachment_ids	STRING
properties.hs_body_preview	STRING
properties.hs_body_preview_html	STRING
properties.hs_body_preview_is_truncated	BOOLEAN
properties.hs_created_by	STRING
properties.hs_created_by_user_id	NUMBER
properties.hs_createdate	STRING
properties.hs_direction_and_unique_id	STRING
properties.hs_email_attached_video_id	STRING
properties.hs_email_attached_video_name	STRING
properties.hs_email_attached_video_opened	BOOLEAN
properties.hs_email_attached_video_watched	BOOLEAN
properties.hs_email_bcc_email	STRING
properties.hs_email_bcc_firstname	STRING
properties.hs_email_bcc_lastname	STRING
properties.hs_email_bcc_raw	STRING
properties.hs_email_bounce_error_detail_message	STRING
properties.hs_email_bounce_error_detail_status_code	NUMBER
properties.hs_email_cc_email	STRING
properties.hs_email_cc_firstname	STRING
properties.hs_email_cc_lastname	STRING
properties.hs_email_cc_raw	STRING
properties.hs_email_direction	STRING
properties.hs_email_encoded_email_associations_request	STRING
properties.hs_email_error_message	STRING
properties.hs_email_facsimile_send_id	STRING
properties.hs_email_from_email	STRING
properties.hs_email_from_firstname	STRING
properties.hs_email_from_lastname	STRING
properties.hs_email_from_raw	STRING
properties.hs_email_headers	STRING
properties.hs_email_html	STRING
properties.hs_email_logged_from	STRING
properties.hs_email_media_processing_status	STRING
properties.hs_email_member_of_forwarded_subthread	BOOLEAN
properties.hs_email_message_id	STRING
properties.hs_email_migrated_via_portal_data_migration	STRING
properties.hs_email_pending_inline_image_ids	STRING
properties.hs_email_post_send_status	STRING
properties.hs_email_recipient_drop_reasons	STRING
properties.hs_email_send_event_id	STRING
properties.hs_email_send_event_id_created	STRING
properties.hs_email_sender_email	STRING
properties.hs_email_sender_firstname	STRING
properties.hs_email_sender_lastname	STRING
properties.hs_email_sender_raw	STRING
properties.hs_email_sent_via	STRING
properties.hs_email_status	STRING
properties.hs_email_subject	STRING
properties.hs_email_text	STRING
properties.hs_email_thread_id	STRING
properties.hs_email_to_email	STRING
properties.hs_email_to_firstname	STRING
properties.hs_email_to_lastname	STRING
properties.hs_email_to_raw	STRING
properties.hs_email_tracker_key	STRING
properties.hs_email_validation_skipped	STRING
properties.hs_engagement_source	STRING
properties.hs_engagement_source_id	STRING
properties.hs_follow_up_action	STRING
properties.hs_gdpr_deleted	BOOLEAN
properties.hs_lastmodifieddate	STRING
properties.hs_merged_object_ids	STRING
properties.hs_modified_by	STRING
properties.hs_object_id	NUMBER
properties.hs_product_name	STRING
properties.hs_queue_membership_ids	STRING
properties.hs_read_only	BOOLEAN
properties.hs_timestamp	STRING
properties.hs_unique_creation_key	STRING
properties.hs_unique_id	STRING
properties.hs_updated_by_user_id	NUMBER
properties.hs_user_ids_of_all_notification_followers	STRING
properties.hs_user_ids_of_all_notification_unfollowers	STRING
properties.hs_user_ids_of_all_owners	STRING
properties.hubspot_owner_assigneddate	STRING
properties.hubspot_owner_id	STRING
properties.hubspot_team_id	STRING
tickets	ARRAY
updatedAt	STRING

engagements_meetings

Field name	Type
archived	BOOLEAN
companies	ARRAY
contacts	ARRAY
createdAt	STRING
deals	ARRAY
id	STRING
properties	OBJECT
properties.hs_activity_type	STRING
properties.hs_all_accessible_team_ids	STRING
properties.hs_all_assigned_business_unit_ids	STRING
properties.hs_all_owner_ids	STRING
properties.hs_all_team_ids	STRING
properties.hs_at_mentioned_owner_ids	STRING
properties.hs_attachment_ids	STRING
properties.hs_attendee_owner_ids	STRING
properties.hs_body_preview	STRING
properties.hs_body_preview_html	STRING
properties.hs_body_preview_is_truncated	BOOLEAN
properties.hs_created_by	NUMBER
properties.hs_created_by_user_id	NUMBER
properties.hs_createdate	STRING
properties.hs_engagement_source	STRING
properties.hs_engagement_source_id	STRING
properties.hs_follow_up_action	STRING
properties.hs_gdpr_deleted	BOOLEAN
properties.hs_i_cal_uid	STRING
properties.hs_internal_meeting_notes	STRING
properties.hs_lastmodifieddate	STRING
properties.hs_meeting_body	STRING
properties.hs_meeting_calendar_event_hash	STRING
properties.hs_meeting_change_id	STRING
properties.hs_meeting_created_from_link_id	STRING
properties.hs_meeting_end_time	STRING
properties.hs_meeting_external_url	STRING
properties.hs_meeting_location	STRING
properties.hs_meeting_location_type	STRING
properties.hs_meeting_outcome	STRING
properties.hs_meeting_payments_session_id	STRING
properties.hs_meeting_pre_meeting_prospect_reminders	STRING
properties.hs_meeting_source	STRING
properties.hs_meeting_source_id	STRING
properties.hs_meeting_start_time	STRING
properties.hs_meeting_title	STRING
properties.hs_meeting_web_conference_meeting_id	STRING
properties.hs_merged_object_ids	STRING
properties.hs_modified_by	NUMBER
properties.hs_object_id	NUMBER
properties.hs_product_name	STRING
properties.hs_queue_membership_ids	STRING
properties.hs_read_only	BOOLEAN
properties.hs_scheduled_tasks	STRING
properties.hs_timestamp	STRING
properties.hs_unique_creation_key	STRING
properties.hs_unique_id	STRING
properties.hs_updated_by_user_id	NUMBER
properties.hs_user_ids_of_all_notification_followers	STRING
properties.hs_user_ids_of_all_notification_unfollowers	STRING
properties.hs_user_ids_of_all_owners	STRING
properties.hubspot_owner_assigneddate	STRING
properties.hubspot_owner_id	STRING
properties.hubspot_team_id	STRING
tickets	ARRAY
updatedAt	STRING

engagements_notes

Field name	Type
archived	BOOLEAN
companies	ARRAY
contacts	ARRAY
createdAt	STRING
deals	ARRAY
id	STRING
properties	OBJECT
properties.hs_all_accessible_team_ids	STRING
properties.hs_all_assigned_business_unit_ids	STRING
properties.hs_all_owner_ids	STRING
properties.hs_all_team_ids	STRING
properties.hs_at_mentioned_owner_ids	STRING
properties.hs_attachment_ids	STRING
properties.hs_body_preview	STRING
properties.hs_body_preview_html	STRING
properties.hs_body_preview_is_truncated	BOOLEAN
properties.hs_created_by	NUMBER
properties.hs_created_by_user_id	NUMBER
properties.hs_createdate	STRING
properties.hs_engagement_source	STRING
properties.hs_engagement_source_id	STRING
properties.hs_follow_up_action	STRING
properties.hs_gdpr_deleted	BOOLEAN
properties.hs_lastmodifieddate	STRING
properties.hs_merged_object_ids	STRING
properties.hs_modified_by	NUMBER
properties.hs_note_body	STRING
properties.hs_object_id	NUMBER
properties.hs_product_name	STRING
properties.hs_queue_membership_ids	STRING
properties.hs_read_only	BOOLEAN
properties.hs_timestamp	STRING
properties.hs_unique_creation_key	STRING
properties.hs_unique_id	STRING
properties.hs_updated_by_user_id	NUMBER
properties.hs_user_ids_of_all_notification_followers	STRING
properties.hs_user_ids_of_all_notification_unfollowers	STRING
properties.hs_user_ids_of_all_owners	STRING
properties.hubspot_owner_assigneddate	STRING
properties.hubspot_owner_id	STRING
properties.hubspot_team_id	STRING
tickets	ARRAY
updatedAt	STRING

engagements_tasks

Field name	Type
archived	BOOLEAN
companies	ARRAY
contacts	ARRAY
createdAt	STRING
deals	ARRAY
id	STRING
properties	OBJECT
properties.hs_all_accessible_team_ids	STRING
properties.hs_all_assigned_business_unit_ids	STRING
properties.hs_all_owner_ids	STRING
properties.hs_all_team_ids	STRING
properties.hs_at_mentioned_owner_ids	STRING
properties.hs_attachment_ids	STRING
properties.hs_body_preview	STRING
properties.hs_body_preview_html	STRING
properties.hs_body_preview_is_truncated	BOOLEAN
properties.hs_calendar_event_id	STRING
properties.hs_created_by	NUMBER
properties.hs_created_by_user_id	NUMBER
properties.hs_createdate	STRING
properties.hs_engagement_source	STRING
properties.hs_engagement_source_id	STRING
properties.hs_follow_up_action	STRING
properties.hs_gdpr_deleted	BOOLEAN
properties.hs_lastmodifieddate	STRING
properties.hs_merged_object_ids	STRING
properties.hs_modified_by	NUMBER
properties.hs_msteams_message_id	STRING
properties.hs_num_associated_companies	NUMBER
properties.hs_num_associated_contacts	NUMBER
properties.hs_num_associated_deals	NUMBER
properties.hs_num_associated_queue_objects	NUMBER
properties.hs_num_associated_tickets	NUMBER
properties.hs_object_id	NUMBER
properties.hs_product_name	STRING
properties.hs_queue_membership_ids	STRING
properties.hs_read_only	BOOLEAN
properties.hs_repeat_status	STRING
properties.hs_scheduled_tasks	STRING
properties.hs_task_body	STRING
properties.hs_task_completion_date	STRING
properties.hs_task_contact_timezone	STRING
properties.hs_task_for_object_type	STRING
properties.hs_task_is_all_day	BOOLEAN
properties.hs_task_last_contact_outreach	STRING
properties.hs_task_last_sales_activity_timestamp	STRING
properties.hs_task_priority	STRING
properties.hs_task_probability_to_complete	NUMBER
properties.hs_task_relative_reminders	STRING
properties.hs_task_reminders	STRING
properties.hs_task_repeat_interval	STRING
properties.hs_task_send_default_reminder	BOOLEAN
properties.hs_task_sequence_enrollment_active	BOOLEAN
properties.hs_task_sequence_step_enrollment_id	STRING
properties.hs_task_sequence_step_order	NUMBER
properties.hs_task_status	STRING
properties.hs_task_subject	STRING
properties.hs_task_template_id	NUMBER
properties.hs_task_type	STRING
properties.hs_timestamp	STRING
properties.hs_unique_creation_key	STRING
properties.hs_unique_id	STRING
properties.hs_updated_by_user_id	NUMBER
properties.hs_user_ids_of_all_notification_followers	STRING
properties.hs_user_ids_of_all_notification_unfollowers	STRING
properties.hs_user_ids_of_all_owners	STRING
properties.hubspot_owner_assigneddate	STRING
properties.hubspot_owner_id	STRING
properties.hubspot_team_id	STRING
tickets	ARRAY
updatedAt	STRING

forms

Field name	Type
archived	BOOLEAN
configuration	OBJECT
configuration.allowLinkToResetKnownValues	BOOLEAN
configuration.archivable	BOOLEAN
configuration.cloneable	BOOLEAN
configuration.createNewContactForNewEmail	BOOLEAN
configuration.editable	BOOLEAN
configuration.language	STRING
configuration.notifyContactOwner	BOOLEAN
configuration.notifyRecipients	ARRAY
configuration.postSubmitAction	OBJECT
configuration.postSubmitAction.type	STRING
configuration.postSubmitAction.value	STRING
configuration.prePopulateKnownValues	BOOLEAN
configuration.recaptchaEnabled	BOOLEAN
createdAt	STRING
deletedAt	STRING
displayOptions	OBJECT
displayOptions.renderRawHtml	BOOLEAN
displayOptions.style	OBJECT
displayOptions.style.backgroundWidth	STRING
displayOptions.style.fontFamily	STRING
displayOptions.style.helpTextColor	STRING
displayOptions.style.helpTextSize	STRING
displayOptions.style.labelTextColor	STRING
displayOptions.style.labelTextSize	STRING
displayOptions.style.legalConsentTextColor	STRING
displayOptions.style.legalConsentTextSize	STRING
displayOptions.style.submitAlignment	STRING
displayOptions.style.submitColor	STRING
displayOptions.style.submitFontColor	STRING
displayOptions.style.submitSize	STRING
displayOptions.submitButtonText	STRING
displayOptions.theme	STRING
fieldGroups	ARRAY
id	STRING
legalConsentOptions	OBJECT
name	STRING
properties	OBJECT
properties.hs_all_accessible_team_ids	STRING
properties.hs_all_assigned_business_unit_ids	STRING
properties.hs_all_owner_ids	STRING
properties.hs_all_team_ids	STRING
properties.hs_cloneable	STRING
properties.hs_created_at	STRING
properties.hs_created_by_user_id	NUMBER
properties.hs_createdate	STRING
properties.hs_deletable	STRING
properties.hs_editable	STRING
properties.hs_folder_id	NUMBER
properties.hs_form_id	STRING
properties.hs_form_interactions	NUMBER
properties.hs_form_submissions	NUMBER
properties.hs_form_submissions_per_form_interaction	NUMBER
properties.hs_form_submissions_per_form_view	NUMBER
properties.hs_form_submissions_per_page_view	NUMBER
properties.hs_form_submissions_per_pop_up_cta_view	NUMBER
properties.hs_form_type	STRING
properties.hs_form_views	NUMBER
properties.hs_lastmodifieddate	STRING
properties.hs_marketing_campaign_guid	STRING
properties.hs_merged_object_ids	STRING
properties.hs_name	STRING
properties.hs_object_id	NUMBER
properties.hs_page_views	NUMBER
properties.hs_pop_up_cta_views	NUMBER
properties.hs_read_only	BOOLEAN
properties.hs_status	STRING
properties.hs_unique_creation_key	STRING
properties.hs_updated_by_user_id	NUMBER
properties.hs_user_ids_of_all_notification_followers	STRING
properties.hs_user_ids_of_all_notification_unfollowers	STRING
properties.hs_user_ids_of_all_owners	STRING
properties.hubspot_owner_assigneddate	STRING
properties.hubspot_owner_id	STRING
properties.hubspot_team_id	STRING
updatedAt	STRING

form_submissions

Field name	Type
formId	STRING
pageUrl	STRING
submittedAt	INTEGER
updatedAt	INTEGER
values	ARRAY

line_items

Field name	Type
archived	BOOLEAN
createdAt	STRING
id	STRING
properties	OBJECT
properties.amount	NUMBER
properties.createdate	STRING
properties.description	STRING
properties.discount	NUMBER
properties.hs_acv	NUMBER
properties.hs_all_accessible_team_ids	STRING
properties.hs_all_assigned_business_unit_ids	STRING
properties.hs_all_owner_ids	STRING
properties.hs_all_team_ids	STRING
properties.hs_allow_buyer_selected_quantity	STRING
properties.hs_arr	NUMBER
properties.hs_cost_of_goods_sold	NUMBER
properties.hs_created_by_user_id	NUMBER
properties.hs_createdate	STRING
properties.hs_discount_percentage	NUMBER
properties.hs_external_id	NUMBER
properties.hs_images	STRING
properties.hs_lastmodifieddate	STRING
properties.hs_line_item_currency_code	STRING
properties.hs_margin	NUMBER
properties.hs_margin_acv	NUMBER
properties.hs_margin_arr	NUMBER
properties.hs_margin_mrr	NUMBER
properties.hs_margin_tcv	NUMBER
properties.hs_merged_object_ids	STRING
properties.hs_mrr	NUMBER
properties.hs_object_id	NUMBER
properties.hs_position_on_quote	NUMBER
properties.hs_pre_discount_amount	NUMBER
properties.hs_product_id	NUMBER
properties.hs_read_only	BOOLEAN
properties.hs_recurring_billing_end_date	STRING
properties.hs_recurring_billing_number_of_payments	NUMBER
properties.hs_recurring_billing_period	STRING
properties.hs_recurring_billing_start_date	STRING
properties.hs_recurring_billing_terms	STRING
properties.hs_sku	STRING
properties.hs_sync_amount	NUMBER
properties.hs_tcv	NUMBER
properties.hs_term_in_months	NUMBER
properties.hs_total_discount	NUMBER
properties.hs_unique_creation_key	STRING
properties.hs_updated_by_user_id	NUMBER
properties.hs_url	STRING
properties.hs_user_ids_of_all_notification_followers	STRING
properties.hs_user_ids_of_all_notification_unfollowers	STRING
properties.hs_user_ids_of_all_owners	STRING
properties.hs_variant_id	NUMBER
properties.hubspot_owner_assigneddate	STRING
properties.hubspot_owner_id	STRING
properties.hubspot_team_id	STRING
properties.ip__sync_extension__external_source_account_id	STRING
properties.ip__sync_extension__external_source_app_id	STRING
properties.name	STRING
properties.price	NUMBER
properties.quantity	NUMBER
properties.recurringbillingfrequency	STRING
properties.tax	NUMBER
updatedAt	STRING

marketing_emails

Field name	Type
ab	BOOLEAN
abHoursToWait	INTEGER
abSampleSizeDefault	STRING
abSamplingDefault	STRING
abStatus	STRING
abSuccessMetric	STRING
abTestPercentage	INTEGER
abVariation	BOOLEAN
absoluteUrl	STRING
allEmailCampaignIds	ARRAY
analyticsPageId	STRING
analyticsPageType	STRING
archived	BOOLEAN
authorAt	INTEGER
authorName	STRING
authorUserId	INTEGER
blogEmailType	STRING
campaign	STRING
campaignName	STRING
canSpamSettingsId	INTEGER
categoryId	INTEGER
clonedFrom	INTEGER
contentTypeCategory	INTEGER
createPage	BOOLEAN
created	INTEGER
createdById	INTEGER
currentState	STRING
currentlyPublished	BOOLEAN
customReplyTo	STRING
customReplyToEnabled	BOOLEAN
domain	STRING
emailBody	STRING
emailNote	STRING
emailTemplateMode	STRING
emailType	STRING
emailbodyPlaintext	STRING
feedbackEmailCategory	STRING
feedbackSurveyId	INTEGER
folderId	INTEGER
freezeDate	INTEGER
fromName	STRING
htmlTitle	STRING
id	INTEGER
isGraymailSuppressionEnabled	BOOLEAN
isLocalTimezoneSend	BOOLEAN
isPublished	BOOLEAN
isRecipientFatigueSuppressionEnabled	BOOLEAN
leadFlowId	INTEGER
liveDomain	STRING
mailingListsExcluded	ARRAY
mailingListsIncluded	ARRAY
maxRssEntries	INTEGER
metaDescription	STRING
name	STRING
pageExpiryEnabled	BOOLEAN
pageRedirected	BOOLEAN
portalId	INTEGER
previewKey	STRING
primaryEmailCampaignId	INTEGER
processingStatus	STRING
publishDate	INTEGER
publishImmediately	BOOLEAN
publishedById	INTEGER
publishedByName	STRING
publishedUrl	STRING
replyTo	STRING
resolvedDomain	STRING
selected	INTEGER
slug	STRING
smartEmailFields	OBJECT
state	STRING
stats	OBJECT
stats.counters	OBJECT
stats.counters.bounce	INTEGER
stats.counters.click	INTEGER
stats.counters.contactslost	INTEGER
stats.counters.delivered	INTEGER
stats.counters.dropped	INTEGER
stats.counters.hardbounced	INTEGER
stats.counters.notsent	INTEGER
stats.counters.open	INTEGER
stats.counters.pending	INTEGER
stats.counters.selected	INTEGER
stats.counters.softbounced	INTEGER
stats.counters.spamreport	INTEGER
stats.counters.suppressed	INTEGER
stats.counters.unsubscribed	INTEGER
stats.deviceBreakdown	OBJECT
stats.deviceBreakdown.click_device_type	OBJECT
stats.deviceBreakdown.click_device_type.computer	INTEGER
stats.deviceBreakdown.click_device_type.mobile	INTEGER
stats.deviceBreakdown.click_device_type.unknown	INTEGER
stats.deviceBreakdown.open_device_type	OBJECT
stats.deviceBreakdown.open_device_type.computer	INTEGER
stats.deviceBreakdown.open_device_type.mobile	INTEGER
stats.deviceBreakdown.open_device_type.unknown	INTEGER
stats.failedToLoad	BOOLEAN
stats.ratios	OBJECT
stats.ratios.bounceratio	NUMBER
stats.ratios.clickratio	NUMBER
stats.ratios.clickthroughratio	NUMBER
stats.ratios.contactslostratio	NUMBER
stats.ratios.deliveredratio	NUMBER
stats.ratios.hardbounceratio	NUMBER
stats.ratios.notsentratio	NUMBER
stats.ratios.openratio	NUMBER
stats.ratios.pendingratio	NUMBER
stats.ratios.softbounceratio	NUMBER
stats.ratios.spamreportratio	NUMBER
stats.ratios.unsubscribedratio	NUMBER
subcategory	STRING
subject	STRING
subscription	INTEGER
subscriptionName	STRING
templatePath	STRING
transactional	BOOLEAN
unpublishedAt	INTEGER
updated	INTEGER
updatedById	INTEGER
url	STRING
useRssHeadlineAsSubject	BOOLEAN
vidsExcluded	ARRAY
vidsIncluded	ARRAY

owners

Field name	Type
archived	BOOLEAN
createdAt	STRING
email	STRING
firstName	STRING
id	STRING
lastName	STRING
teams	ARRAY
updatedAt	STRING
userId	INTEGER

products

Field name	Type
archived	BOOLEAN
createdAt	STRING
id	STRING
properties	OBJECT
properties.amount	NUMBER
properties.createdate	STRING
properties.description	STRING
properties.discount	NUMBER
properties.hs_all_accessible_team_ids	STRING
properties.hs_all_assigned_business_unit_ids	STRING
properties.hs_all_owner_ids	STRING
properties.hs_all_team_ids	STRING
properties.hs_avatar_filemanager_key	STRING
properties.hs_cost_of_goods_sold	NUMBER
properties.hs_created_by_user_id	NUMBER
properties.hs_createdate	STRING
properties.hs_discount_percentage	NUMBER
properties.hs_folder_id	NUMBER
properties.hs_images	STRING
properties.hs_lastmodifieddate	STRING
properties.hs_merged_object_ids	STRING
properties.hs_object_id	NUMBER
properties.hs_product_type	STRING
properties.hs_read_only	BOOLEAN
properties.hs_recurring_billing_period	STRING
properties.hs_recurring_billing_start_date	STRING
properties.hs_sku	STRING
properties.hs_unique_creation_key	STRING
properties.hs_updated_by_user_id	NUMBER
properties.hs_url	STRING
properties.hs_user_ids_of_all_notification_followers	STRING
properties.hs_user_ids_of_all_notification_unfollowers	STRING
properties.hs_user_ids_of_all_owners	STRING
properties.hubspot_owner_assigneddate	STRING
properties.hubspot_owner_id	STRING
properties.hubspot_team_id	STRING
properties.ip__sync_extension__external_source_account_id	STRING
properties.ip__sync_extension__external_source_app_id	STRING
properties.name	STRING
properties.price	NUMBER
properties.quantity	NUMBER
properties.recurringbillingfrequency	STRING
properties.tax	NUMBER
updatedAt	STRING

property_history

Field name	Type
properties	OBJECT
properties.account_creation_date	STRING
properties.additional_info	STRING
properties.address	STRING
properties.affiliate_id	STRING
properties.affiliates_program	STRING
properties.age	NUMBER
properties.an_order_has_not_yet_done_because_	STRING
properties.annualrevenue	STRING
properties.associatedcompanyid	NUMBER
properties.associatedcompanylastupdated	NUMBER
properties.average_days_between_orders	NUMBER
properties.average_order_value	NUMBER
properties.bike_description	STRING
properties.bike_usage	STRING
properties.blog_default_hubspot_blog_6183776915_subscription	STRING
properties.checkout	STRING
properties.city	STRING
properties.client_type	STRING
properties.closedate	STRING
properties.company	STRING
properties.company_size	STRING
properties.complaint_description	STRING
properties.country	STRING
properties.county	STRING
properties.createdate	STRING
properties.currentlyinworkflow	STRING
properties.customer_group	STRING
properties.date_of_birth	STRING
properties.date_of_visit	STRING
properties.days_to_close	NUMBER
properties.degree	STRING
properties.description_info__from_sales	STRING
properties.do_you_currently_own_an_electric_mobility_device_of_any_kind__in_your_household_	STRING
properties.ebike_model_selection	STRING
properties.email	STRING
properties.engagements_last_meeting_booked	STRING
properties.engagements_last_meeting_booked_campaign	STRING
properties.engagements_last_meeting_booked_medium	STRING
properties.engagements_last_meeting_booked_source	STRING
properties.fax	STRING
properties.field_of_study	STRING
properties.first_conversion_date	STRING
properties.first_conversion_event_name	STRING
properties.first_deal_created_date	STRING
properties.first_order_date	STRING
properties.first_order_value	NUMBER
properties.firstname	STRING
properties.followercount	NUMBER
properties.frame_number	STRING
properties.full_name	STRING
properties.ga	STRING
properties.gender	STRING
properties.graduation_date	STRING
properties.hs_additional_emails	STRING
properties.hs_all_accessible_team_ids	STRING
properties.hs_all_contact_vids	STRING
properties.hs_all_owner_ids	STRING
properties.hs_all_team_ids	STRING
properties.hs_analytics_average_page_views	NUMBER
properties.hs_analytics_first_referrer	STRING
properties.hs_analytics_first_timestamp	STRING
properties.hs_analytics_first_touch_converting_campaign	STRING
properties.hs_analytics_first_url	STRING
properties.hs_analytics_first_visit_timestamp	STRING
properties.hs_analytics_last_referrer	STRING
properties.hs_analytics_last_timestamp	STRING
properties.hs_analytics_last_touch_converting_campaign	STRING
properties.hs_analytics_last_url	STRING
properties.hs_analytics_last_visit_timestamp	STRING
properties.hs_analytics_num_event_completions	NUMBER
properties.hs_analytics_num_page_views	NUMBER
properties.hs_analytics_num_visits	NUMBER
properties.hs_analytics_revenue	NUMBER
properties.hs_analytics_source	STRING
properties.hs_analytics_source_data_1	STRING
properties.hs_analytics_source_data_2	STRING
properties.hs_avatar_filemanager_key	STRING
properties.hs_buying_role	STRING
properties.hs_calculated_form_submissions	STRING
properties.hs_calculated_merged_vids	STRING
properties.hs_calculated_mobile_number	STRING
properties.hs_calculated_phone_number	STRING
properties.hs_calculated_phone_number_area_code	STRING
properties.hs_calculated_phone_number_country_code	STRING
properties.hs_calculated_phone_number_region_code	STRING
properties.hs_clicked_linkedin_ad	STRING
properties.hs_content_membership_email_confirmed	BOOLEAN
properties.hs_content_membership_follow_up_enqueued_at	STRING
properties.hs_content_membership_notes	STRING
properties.hs_content_membership_registered_at	STRING
properties.hs_content_membership_registration_domain_sent_to	STRING
properties.hs_content_membership_registration_email_sent_at	STRING
properties.hs_content_membership_status	STRING
properties.hs_conversations_visitor_email	STRING
properties.hs_count_is_unworked	NUMBER
properties.hs_count_is_worked	NUMBER
properties.hs_created_by_conversations	BOOLEAN
properties.hs_created_by_user_id	NUMBER
properties.hs_createdate	STRING
properties.hs_date_entered_customer	STRING
properties.hs_date_entered_evangelist	STRING
properties.hs_date_entered_lead	STRING
properties.hs_date_entered_marketingqualifiedlead	STRING
properties.hs_date_entered_opportunity	STRING
properties.hs_date_entered_other	STRING
properties.hs_date_entered_salesqualifiedlead	STRING
properties.hs_date_entered_subscriber	STRING
properties.hs_date_exited_customer	STRING
properties.hs_date_exited_evangelist	STRING
properties.hs_date_exited_lead	STRING
properties.hs_date_exited_marketingqualifiedlead	STRING
properties.hs_date_exited_opportunity	STRING
properties.hs_date_exited_other	STRING
properties.hs_date_exited_salesqualifiedlead	STRING
properties.hs_date_exited_subscriber	STRING
properties.hs_document_last_revisited	STRING
properties.hs_email_bad_address	BOOLEAN
properties.hs_email_bounce	NUMBER
properties.hs_email_click	NUMBER
properties.hs_email_customer_quarantined_reason	STRING
properties.hs_email_delivered	NUMBER
properties.hs_email_domain	STRING
properties.hs_email_first_click_date	STRING
properties.hs_email_first_open_date	STRING
properties.hs_email_first_reply_date	STRING
properties.hs_email_first_send_date	STRING
properties.hs_email_hard_bounce_reason	STRING
properties.hs_email_hard_bounce_reason_enum	STRING
properties.hs_email_is_ineligible	BOOLEAN
properties.hs_email_last_click_date	STRING
properties.hs_email_last_email_name	STRING
properties.hs_email_last_open_date	STRING
properties.hs_email_last_reply_date	STRING
properties.hs_email_last_send_date	STRING
properties.hs_email_open	NUMBER
properties.hs_email_optout	BOOLEAN
properties.hs_email_optout_12252300	STRING
properties.hs_email_optout_12635413	STRING
properties.hs_email_optout_38192992	STRING
properties.hs_email_optout_5219978	STRING
properties.hs_email_optout_5360075	STRING
properties.hs_email_optout_5361073	STRING
properties.hs_email_optout_6599242	STRING
properties.hs_email_optout_6903142	STRING
properties.hs_email_quarantined	BOOLEAN
properties.hs_email_quarantined_reason	STRING
properties.hs_email_replied	NUMBER
properties.hs_email_sends_since_last_engagement	NUMBER
properties.hs_emailconfirmationstatus	STRING
properties.hs_eventbrite_lastregisteredevent	STRING
properties.hs_eventbrite_lastregisteredeventdate	STRING
properties.hs_facebook_ad_clicked	BOOLEAN
properties.hs_facebook_click_id	STRING
properties.hs_facebookid	STRING
properties.hs_feedback_last_nps_follow_up	STRING
properties.hs_feedback_last_nps_rating	STRING
properties.hs_feedback_last_survey_date	STRING
properties.hs_feedback_show_nps_web_survey	BOOLEAN
properties.hs_first_engagement_object_id	NUMBER
properties.hs_first_subscription_create_date	STRING
properties.hs_google_click_id	STRING
properties.hs_googleplusid	STRING
properties.hs_has_active_subscription	NUMBER
properties.hs_ip_timezone	STRING
properties.hs_is_contact	BOOLEAN
properties.hs_is_unworked	BOOLEAN
properties.hs_language	STRING
properties.hs_last_sales_activity_date	STRING
properties.hs_last_sales_activity_timestamp	STRING
properties.hs_last_sales_activity_type	STRING
properties.hs_lastmodifieddate	STRING
properties.hs_latest_meeting_activity	STRING
properties.hs_latest_sequence_ended_date	STRING
properties.hs_latest_sequence_enrolled	NUMBER
properties.hs_latest_sequence_enrolled_date	STRING
properties.hs_latest_sequence_finished_date	STRING
properties.hs_latest_sequence_unenrolled_date	STRING
properties.hs_latest_source	STRING
properties.hs_latest_source_data_1	STRING
properties.hs_latest_source_data_2	STRING
properties.hs_latest_source_timestamp	STRING
properties.hs_latest_subscription_create_date	STRING
properties.hs_lead_status	STRING
properties.hs_legal_basis	STRING
properties.hs_lifecyclestage_customer_date	STRING
properties.hs_lifecyclestage_evangelist_date	STRING
properties.hs_lifecyclestage_lead_date	STRING
properties.hs_lifecyclestage_marketingqualifiedlead_date	STRING
properties.hs_lifecyclestage_opportunity_date	STRING
properties.hs_lifecyclestage_other_date	STRING
properties.hs_lifecyclestage_salesqualifiedlead_date	STRING
properties.hs_lifecyclestage_subscriber_date	STRING
properties.hs_linkedin_ad_clicked	STRING
properties.hs_linkedinid	STRING
properties.hs_marketable_reason_id	STRING
properties.hs_marketable_reason_type	STRING
properties.hs_marketable_status	STRING
properties.hs_marketable_until_renewal	STRING
properties.hs_merged_object_ids	STRING
properties.hs_object_id	NUMBER
properties.hs_persona	STRING
properties.hs_pinned_engagement_id	NUMBER
properties.hs_pipeline	STRING
properties.hs_read_only	BOOLEAN
properties.hs_sa_first_engagement_date	STRING
properties.hs_sa_first_engagement_descr	STRING
properties.hs_sa_first_engagement_object_type	STRING
properties.hs_sales_email_last_clicked	STRING
properties.hs_sales_email_last_opened	STRING
properties.hs_sales_email_last_replied	STRING
properties.hs_searchable_calculated_international_mobile_number	STRING
properties.hs_searchable_calculated_international_phone_number	STRING
properties.hs_searchable_calculated_mobile_number	STRING
properties.hs_searchable_calculated_phone_number	STRING
properties.hs_sequences_actively_enrolled_count	NUMBER
properties.hs_sequences_enrolled_count	NUMBER
properties.hs_sequences_is_enrolled	BOOLEAN
properties.hs_testpurge	STRING
properties.hs_testrollback	STRING
properties.hs_time_in_customer	NUMBER
properties.hs_time_in_evangelist	NUMBER
properties.hs_time_in_lead	NUMBER
properties.hs_time_in_marketingqualifiedlead	NUMBER
properties.hs_time_in_opportunity	NUMBER
properties.hs_time_in_other	NUMBER
properties.hs_time_in_salesqualifiedlead	NUMBER
properties.hs_time_in_subscriber	NUMBER
properties.hs_time_to_first_engagement	NUMBER
properties.hs_timezone	STRING
properties.hs_twitterid	STRING
properties.hs_unique_creation_key	STRING
properties.hs_updated_by_user_id	NUMBER
properties.hs_user_ids_of_all_notification_followers	STRING
properties.hs_user_ids_of_all_notification_unfollowers	STRING
properties.hs_user_ids_of_all_owners	STRING
properties.hs_whatsapp_phone_number	STRING
properties.hubspot_owner_assigneddate	STRING
properties.hubspot_owner_id	STRING
properties.hubspot_team_id	STRING
properties.hubspotscore	NUMBER
properties.important_factors	STRING
properties.industry	STRING
properties.ip__sync_extension__external_source_account_id	STRING
properties.ip__sync_extension__external_source_app_id	STRING
properties.ip_city	STRING
properties.ip_country	STRING
properties.ip_country_code	STRING
properties.ip_latlon	STRING
properties.ip_state	STRING
properties.ip_state_code	STRING
properties.ip_zipcode	STRING
properties.job_function	STRING
properties.jobtitle	STRING
properties.kicstarter_baker	STRING
properties.kloutscoregeneral	NUMBER
properties.language	STRING
properties.last_order_date	STRING
properties.last_order_order_number	STRING
properties.last_order_shipment_carrier	STRING
properties.last_order_shipment_date	STRING
properties.last_order_status	STRING
properties.last_order_tracking_number	STRING
properties.last_order_tracking_url	STRING
properties.last_order_value	NUMBER
properties.lastmodifieddate	STRING
properties.lastname	STRING
properties.lifecyclestage	STRING
properties.linkedinbio	STRING
properties.linkedinconnections	NUMBER
properties.logistic_owner	STRING
properties.logistics_status	STRING
properties.marital_status	STRING
properties.marketing_mail	STRING
properties.media_name	STRING
properties.message	STRING
properties.military_status	STRING
properties.mobilephone	STRING
properties.monetary_rating	STRING
properties.notes_last_contacted	STRING
properties.notes_last_updated	STRING
properties.notes_next_activity_date	STRING
properties.num_associated_deals	NUMBER
properties.num_contacted_notes	NUMBER
properties.num_conversion_events	NUMBER
properties.num_notes	NUMBER
properties.num_unique_conversion_events	NUMBER
properties.number_of_officers	NUMBER
properties.number_of_shops	NUMBER
properties.numemployees	STRING
properties.order_frequency_rating	STRING
properties.order_recency_rating	STRING
properties.partners_program_status	STRING
properties.phone	STRING
properties.phone_activity	STRING
properties.photo	STRING
properties.police_department	STRING
properties.purpose_of_bike_enquiry	STRING
properties.question_perfect_bike	STRING
properties.question_risk_factors	STRING
properties.recent_conversion_date	STRING
properties.recent_conversion_event_name	STRING
properties.recent_deal_amount	NUMBER
properties.recent_deal_close_date	STRING
properties.relationship_status	STRING
properties.sales_category	STRING
properties.sales_owner	STRING
properties.sales_person_name	STRING
properties.salutation	STRING
properties.school	STRING
properties.seniority	STRING
properties.signed_contract_date	STRING
properties.social_contact	STRING
properties.start_date	STRING
properties.state	STRING
properties.support_owner	STRING
properties.support_status	STRING
properties.surveymonkeyeventlastupdated	NUMBER
properties.total_number_of_orders	NUMBER
properties.total_revenue	NUMBER
properties.total_value_of_orders	NUMBER
properties.twitterbio	STRING
properties.twitterhandle	STRING
properties.twitterprofilephoto	STRING
properties.unsubscribe	STRING
properties.usa_state	STRING
properties.webinareventlastupdated	NUMBER
properties.website	STRING
properties.what_brings_you_to_electrify_expo_	STRING
properties.when_do_you_plan_on_purchasing___lectric_vehicle__of_any_kind__	STRING
properties.why_can_t_be_our_dealer	STRING
properties.work_email	STRING
properties.www	STRING
properties.zip	STRING
property	STRING
selected	BOOLEAN
source-id	STRING
source-label	STRING
source-type	STRING
timestamp	INTEGER
updated-by-user-id	INTEGER
value	STRING
vid	INTEGER

subscription_changes

Field name	Type
changes	ARRAY
portalId	INTEGER
recipient	STRING
timestamp	INTEGER

tickets

Field name	Type
archived	BOOLEAN
companies	ARRAY
contacts	ARRAY
createdAt	STRING
deals	ARRAY
id	STRING
properties	OBJECT
properties.closed_date	STRING
properties.content	STRING
properties.created_by	NUMBER
properties.createdate	STRING
properties.defect_broken_part	STRING
properties.first_agent_reply_date	STRING
properties.frame_number	STRING
properties.hs_all_accessible_team_ids	STRING
properties.hs_all_assigned_business_unit_ids	STRING
properties.hs_all_owner_ids	STRING
properties.hs_all_team_ids	STRING
properties.hs_assignment_method	STRING
properties.hs_auto_generated_from_thread_id	NUMBER
properties.hs_conversations_originating_message_id	STRING
properties.hs_conversations_originating_thread_id	NUMBER
properties.hs_created_by_user_id	NUMBER
properties.hs_createdate	STRING
properties.hs_custom_inbox	NUMBER
properties.hs_date_entered_1	STRING
properties.hs_date_entered_13189938	STRING
properties.hs_date_entered_13189939	STRING
properties.hs_date_entered_14528596	STRING
properties.hs_date_entered_15945334	STRING
properties.hs_date_entered_15945335	STRING
properties.hs_date_entered_15945336	STRING
properties.hs_date_entered_15945337	STRING
properties.hs_date_entered_15948235	STRING
properties.hs_date_entered_15948236	STRING
properties.hs_date_entered_15948261	STRING
properties.hs_date_entered_15948653	STRING
properties.hs_date_entered_2	STRING
properties.hs_date_entered_3	STRING
properties.hs_date_entered_4	STRING
properties.hs_date_entered_8577134	STRING
properties.hs_date_exited_1	STRING
properties.hs_date_exited_13189938	STRING
properties.hs_date_exited_13189939	STRING
properties.hs_date_exited_14528596	STRING
properties.hs_date_exited_15945334	STRING
properties.hs_date_exited_15945335	STRING
properties.hs_date_exited_15945336	STRING
properties.hs_date_exited_15945337	STRING
properties.hs_date_exited_15948235	STRING
properties.hs_date_exited_15948236	STRING
properties.hs_date_exited_15948261	STRING
properties.hs_date_exited_15948653	STRING
properties.hs_date_exited_2	STRING
properties.hs_date_exited_3	STRING
properties.hs_date_exited_4	STRING
properties.hs_date_exited_8577134	STRING
properties.hs_external_object_ids	STRING
properties.hs_feedback_last_ces_follow_up	STRING
properties.hs_feedback_last_ces_rating	STRING
properties.hs_feedback_last_survey_date	STRING
properties.hs_file_upload	STRING
properties.hs_first_agent_message_sent_at	STRING
properties.hs_in_helpdesk	BOOLEAN
properties.hs_inbox_id	NUMBER
properties.hs_last_email_activity	STRING
properties.hs_last_email_date	STRING
properties.hs_last_message_received_at	STRING
properties.hs_last_message_sent_at	STRING
properties.hs_lastactivitydate	STRING
properties.hs_lastcontacted	STRING
properties.hs_lastmodifieddate	STRING
properties.hs_latest_message_seen_by_agent_ids	STRING
properties.hs_merged_object_ids	STRING
properties.hs_msteams_message_id	STRING
properties.hs_nextactivitydate	STRING
properties.hs_num_associated_companies	NUMBER
properties.hs_num_times_contacted	NUMBER
properties.hs_object_id	NUMBER
properties.hs_originating_channel_instance_id	STRING
properties.hs_originating_email_engagement_id	NUMBER
properties.hs_originating_generic_channel_id	STRING
properties.hs_pinned_engagement_id	NUMBER
properties.hs_pipeline	STRING
properties.hs_pipeline_stage	STRING
properties.hs_read_only	BOOLEAN
properties.hs_resolution	STRING
properties.hs_sales_email_last_replied	STRING
properties.hs_thread_ids_to_restore	STRING
properties.hs_ticket_category	STRING
properties.hs_ticket_id	NUMBER
properties.hs_ticket_priority	STRING
properties.hs_time_in_1	NUMBER
properties.hs_time_in_13189938	NUMBER
properties.hs_time_in_13189939	NUMBER
properties.hs_time_in_14528596	NUMBER
properties.hs_time_in_15945334	NUMBER
properties.hs_time_in_15945335	NUMBER
properties.hs_time_in_15945336	NUMBER
properties.hs_time_in_15945337	NUMBER
properties.hs_time_in_15948235	NUMBER
properties.hs_time_in_15948236	NUMBER
properties.hs_time_in_15948261	NUMBER
properties.hs_time_in_15948653	NUMBER
properties.hs_time_in_2	NUMBER
properties.hs_time_in_3	NUMBER
properties.hs_time_in_4	NUMBER
properties.hs_time_in_8577134	NUMBER
properties.hs_time_to_close_sla_at	STRING
properties.hs_time_to_close_sla_status	STRING
properties.hs_time_to_first_response_sla_at	STRING
properties.hs_time_to_first_response_sla_status	STRING
properties.hs_unique_creation_key	STRING
properties.hs_updated_by_user_id	NUMBER
properties.hs_user_ids_of_all_notification_followers	STRING
properties.hs_user_ids_of_all_notification_unfollowers	STRING
properties.hs_user_ids_of_all_owners	STRING
properties.hubspot_owner_assigneddate	STRING
properties.hubspot_owner_id	STRING
properties.hubspot_team_id	STRING
properties.last_engagement_date	STRING
properties.last_reply_date	STRING
properties.notes_last_contacted	STRING
properties.notes_last_updated	STRING
properties.notes_next_activity_date	STRING
properties.nps_follow_up_answer	STRING
properties.nps_follow_up_question_version	NUMBER
properties.nps_score	STRING
properties.num_contacted_notes	NUMBER
properties.num_notes	NUMBER
properties.payment	NUMBER
properties.source_incoming_expired	NUMBER
properties.source_incoming_phone	STRING
properties.source_ref	STRING
properties.source_thread_id	STRING
properties.source_type	STRING
properties.subject	STRING
properties.tags	STRING
properties.time_to_close	NUMBER
properties.time_to_first_agent_reply	NUMBER
properties.warranty	STRING
updatedAt	STRING

ticket_pipelines

Field name	Type
archived	BOOLEAN
createdAt	STRING
id	STRING
label	STRING
stages	ARRAY
updatedAt	STRING

workflows

Field name	Type
contactListIds	OBJECT
contactListIds.active	INTEGER
contactListIds.enrolled	INTEGER
contactListIds.steps	ARRAY
enabled	BOOLEAN
id	INTEGER
insertedAt	INTEGER
name	STRING
personaTagIds	ARRAY
type	STRING
updatedAt	INTEGER