Contacts: HubSpot Contacts |
ListRead a page of contacts. Control what is returned via the `properties` query param.
Catalog: Contacts3
Schema: Basic
Label: Contacts
Retrieve: true
Insert: true
Update: false
Delete: false
Parameters of Table Function
The following parameters can be used to control the behaviour of the table function Contacts. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values.
Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.
Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.
Name |
Data Type |
Required |
Default Value |
Documentation |
---|---|---|---|---|
after |
string |
☐ |
|
The paging cursor token of the last successfully read resource will be returned as the `paging.next.after` JSON property of a paged response containing more results. |
archived |
boolean |
☐ |
|
Whether to return only results that have been archived. |
Columns of Table Function
The columns of the table function Contacts are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
archived |
boolean |
Archived |
☐ |
|
archivedAt |
datetime |
Archived at |
☐ |
|
associations |
string |
Associations |
☐ |
|
createdAt |
datetime |
Created at |
☐ |
|
id |
string |
ID |
☐ |
|
prop_address |
string |
Address |
☐ |
|
prop_annualrevenue |
string |
Annual Revenue |
☐ |
|
prop_associatedcompanyid |
decimal |
Associated Company ID |
☐ |
|
prop_associatedcompanylastupdated |
decimal |
Associated Company Last Updated |
☐ |
|
prop_city |
string |
City |
☐ |
|
prop_closedate |
datetime |
Close Date |
☐ |
|
prop_company_size |
string |
Company Size |
☐ |
|
prop_company |
string |
Company |
☐ |
|
prop_country |
string |
Country |
☐ |
|
prop_createdate |
datetime |
Created at |
☐ |
|
prop_currentlyinworkflow |
string |
Currently in Workflow |
☐ |
|
prop_date_of_birth |
string |
Date of Birth |
☐ |
|
prop_days_to_close |
decimal |
Days to Close |
☐ |
|
prop_degree |
string |
Degree |
☐ |
|
prop_email |
string |
☐ |
|
|
prop_engagements_last_meeting_booked_campaign |
string |
Last Meeting Booked Campaign |
☐ |
|
prop_engagements_last_meeting_booked_medium |
string |
Last Meeting Booked Medium |
☐ |
|
prop_engagements_last_meeting_booked_source |
string |
Last Meeting Booked Source |
☐ |
|
prop_engagements_last_meeting_booked |
datetime |
Last Meeting Booked |
☐ |
|
prop_fax |
string |
Fax |
☐ |
|
prop_field_of_study |
string |
Field of Study |
☐ |
|
prop_first_conversion_date |
datetime |
First Conversion Date |
☐ |
|
prop_first_conversion_event_name |
string |
First Conversion Event Name |
☐ |
|
prop_first_deal_created_date |
datetime |
First Deal Created at |
☐ |
|
prop_firstname |
string |
First Name |
☐ |
|
prop_gender |
string |
Gender |
☐ |
|
prop_graduation_date |
string |
Graduation Date |
☐ |
|
prop_hs_additional_emails |
string |
Additional Emails |
☐ |
|
prop_hs_all_accessible_team_ids |
string |
All Accessible Team IDs |
☐ |
|
prop_hs_all_contact_vids |
string |
All Contact VIDs |
☐ |
|
prop_hs_all_owner_ids |
string |
All Owner IDs |
☐ |
|
prop_hs_all_team_ids |
string |
All Team IDs |
☐ |
|
prop_hs_analytics_average_page_views |
decimal |
Analytics Average Page Views |
☐ |
|
prop_hs_analytics_first_referrer |
string |
Analytics First Referrer |
☐ |
|
prop_hs_analytics_first_timestamp |
datetime |
Analytics First Timestamp |
☐ |
|
prop_hs_analytics_first_touch_converting_campaign |
string |
{res:itgen_hubspot_prop_hs_analytics_first_touch_converting_campaign} |
☐ |
|
prop_hs_analytics_first_url |
string |
Analytics First URL |
☐ |
|
prop_hs_analytics_first_visit_timestamp |
datetime |
{res:itgen_hubspot_prop_hs_analytics_first_visit_timestamp} |
☐ |
|
prop_hs_analytics_last_referrer |
string |
Analytics Last Referrer |
☐ |
|
prop_hs_analytics_last_timestamp |
datetime |
{res:itgen_hubspot_prop_hs_analytics_last_timestamp} |
☐ |
|
prop_hs_analytics_last_touch_converting_campaign |
string |
{res:itgen_hubspot_prop_hs_analytics_last_touch_converting_campaign} |
☐ |
|
prop_hs_analytics_last_url |
string |
Analytics Last URL |
☐ |
|
prop_hs_analytics_last_visit_timestamp |
datetime |
{res:itgen_hubspot_prop_hs_analytics_last_visit_timestamp} |
☐ |
|
prop_hs_analytics_num_event_completions |
decimal |
Analytics Number of Event Completions |
☐ |
|
prop_hs_analytics_num_page_views |
decimal |
Analytics Number of Page Views |
☐ |
|
prop_hs_analytics_num_visits |
decimal |
Analytics Number of Visits |
☐ |
|
prop_hs_analytics_revenue |
decimal |
Analytics Revenue |
☐ |
|
prop_hs_analytics_source_data_1 |
string |
Analytics Source Data 1 |
☐ |
|
prop_hs_analytics_source_data_2 |
string |
Analytics Source Data 2 |
☐ |
|
prop_hs_analytics_source |
string |
Analytics Source |
☐ |
|
prop_hs_associated_target_accounts |
decimal |
{res:itgen_hubspot_prop_hs_associated_target_accounts} |
☐ |
|
prop_hs_avatar_filemanager_key |
string |
Avatar Filemanager Key |
☐ |
|
prop_hs_buying_role |
string |
Buying Role |
☐ |
|
prop_hs_calculated_form_submissions |
string |
Calculated Form Submissions |
☐ |
|
prop_hs_calculated_merged_vids |
string |
Calculated Merged VIDs |
☐ |
|
prop_hs_calculated_mobile_number |
string |
Calculated Mobile Number |
☐ |
|
prop_hs_calculated_phone_number_area_code |
string |
Calculated Phone Number Area Code |
☐ |
|
prop_hs_calculated_phone_number_country_code |
string |
Calculated Phone Number Country Code |
☐ |
|
prop_hs_calculated_phone_number_region_code |
string |
Calculated Phone Number Region Code |
☐ |
|
prop_hs_calculated_phone_number |
string |
Calculated Phone Number |
☐ |
|
prop_hs_clicked_linkedin_ad |
string |
Clicked LinkedIn Ad |
☐ |
|
prop_hs_contact_enrichment_opt_out_timestamp |
datetime |
{res:itgen_hubspot_prop_hs_contact_enrichment_opt_out_timestamp} |
☐ |
|
prop_hs_contact_enrichment_opt_out |
boolean |
{res:itgen_hubspot_prop_hs_contact_enrichment_opt_out} |
☐ |
|
prop_hs_content_membership_email_confirmed |
boolean |
Content Membership Email Confirmed |
☐ |
|
prop_hs_content_membership_email |
string |
Content Membership Email |
☐ |
|
prop_hs_content_membership_follow_up_enqueued_at |
datetime |
{res:itgen_hubspot_prop_hs_content_membership_follow_up_enqueued_at} |
☐ |
|
prop_hs_content_membership_notes |
string |
Content Membership Notes |
☐ |
|
prop_hs_content_membership_registered_at |
datetime |
Content Membership Registered at |
☐ |
|
prop_hs_content_membership_registration_domain_sent_to |
string |
Content Membership Registration Domain Sent to |
☐ |
|
prop_hs_content_membership_registration_email_sent_at |
datetime |
Content Membership Registration Email Sent at |
☐ |
|
prop_hs_content_membership_status |
string |
Content Membership Status |
☐ |
|
prop_hs_conversations_visitor_email |
string |
Conversations Visitor Email |
☐ |
|
prop_hs_count_is_unworked |
decimal |
Count is Unworked |
☐ |
|
prop_hs_count_is_worked |
decimal |
Count is Worked |
☐ |
|
prop_hs_country_region_code |
string |
{res:itgen_hubspot_prop_hs_country_region_code} |
☐ |
|
prop_hs_created_by_conversations |
boolean |
Created by Conversations |
☐ |
|
prop_hs_created_by_user_id |
decimal |
Created by User ID |
☐ |
|
prop_hs_createdate |
datetime |
Created at |
☐ |
|
prop_hs_date_entered_customer |
datetime |
Date Entered Customer |
☐ |
|
prop_hs_date_entered_evangelist |
datetime |
Date Entered Evangelist |
☐ |
|
prop_hs_date_entered_lead |
datetime |
Date Entered Lead |
☐ |
|
prop_hs_date_entered_marketingqualifiedlead |
datetime |
Date Entered Marketing Qualified Lead |
☐ |
|
prop_hs_date_entered_opportunity |
datetime |
Date Entered Opportunity |
☐ |
|
prop_hs_date_entered_other |
datetime |
Date Entered Other |
☐ |
|
prop_hs_date_entered_salesqualifiedlead |
datetime |
Date Entered Sales Qualified Lead |
☐ |
|
prop_hs_date_entered_subscriber |
datetime |
Date Entered Subscriber |
☐ |
|
prop_hs_date_exited_customer |
datetime |
Date Exited Customer |
☐ |
|
prop_hs_date_exited_evangelist |
datetime |
Date Exited Evangelist |
☐ |
|
prop_hs_date_exited_lead |
datetime |
Date Exited lead |
☐ |
|
prop_hs_date_exited_marketingqualifiedlead |
datetime |
Date Exited Marketing Qualified Lead |
☐ |
|
prop_hs_date_exited_opportunity |
datetime |
Date Exited Opportunity |
☐ |
|
prop_hs_date_exited_other |
datetime |
Date Exited Other |
☐ |
|
prop_hs_date_exited_salesqualifiedlead |
datetime |
Date Exited Sales Qualified Lead |
☐ |
|
prop_hs_date_exited_subscriber |
datetime |
Date Exited Subscriber |
☐ |
|
prop_hs_document_last_revisited |
datetime |
Document Last Revisited |
☐ |
|
prop_hs_email_bad_address |
boolean |
Email Bad Address |
☐ |
|
prop_hs_email_bounce |
decimal |
Email Bounce |
☐ |
|
prop_hs_email_click |
decimal |
Email Click |
☐ |
|
prop_hs_email_customer_quarantined_reason |
string |
Email Customer Quarantained Reason |
☐ |
|
prop_hs_email_delivered |
decimal |
Email Delivered |
☐ |
|
prop_hs_email_domain |
string |
Email Domain |
☐ |
|
prop_hs_email_first_click_date |
datetime |
Email First Click Date |
☐ |
|
prop_hs_email_first_open_date |
datetime |
Email First Open Date |
☐ |
|
prop_hs_email_first_reply_date |
datetime |
Email First Reply Date |
☐ |
|
prop_hs_email_first_send_date |
datetime |
Email First Send Date |
☐ |
|
prop_hs_email_hard_bounce_reason_enum |
string |
Email Hard Bounce Reason Enumeration |
☐ |
|
prop_hs_email_hard_bounce_reason |
string |
Email Hard Bounce Reason |
☐ |
|
prop_hs_email_is_ineligible |
boolean |
Email is Ineligible |
☐ |
|
prop_hs_email_last_click_date |
datetime |
Email Last Click Date |
☐ |
|
prop_hs_email_last_email_name |
string |
Email Last Email Name |
☐ |
|
prop_hs_email_last_open_date |
datetime |
Email Last Open Date |
☐ |
|
prop_hs_email_last_reply_date |
datetime |
Email Last Reply Date |
☐ |
|
prop_hs_email_last_send_date |
datetime |
Email Last Send Date |
☐ |
|
prop_hs_email_open |
decimal |
Email Open |
☐ |
|
prop_hs_email_optout_194989673 |
string |
{res:itgen_hubspot_prop_hs_email_optout_194989673} |
☐ |
|
prop_hs_email_optout_195239151 |
string |
{res:itgen_hubspot_prop_hs_email_optout_195239151} |
☐ |
|
prop_hs_email_optout_329127693 |
string |
{res:itgen_hubspot_prop_hs_email_optout_329127693} |
☐ |
|
prop_hs_email_optout |
boolean |
Email Opt-out |
☐ |
|
prop_hs_email_quarantined_reason |
string |
Email Quarantained Reason |
☐ |
|
prop_hs_email_quarantined |
boolean |
Email Quarantained |
☐ |
|
prop_hs_email_replied |
decimal |
Email Replied |
☐ |
|
prop_hs_email_sends_since_last_engagement |
decimal |
Email Sends since Last Engagement |
☐ |
|
prop_hs_emailconfirmationstatus |
string |
Email Confirmation Status |
☐ |
|
prop_hs_facebook_ad_clicked |
boolean |
Facebook Ad Clicked |
☐ |
|
prop_hs_facebook_click_id |
string |
Facebook Click ID |
☐ |
|
prop_hs_first_closed_order_id |
decimal |
{res:itgen_hubspot_prop_hs_first_closed_order_id} |
☐ |
|
prop_hs_first_engagement_object_id |
decimal |
First Engagement Object ID |
☐ |
|
prop_hs_first_order_closed_date |
datetime |
{res:itgen_hubspot_prop_hs_first_order_closed_date} |
☐ |
|
prop_hs_first_outreach_date |
datetime |
First Outreach Date |
☐ |
|
prop_hs_first_subscription_create_date |
datetime |
First Subscription Created at |
☐ |
|
prop_hs_google_click_id |
string |
Google Click ID |
☐ |
|
prop_hs_has_active_subscription |
decimal |
Has Active Subscription |
☐ |
|
prop_hs_ip_timezone |
string |
IP Timezone |
☐ |
|
prop_hs_is_contact |
boolean |
Is Contact |
☐ |
|
prop_hs_is_enriched |
boolean |
{res:itgen_hubspot_prop_hs_is_enriched} |
☐ |
|
prop_hs_is_unworked |
boolean |
Is Unworked |
☐ |
|
prop_hs_language |
string |
Language |
☐ |
|
prop_hs_last_sales_activity_date |
datetime |
Last Sales Activity Date |
☐ |
|
prop_hs_last_sales_activity_timestamp |
datetime |
Last Sales Activity Timestamp |
☐ |
|
prop_hs_last_sales_activity_type |
string |
Last Sales Activity Type |
☐ |
|
prop_hs_lastmodifieddate |
datetime |
Last Modified Date |
☐ |
|
prop_hs_latest_disqualified_lead_date |
datetime |
{res:itgen_hubspot_prop_hs_latest_disqualified_lead_date} |
☐ |
|
prop_hs_latest_meeting_activity |
datetime |
Latest Meeting Activity |
☐ |
|
prop_hs_latest_open_lead_date |
datetime |
{res:itgen_hubspot_prop_hs_latest_open_lead_date} |
☐ |
|
prop_hs_latest_qualified_lead_date |
datetime |
{res:itgen_hubspot_prop_hs_latest_qualified_lead_date} |
☐ |
|
prop_hs_latest_sequence_ended_date |
datetime |
Latest Sequence Ended Date |
☐ |
|
prop_hs_latest_sequence_enrolled_date |
datetime |
Latest Sequence Enrolled Date |
☐ |
|
prop_hs_latest_sequence_enrolled |
decimal |
Latest Sequence Enrolled |
☐ |
|
prop_hs_latest_sequence_finished_date |
datetime |
Latest Sequence Finished Date |
☐ |
|
prop_hs_latest_sequence_unenrolled_date |
datetime |
Latest Sequence Unenrolled Date |
☐ |
|
prop_hs_latest_source_data_1 |
string |
Latest Source Data 1 |
☐ |
|
prop_hs_latest_source_data_2 |
string |
Latest Source Data 2 |
☐ |
|
prop_hs_latest_source_timestamp |
datetime |
Latest Source Timestamp |
☐ |
|
prop_hs_latest_source |
string |
Latest Source |
☐ |
|
prop_hs_latest_subscription_create_date |
datetime |
Latest Subscription Created at |
☐ |
|
prop_hs_lead_status |
string |
Lead Status |
☐ |
|
prop_hs_legal_basis |
string |
Legal Basis |
☐ |
|
prop_hs_lifecyclestage_customer_date |
datetime |
Lifecycle Stage Customer Date |
☐ |
|
prop_hs_lifecyclestage_evangelist_date |
datetime |
Lifecycle Stage Evangelist Date |
☐ |
|
prop_hs_lifecyclestage_lead_date |
datetime |
Lifecycle Stage Lead Date |
☐ |
|
prop_hs_lifecyclestage_marketingqualifiedlead_date |
datetime |
Lifecycle Stage Marketing Qualified Lead Date |
☐ |
|
prop_hs_lifecyclestage_opportunity_date |
datetime |
Lifecycle Stage Opportunity Date |
☐ |
|
prop_hs_lifecyclestage_other_date |
datetime |
Lifecycle Stage Other Date |
☐ |
|
prop_hs_lifecyclestage_salesqualifiedlead_date |
datetime |
Lifecycle Stage Sales Qualified Lead Date |
☐ |
|
prop_hs_lifecyclestage_subscriber_date |
datetime |
Lifecycle Stage Subscriber Date |
☐ |
|
prop_hs_linkedin_ad_clicked |
string |
LinkedIn Ad Clicked |
☐ |
|
prop_hs_linkedin_url |
string |
{res:itgen_hubspot_prop_hs_linkedin_url} |
☐ |
|
prop_hs_membership_has_accessed_private_content |
decimal |
{res:itgen_hubspot_prop_hs_membership_has_accessed_private_content} |
☐ |
|
prop_hs_membership_last_private_content_access_date |
datetime |
{res:itgen_hubspot_prop_hs_membership_last_private_content_access_date} |
☐ |
|
prop_hs_merged_object_ids |
string |
Merged Object IDs |
☐ |
|
prop_hs_mobile_sdk_push_tokens |
string |
{res:itgen_hubspot_prop_hs_mobile_sdk_push_tokens} |
☐ |
|
prop_hs_notes_next_activity_type |
string |
{res:itgen_hubspot_prop_hs_notes_next_activity_type} |
☐ |
|
prop_hs_object_id |
decimal |
Object ID |
☐ |
|
prop_hs_object_source_detail_1 |
string |
{res:itgen_hubspot_prop_hs_object_source_detail_1} |
☐ |
|
prop_hs_object_source_detail_2 |
string |
{res:itgen_hubspot_prop_hs_object_source_detail_2} |
☐ |
|
prop_hs_object_source_detail_3 |
string |
{res:itgen_hubspot_prop_hs_object_source_detail_3} |
☐ |
|
prop_hs_object_source_id |
string |
{res:itgen_hubspot_prop_hs_object_source_id} |
☐ |
|
prop_hs_object_source_label |
string |
{res:itgen_hubspot_prop_hs_object_source_label} |
☐ |
|
prop_hs_object_source_user_id |
decimal |
{res:itgen_hubspot_prop_hs_object_source_user_id} |
☐ |
|
prop_hs_object_source |
string |
{res:itgen_hubspot_prop_hs_object_source} |
☐ |
|
prop_hs_persona |
string |
Persona |
☐ |
|
prop_hs_pinned_engagement_id |
decimal |
Pinned Engagement ID |
☐ |
|
prop_hs_pipeline |
string |
Pipeline |
☐ |
|
prop_hs_prospecting_agent_actively_enrolled_count |
decimal |
{res:itgen_hubspot_prop_hs_prospecting_agent_actively_enrolled_count} |
☐ |
|
prop_hs_quarantined_emails |
string |
{res:itgen_hubspot_prop_hs_quarantined_emails} |
☐ |
|
prop_hs_read_only |
boolean |
Read-only |
☐ |
|
prop_hs_recent_closed_order_date |
datetime |
{res:itgen_hubspot_prop_hs_recent_closed_order_date} |
☐ |
|
prop_hs_registered_member |
decimal |
{res:itgen_hubspot_prop_hs_registered_member} |
☐ |
|
prop_hs_registration_method |
string |
{res:itgen_hubspot_prop_hs_registration_method} |
☐ |
|
prop_hs_role |
string |
{res:itgen_hubspot_prop_hs_role} |
☐ |
|
prop_hs_sa_first_engagement_date |
datetime |
First Engagement Date |
☐ |
|
prop_hs_sa_first_engagement_descr |
string |
First Engagement Description |
☐ |
|
prop_hs_sa_first_engagement_object_type |
string |
First Engagement Object Type |
☐ |
|
prop_hs_sales_email_last_clicked |
datetime |
Sales Email Last Clicked |
☐ |
|
prop_hs_sales_email_last_opened |
datetime |
Sales Email Last Opened |
☐ |
|
prop_hs_sales_email_last_replied |
datetime |
Sales Email Last Replied |
☐ |
|
prop_hs_searchable_calculated_international_mobile_number |
string |
Searchable Calculated International Mobile Number |
☐ |
|
prop_hs_searchable_calculated_international_phone_number |
string |
Searchable Calculated International Phone Number |
☐ |
|
prop_hs_searchable_calculated_mobile_number |
string |
Searchable Calculated Mobile Number |
☐ |
|
prop_hs_searchable_calculated_phone_number |
string |
Searchable Calculated Phone Number |
☐ |
|
prop_hs_seniority |
string |
{res:itgen_hubspot_prop_hs_seniority} |
☐ |
|
prop_hs_sequences_actively_enrolled_count |
decimal |
{res:itgen_hubspot_prop_hs_sequences_actively_enrolled_count} |
☐ |
|
prop_hs_sequences_enrolled_count |
decimal |
Sequences Enrolled Count |
☐ |
|
prop_hs_sequences_is_enrolled |
boolean |
Sequences Is Enrolled |
☐ |
|
prop_hs_state_code |
string |
{res:itgen_hubspot_prop_hs_state_code} |
☐ |
|
prop_hs_sub_role |
string |
{res:itgen_hubspot_prop_hs_sub_role} |
☐ |
|
prop_hs_testpurge |
string |
Test Purge |
☐ |
|
prop_hs_testrollback |
string |
Test Rollback |
☐ |
|
prop_hs_time_in_customer |
decimal |
Time in Customer |
☐ |
|
prop_hs_time_in_evangelist |
decimal |
Time in Evangelist |
☐ |
|
prop_hs_time_in_lead |
decimal |
Time in Lead |
☐ |
|
prop_hs_time_in_marketingqualifiedlead |
decimal |
Time in Marketing Qualified Lead |
☐ |
|
prop_hs_time_in_opportunity |
decimal |
Time in Opportunity |
☐ |
|
prop_hs_time_in_other |
decimal |
Time in Other |
☐ |
|
prop_hs_time_in_salesqualifiedlead |
decimal |
Time in Sales Qualified Lead |
☐ |
|
prop_hs_time_in_subscriber |
decimal |
Time in Subscriber |
☐ |
|
prop_hs_time_to_first_engagement |
decimal |
Time to First Engagement |
☐ |
|
prop_hs_timezone |
string |
Timezone |
☐ |
|
prop_hs_unique_creation_key |
string |
Unique Creation Key |
☐ |
|
prop_hs_updated_by_user_id |
decimal |
Updated by User ID |
☐ |
|
prop_hs_user_ids_of_all_notification_followers |
string |
User IDs of All Notification Followers |
☐ |
|
prop_hs_user_ids_of_all_notification_unfollowers |
string |
User IDs of All Notification Unfollowers |
☐ |
|
prop_hs_user_ids_of_all_owners |
string |
User IDs of All Owners |
☐ |
|
prop_hs_v2_date_entered_customer |
datetime |
{res:itgen_hubspot_prop_hs_v2_date_entered_customer} |
☐ |
|
prop_hs_v2_date_entered_evangelist |
datetime |
{res:itgen_hubspot_prop_hs_v2_date_entered_evangelist} |
☐ |
|
prop_hs_v2_date_entered_lead |
datetime |
{res:itgen_hubspot_prop_hs_v2_date_entered_lead} |
☐ |
|
prop_hs_v2_date_entered_marketingqualifiedlead |
datetime |
{res:itgen_hubspot_prop_hs_v2_date_entered_marketingqualifiedlead} |
☐ |
|
prop_hs_v2_date_entered_opportunity |
datetime |
{res:itgen_hubspot_prop_hs_v2_date_entered_opportunity} |
☐ |
|
prop_hs_v2_date_entered_other |
datetime |
{res:itgen_hubspot_prop_hs_v2_date_entered_other} |
☐ |
|
prop_hs_v2_date_entered_salesqualifiedlead |
datetime |
{res:itgen_hubspot_prop_hs_v2_date_entered_salesqualifiedlead} |
☐ |
|
prop_hs_v2_date_entered_subscriber |
datetime |
{res:itgen_hubspot_prop_hs_v2_date_entered_subscriber} |
☐ |
|
prop_hs_v2_date_exited_customer |
datetime |
{res:itgen_hubspot_prop_hs_v2_date_exited_customer} |
☐ |
|
prop_hs_v2_date_exited_evangelist |
datetime |
{res:itgen_hubspot_prop_hs_v2_date_exited_evangelist} |
☐ |
|
prop_hs_v2_date_exited_lead |
datetime |
{res:itgen_hubspot_prop_hs_v2_date_exited_lead} |
☐ |
|
prop_hs_v2_date_exited_marketingqualifiedlead |
datetime |
{res:itgen_hubspot_prop_hs_v2_date_exited_marketingqualifiedlead} |
☐ |
|
prop_hs_v2_date_exited_opportunity |
datetime |
{res:itgen_hubspot_prop_hs_v2_date_exited_opportunity} |
☐ |
|
prop_hs_v2_date_exited_other |
datetime |
{res:itgen_hubspot_prop_hs_v2_date_exited_other} |
☐ |
|
prop_hs_v2_date_exited_salesqualifiedlead |
datetime |
{res:itgen_hubspot_prop_hs_v2_date_exited_salesqualifiedlead} |
☐ |
|
prop_hs_v2_date_exited_subscriber |
datetime |
{res:itgen_hubspot_prop_hs_v2_date_exited_subscriber} |
☐ |
|
prop_hs_was_imported |
boolean |
Was Imported |
☐ |
|
prop_hs_whatsapp_phone_number |
string |
WhatsApp Phone Number |
☐ |
|
prop_hubspot_owner_assigneddate |
datetime |
Owner Assigned Date |
☐ |
|
prop_hubspot_owner_id |
string |
Owner ID |
☐ |
|
prop_hubspot_team_id |
string |
Team ID |
☐ |
|
prop_hubspotscore |
decimal |
Score |
☐ |
|
prop_industry |
string |
Industry |
☐ |
|
prop_ip_city |
string |
IP Address City |
☐ |
|
prop_ip_country_code |
string |
IP Address Country Code |
☐ |
|
prop_ip_country |
string |
IP Address Country |
☐ |
|
prop_ip_latlon |
string |
IP Address Latitude Longitude |
☐ |
|
prop_ip_state_code |
string |
IP Address State Code |
☐ |
|
prop_ip_state |
string |
IP Address State |
☐ |
|
prop_ip_zipcode |
string |
IP Address ZIP Code |
☐ |
|
prop_job_function |
string |
Job Function |
☐ |
|
prop_jobtitle |
string |
Job Title |
☐ |
|
prop_lastmodifieddate |
datetime |
Last Modified Date |
☐ |
|
prop_lastname |
string |
Last Name |
☐ |
|
prop_lifecyclestage |
string |
Lifecycle Stage |
☐ |
|
prop_marital_status |
string |
Marital Status |
☐ |
|
prop_message |
string |
Message |
☐ |
|
prop_military_status |
string |
Military Status |
☐ |
|
prop_mobilephone |
string |
Mobile Phone |
☐ |
|
prop_notes_last_contacted |
datetime |
Notes Last Contacted |
☐ |
|
prop_notes_last_updated |
datetime |
Notes Last Updated |
☐ |
|
prop_notes_next_activity_date |
datetime |
Notes Next Activity Date |
☐ |
|
prop_num_associated_deals |
decimal |
Number of Associated Deals |
☐ |
|
prop_num_contacted_notes |
decimal |
Number of Contacted Notes |
☐ |
|
prop_num_conversion_events |
decimal |
Number of Conversion Events |
☐ |
|
prop_num_notes |
decimal |
Number of Notes |
☐ |
|
prop_num_unique_conversion_events |
decimal |
Number of Unique Conversion Events |
☐ |
|
prop_numemployees |
string |
Number of Employees |
☐ |
|
prop_phone |
string |
Phone Number |
☐ |
|
prop_recent_conversion_date |
datetime |
Recent Conversion Date |
☐ |
|
prop_recent_conversion_event_name |
string |
Recent Conversion Event Name |
☐ |
|
prop_recent_deal_amount |
decimal |
Recent Deal Amount |
☐ |
|
prop_recent_deal_close_date |
datetime |
Recent Deal Close Date |
☐ |
|
prop_relationship_status |
string |
Relationship Status |
☐ |
|
prop_salutation |
string |
Salutation |
☐ |
|
prop_school |
string |
School |
☐ |
|
prop_seniority |
string |
Seniority |
☐ |
|
prop_start_date |
string |
Start Date |
☐ |
|
prop_state |
string |
State |
☐ |
|
prop_surveymonkeyeventlastupdated |
decimal |
Survey Monkey Event Last Updated |
☐ |
|
prop_total_revenue |
decimal |
Total Revenue |
☐ |
|
prop_twitterhandle |
string |
Twitter Handle |
☐ |
|
prop_webinareventlastupdated |
decimal |
Webinar Event Last Updated |
☐ |
|
prop_website |
string |
Website |
☐ |
|
prop_work_email |
string |
Work Email |
☐ |
|
prop_zip |
string |
ZIP Code |
☐ |
|
updatedAt |
datetime |
Updated at |
☐ |
|
18-12-2024 20:09 Version 24.1.33-BETA+5180