# 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/vkaEhArIITz4jrO22ymm" 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/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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.erathos.com/connectors/apis/hubspot.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.