--- title: "HubSpot" slug: "hubspot" description: "Get the most out of your HubSpot data with Dataddo. Easily access all available metrics, load historical records, and create a secure & reliable data pipeline." updated: 2023-12-14T14:38:21Z published: 2023-12-14T14:38:21Z --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.dataddo.com/llms.txt > Use this file to discover all available pages before exploring further. # HubSpot **HubSpot** is an all-in-one inbound marketing, sales, and customer service platform designed to help businesses attract, engage, and delight customers. It offers a suite of tools and features for managing marketing campaigns, generating leads, nurturing customer relationships, and providing support, making it a comprehensive solution for businesses looking to grow and manage their customer base. Each of the objects has different metrics. Refer to HubSpot's official documentation to see [all available endpoints from the HubSpot API](https://developers.hubspot.com/docs/api/overview). Custom Fields and Objects **Custom fields** are supported for all objects. **Custom objects** are currently being added to the connector and are not yet supported out of the box. If you need data from a HubSpot custom object, contact our Solutions team with the name of the object. We will add the ***data source*** manually for you. ## HubSpot and HubSpot Analytics Connectors Difference The **HubSpot** connector is for CRM data (contacts, deals, tickets etc.) whereas the [**HubSpot Analytics**](/docs/hubspot-analytics) connector is for analytics data (about landing pages, content, blog posts, website performance and other). Another difference is that it is possible to extract ihstorical data for HubSpot Analytics. For HubSpot, you can only use extraction timestamps to [**build a time series**](/docs/hubspot#no-historical-data). ## Authorize Connection to HubSpot To authorize this service, use **OAuth 2.0** to share specific data with Dataddo while keeping usernames, passwords, and other information private. 1. On the **Authorizers** page, click on [Authorize New Service](https://app.dataddo.com/service/new) and select your service. 2. Follow the on-screen prompts to grant Dataddo the necessary permissions to **access and retrieve** your data. 3. **[Optional]** Once your ***authorizer*** is created, click on it to **change the label** for easier identification. Ensure that the account you're granting access to holds at least **admin-level permissions**. If necessary, assign a team member with the required permissions with the [authorizer role](https://docs.dataddo.com/docs/user-roles#authorizer) to authenticate the service for you. For more information, see our article on [***authorizers***](https://docs.dataddo.com/docs/authorized-services). ## How to Create a HubSpot Data Source 1. On the **Sources** page, click on the [**Create Source**](https://app.dataddo.com/sources/new) button. 2. Select the connector from the list and name your ***data source***. 3. On the **Dataset** step, select your **dataset**. **DATADDO TIP** If you're unsure which dataset to select, use the search bar to look for datasets with the desired attributes or metrics. 4. On the **Account** step select your ***authorizer*** from the drop-down menu. **Didn't find your authorizer?** Click on **Add new Account** at the bottom of the drop-down and follow the on-screen prompts. You can also go to the **Authorizers** tab and click on [**Add New Service**](https://app.dataddo.com/service/new). 5. On the **Attributes and Metrics** step, select the **metrics and attributes** you want to extract. ![Create a source using a custom-schema connector.](https://cdn.document360.io/084ed225-3f99-4644-a2da-39ca0cd5ef45/Images/Documentation/Create%20Source%20-%20Custom-Schema%20Connector.png) 6. On the **Metadata** step, select which [**metadata fields**](/docs/metadata-inclusion) such as extraction time to add to your data. 7. On the **Snapshot** step: 1. Configure your [**sync frequency**](/docs/extraction#extraction-frequency) or click **Show advanced settings** to set the exact synchronization time. 2. [Optional] Enable the **Allow Empty Data Extractions** toggle to allow the extraction when no data is available. 8. In the top-right corner, click **Test Data** button to preview extracted data. **Adjust the date range** for a more specific time frame. 9. Click on **Save** and **congratulations, your new data source is ready!** ### Use Data Blending to Associate IDs and Names We recommend using the [data blending](/docs/data-blending) feature when creating a [***data flow***](/docs/how-to-create-a-data-flow) to have IDs and names in the same table. The most common use cases are: **Owner ID and owner name:** - Create an additional ***data source*** using the **Owners** object and add the following properties: - **Owner ID** - **Owner Last/First name** - Blend your two sources using **Owner ID** as the join key. **Stage ID and stage name:** - Create an additional ***data source*** using the **Deals Pipelines** object and add the following properties: - **Stage ID** - **Stage Label** - Blend your two sources using **Stage ID** as the join key. --- ## Limitations ### No Historical Data It's not possible to load your historical data as the HubSpot API only allows extraction of the full list of selected contacts or deals. However, you can **keep daily snapshots** by selecting an **object**. To keep track of historical records, you can 1. Add **Dataddo extraction timestamp** to your data, and 2. Choose to **append** your data to build your time series. For more information on loading historical data, refer to our [data backfilling guide](/docs/data-backfilling). ## Troubleshooting ### Data Preview Unavailable No data preview when you click on **Test Data** might be caused by an issue with your ***source*** configuration. The most common causes are: - **Date range**: Try a smaller date range. You can load the rest of your data afterward via [manual data load](https://docs.dataddo.com/docs/data-backfilling). - **Insufficient permissions**: Please make sure your authorized account has at least admin-level permissions. ### Retrieve Object ID To get your **Object ID**, in your HubSpot account 1. Navigate to **Settings**. 2. Under the **Data Management** section, unroll **Objects**, and click on **Custom Objects**. 3. Your Object ID will be in **the last part of the URL**, starting with **2-**, for example, https://app.hubspot.com/sales-products-settings/yourcustomerID/object/**2-12345678**. ### Uninstall the Integration When you disconnect your HubSpot account in Dataddo, **all your customer data related to HubSpot will be deleted from your account**. This does not affect the HubSpot data already loaded into your destination (i.e. dashboard or data warehouse). When u**ninstalling the app through the HubSpot administration**, it is still recommended to delete any HubSpot sources or flows in Dataddo (the data does not get deleted unless the sources are deleted or your account gets disabled). To uninstall the Dataddo and HubSpot integration, you can choose one of the following methods. #### 1. Disconnect your HubSpot account In the [Authorizers](https://app.dataddo.com/authorizers) tab, delete the authorized HubSpot service. As a result, all Dataddo's permissions to extract data from your HubSpot account will be removed. Please note that you will first need to delete **all sources and flows** using HubSpot. #### 2. Delete the installed Dataddo app in your HubSpot administration 1. In your HubSpot account, navigate to Settings. 2. Under Account Setup, unroll the Integrations section and click on **Connected Apps**. 3. Locate the Dataddo app and click on **Actions - Uninstall**. No further data can get extracted and your HubSpot sources in Dataddo will get broken. However, the data already extracted until that point will stay in Dataddo until you delete your HubSpot sources (or until your Dataddo account is disabled). ## Related Articles Now that you have successfully created a ***data source***, see how you can connect your data to a dashboarding app or a data storage. **Sending Data to Dashboarding Apps** - [Simple Data Integration to Dashboards](https://docs.dataddo.com/docs/simple-data-integration-to-dashboards) - [Data Backfilling to Dashboarding Apps](https://docs.dataddo.com/docs/data-backfilling-to-dashboarding-apps) **Sending Data to Data Storages** - [Batch Ingestion to Data Warehouses](https://docs.dataddo.com/docs/ingestion-to-data-warehouses) - [Data Backfilling to Storages](https://docs.dataddo.com/docs/data-backfilling-to-storages) **Other Resources** - [Troubleshooting](https://docs.dataddo.com/docs/troubleshooting) - [Extraction Logs](https://docs.dataddo.com/docs/extraction-logs) - [Data Duplication](https://docs.dataddo.com/docs/data-duplication) A source is a collection of data from an authorized service that's been connected via a Dataddo connector. Data within the source is automatically refreshed based on the source's configuration. Authorizers act as credentials for external services (e.g. Facebook or Google). To enable Dataddo to access and retrieve your data, you need to grant access to accounts that possess admin-level permissions or higher within these services. Data flows allow you to orchestrate the integration of your data from various sources to your desired destinations. You may add multiple data sources with the same schema to one flow to merge data for a consolidated output.