> For the complete documentation index, see [llms.txt](https://docs.erathos.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.erathos.com/connectors/apis/hubspot.md).

# HubSpot

## Using the Erathos platform:

### Creating a data pipeline with HubSpot data

#### Connect to HubSpot

* Using Erathos click in **explore** **data sources** or in connectors on the left side menu (the second icon).

<figure><img src="/files/3C8BT8XnzNVD8eqPihhm" alt=""><figcaption></figcaption></figure>

* Select HubSpot connector and name your connection

<figure><img src="/files/yFlInPrvZ4wWixHoKSDX" alt=""><figcaption></figcaption></figure>

When selecting HubSpot as a new connector on the Erathos platform, you will need to authorize the connection by simply logging into the HubSpot account associated with your browser.

Just click on '**Authorize integration**' as shown in the attachment below:

<figure><img src="/files/qRpNB3l668HXnNEG9tYf" alt=""><figcaption></figcaption></figure>

* Select the proper HubSpot account

<figure><img src="/files/OG1s9guPZyYfsEKUWpHZ" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/ocJ886HV3G8KY1RwiW4b" alt=""><figcaption></figcaption></figure>

* Connect app

<figure><img src="/files/CM1AqrKxp8U0joEEZpi2" alt=""><figcaption></figcaption></figure>

Don't forget to click on **Save and test** to advance to the next steps of the integration.

<figure><img src="/files/CSDLZPuLpSc0RzSsPYbu" alt=""><figcaption></figcaption></figure>

#### Manage Jobs

With this connection created you can seemlessly move your HubSpot data to your BigQuery, Redshift or Postgres data-warehouse.

* Click in manage jobs to select endpoints and schedule pipeline runs.
* Name your schema

  * Your schema name is where all the tables will be created (you won't be able to change this later)

  <figure><img src="/files/dkTigvKSjLuMOgMZr0Qj" alt=""><figcaption></figcaption></figure>
* Activate jobs
  * Select a [sync frequency](https://docs.erathos.com/platform/connections/sync-schedule#frequency)
  * Select a [sync type](https://docs.erathos.com/platform/connections/sync-types)
  * Select a [sync time](https://docs.erathos.com/platform/connections/sync-schedule#frequency)
* Select fields (optional)
  * Click "Open" beside the endpoint name to see all the fields available
  * If you don't to this, all the fields will be selected automatically.

<figure><img src="/files/PkFoQBwHh6YyqwbLRTUB" alt=""><figcaption></figcaption></figure>

* All the tables in your data warehouse will be the same as the endpoint name

#### Create a destination

* Click in settings on the left side menu
* Go to destination in the workspace menu
* Select the chosen destination and fill the necessary information to connect
  * [BigQuery self hosted](https://docs.erathos.com/destinations/bigquery)
  * [BigQuery hosted by Erathos](/destinations/what-is-a-destination/bigquery/hosted-by-erathos.md) (in case that you don't have a data warehouse yet)
  * [Databricks](https://docs.erathos.com/destinations/databricks)
  * [PostgreSQL](https://docs.erathos.com/destinations/postgresql)
  * [Redshift](https://docs.erathos.com/destinations/redshift)
  * [S3 Iceberg](https://docs.erathos.com/destinations/s3-iceberg)

{% hint style="warning" %}
If you use 'bulk actions' to change properties in HubSpot, we recommend manually executing a Full Refresh afterward. The HubSpot API does not properly update the 'updated\_at' field when bulk actions are performed, which can lead to inconsistencies in the API response."
{% endhint %}

### Disconnect the app

* Login and click on the HubSpot connection

<figure><img src="/files/lmtdES3YciSv3XbFOPgD" alt=""><figcaption></figcaption></figure>

* Go to the settings tab
* Delete connection

  <figure><img src="/files/5HS6g3bTlTF2nPTrw3uC" alt=""><figcaption></figcaption></figure>

**Note:** If you delete the connection you will still have access to the data in your destination, but it will not be up-to-date anymore.

* You can also uninstall the app in HubSpot, please check the "Uninstall an app" topic on the following documentation: [Uninstall an app](https://knowledge.hubspot.com/integrations/connect-apps-to-hubspot?_ga=2.94035293.1315053923.1752660941-1718272043.1752660941#uninstall-an-app)

## What endpoints can I access with the Erathos platform?

* communications
* deal\_history
* contacts\_tickets\_associations
* contacts\_deals\_associations
* feedback\_submissions
* line\_items
* products
* quotes
* goal\_targets
* calls
* emails
* meetings
* notes
* postal\_mail
* tasks
* owners
* deals\_pipelines
* tickets\_pipelines
* companies
* deals\_tickets\_associations
* deals
* contacts
* tickets
* companies\_tasks\_associations
* companies\_calls\_associations
* deals\_tasks\_associations
* deals\_calls\_associations
* companies\_contacts\_associations
* companies\_deals\_associations
* companies\_tickets\_associations
* contacts\_meetings\_associations
* contacts\_calls\_associations
* contacts\_emails\_associations
* contacts\_communications\_associations
* tickets\_meetings\_associations
* tickets\_calls\_associations
* tickets\_emails\_associations
* tickets\_communications\_associations
* analytics\_reports\_sources
* analytics\_reports\_sources\_breakdowns
* marketing\_emails
* form\_submission