MSPBots WIKI : Hubspot Public Datasets
Here are the published or Alpha version Hubspot datasets that you can use to create the widgets and dashboards
In total, there are 21 publish/alpha Datasets
Name | Description | Created Date | Last updated | Fields |
---|---|---|---|---|
HubSpot Owners - API | ODS Dataset which generated from HubSpot Owners | Jan 06, 2022 | Jan 10, 2022 | ["id", "tenant_code", "hubspot_owner_id", "sync_time", "updated_time", "created_time", "email"] |
HubSpot Tickets - API | ODS Dataset which generated from HubSpot Tickets | Jan 06, 2022 | Jan 10, 2022 | ["id", "tenant_code", "ticket_id", "archived", "created_at", "updated_at", "content", "subject", "source_type", "sync_time"] |
HubSpot Companies - API | ODS Dataset which generated from HubSpot Companies | Jan 06, 2022 | Jan 10, 2022 | ["id", "tenant_code", "company_id", "sync_time", "updated_time", "created_time", "company_name", "domain", "team", "industry", "type", "website"] |
HubSpot Meetings - API | ODS Dataset which generated from HubSpot Meetings | Sep 08, 2022 | Sep 08, 2022 | ["id", "tenant_code", "other_id", "archived", "hs_activity_type", "hs_createdate", "hs_internal_meeting_notes", "hs_lastmodifieddate", "hs_meeting_end_time", "hs_meeting_external_url", "hs_meeting_start_time", "hs_meeting_title", "hs_object_id", "hs_timestamp", "hubspot_owner_id", "created_at", "updated_at", "sync_time"] |
HubSpot Email Campaigns - API | ODS Dataset which generated from HubSpot Email Campaigns | Sep 15, 2022 | Sep 15, 2022 | ["id", "tenant_code", "other_id", "app_id", "app_name", "content_id", "subject", "name", "processed", "deferred", "unsubscribed", "statuschange", "bounce", "mta_dropped", "dropped", "delivered", "reply", "sent", "click", "open", "type", "sync_time"] |
HubSpot Threads - API | ODS Dataset which generated from HubSpot Threads | Sep 15, 2022 | Sep 15, 2022 | ["id", "tenant_code", "other_id", "sync_time", "create_at", "status", "latest_message_timestamp", "latest_message_received_timestamp", "spam", "inbox_id", "associated_contact_id", "archived"] |
HubSpot Thread Message - API | ODS Dataset which generated from HubSpot Thread Message | Sep 15, 2022 | Sep 15, 2022 | ["id", "tenant_code", "other_id", "thread_id", "sync_time", "create_at", "update_at", "client_type", "senders", "recipients", "channel_id", "channel_account_id", "archived", "text", "rich_text", "attachments", "subject", "truncation_status", "status_type", "direction", "type"] |
HubSpot Emails - API | ODS Dataset which generated from HubSpot Emails | Sep 15, 2022 | Sep 15, 2022 | ["id", "tenant_code", "other_id", "archived", "hs_email_direction", "hs_createdate", "hs_email_from_firstname", "hs_email_from_lastname", "hs_email_message_id", "hs_email_subject", "hs_email_thread_id", "hs_email_to_email", "hs_email_to_firstname", "hs_email_to_lastname", "hs_lastmodifieddate", "hs_unique_id", "hs_object_id", "hs_timestamp", "hubspot_owner_id", "hs_attachment_ids", "created_at", "updated_at", "sync_time"] |
HubSpot Channel Accounts - API | ODS Dataset which generated from HubSpot Channel Accounts | Sep 20, 2022 | Sep 20, 2022 | ["id", "tenant_code", "other_id", "channel_id", "inbox_id", "name", "active", "authorized", "created_at", "sync_time"] |
HubSpot Channels - API | ODS Dataset which generated from HubSpot Channels | Sep 20, 2022 | Sep 20, 2022 | ["id", "tenant_code", "other_id", "name", "sync_time"] |
HubSpot Actors - API | ODS Dataset which generated from HubSpot Actors | Sep 20, 2022 | Sep 20, 2022 | ["id", "tenant_code", "other_id", "name", "avatar", "type", "email", "sync_time"] |
HubSpot Inboxes - API | ODS Dataset which generated from HubSpot Inboxes | Sep 20, 2022 | Sep 20, 2022 | ["id", "tenant_code", "other_id", "name", "created_at", "updated_at", "sync_time"] |
HubSpot Email Events - API | ODS Dataset which generated from HubSpot Email Events | Sep 28, 2022 | Sep 28, 2022 | ["id", "tenant_code", "other_id", "app_name", "duration", "user_agent", "created", "created_utc", "browser", "device_type", "location", "sent_by", "smtp_id", "recipient", "portal_id", "type", "filtered_event", "app_id", "email_campaign_id", "sync_time"] |
HubSpot Calls - API | ODS Dataset which generated from HubSpot Calls | Sep 29, 2022 | Sep 29, 2022 | ["id", "tenant_code", "other_id", "archived", "hs_activity_type", "hs_call_body", "hs_call_direction", "hs_call_status", "hs_call_title", "hs_created_by", "hs_created_by_user_id", "hs_createdate", "hs_lastmodifieddate", "hs_modified_by", "hs_object_id", "hs_product_name", "hs_updated_by_user_id", "hs_user_ids_of_all_owners", "hubspot_owner_assigneddate", "hubspot_owner_id", "created_at", "updated_at", "sync_time"] |
HubSpot Notes - API | ODS Dataset which generated from HubSpot Notes | Jun 08, 2023 | Jun 08, 2023 | ["id", "tenant_code", "other_id", "sync_time", "hs_attachment_ids", "hs_createdate", "hs_lastmodifieddate", "hs_object_id", "hs_timestamp", "hs_note_body", "hubspot_owner_id", "archived", "updated_at", "created_at"] |
HubSpot Notes - API | ODS Dataset which generated from HubSpot Notes | Jun 08, 2023 | Jun 08, 2023 | ["id", "tenant_code", "other_id", "sync_time", "hs_attachment_ids", "hs_createdate", "hs_lastmodifieddate", "hs_object_id", "hs_timestamp", "hs_note_body", "hubspot_owner_id", "archived", "updated_at", "created_at"] |
HubSpot Communications - API | ODS Dataset which generated from HubSpot Communications | Jun 08, 2023 | Jun 08, 2023 | ["id", "tenant_code", "other_id", "sync_time", "hs_attachment_ids", "hs_createdate", "hs_lastmodifieddate", "hs_object_id", "hs_timestamp", "hs_communication_body", "hs_communication_channel_type", "hs_communication_logged_from", "hubspot_owner_id", "archived", "updated_at", "created_at"] |
HubSpot Postal mail - API | ODS Dataset which generated from HubSpot Postal mail | Jun 08, 2023 | Jun 08, 2023 | ["id", "tenant_code", "other_id", "sync_time", "hs_attachment_ids", "hs_createdate", "hs_lastmodifieddate", "hs_object_id", "hs_timestamp", "hs_postal_mail_body", "hubspot_owner_id", "archived", "updated_at", "created_at"] |
HubSpot Feedback Submissions - API | ODS Dataset which generated from HubSpot Feedback Submissions | Jul 12, 2023 | Jul 12, 2023 | ["id", "tenant_code", "sync_time", "hs_createdate", "hs_content", "hs_ingestion_id", "hs_lastmodifieddate", "hs_object_id", "hs_response_group", "hs_sentiment", "hs_submission_name", "hs_survey_channel", "hs_survey_id", "hs_survey_name", "hs_survey_type", "hs_value", "created_at", "updated_at", "archived", "other_id"] |
HubSpot Ticket Pipelines - API | ODS Dataset which generated from HubSpot Ticket Pipelines | Dec 26, 2023 | Dec 26, 2023 | ["id", "tenant_code", "other_id", "label", "display_order", "archived", "created_at", "updated_at", "sync_time", "action"] |
HubSpot Deals Pipelines - API | ODS Dataset which generated from HubSpot Deals Pipelines | Dec 26, 2023 | Dec 26, 2023 | ["id", "tenant_code", "other_id", "label", "display_order", "archived", "created_at", "updated_at", "sync_time", "action"] |