---
title: "Data Source - DataSpot"
slug: "data-source-hubspot"
updated: 2026-03-25T09:45:12Z
published: 2026-03-25T09:45:12Z
canonical: "documents.trocco.io/data-source-hubspot"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documents.trocco.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Data Source - DataSpot

## summary

Help Page for ETL Configuration of Data Setting from HubSpot.

## constraints

              Additional information when using custom properties

              

- Data Source HubSpot obtains some of the metadata on the HubSpot side and internally defines Column Setting and Data Type.
- If a custom property is created on the HubSpot side, the internal name of the custom property and the Column Setting name defined on the TROCCO side may overlap.
- When an **object** is selected for retrieval, if a custom property with the following internal name is created on the HubSpot side, **the data on the custom property side will be retrieved.**
  - `id`
  - `created_at`
  - `updated_at`

## Setting items

### STEP1 Basic settings

| item name | indispensable | default value | Contents |
| --- | --- | --- | --- |
| HubSpot Connection Configuration | Yes | - | Select the preregistered [HubSpot Connection](/docs/connection-configuration-hubspot) Configuration that has the necessary permissions for this ETL Configuration. |
| Acquisition Target | Yes | object | Select the target of data acquisition from the followingobjectAssociations (relationships between objects)Engagements (Legacy)Engagement Associations (relationships between objects)Email Eventpipelinepipeline stageperson in charge (of an area of work, but not necessarily supervising other staff) |

#### When an object is selected

| item name | indispensable | default value | Contents |
| --- | --- | --- | --- |
| object type | Yes | - | Select the object to be acquired. **List of Selectable Objects** `call``company``contact``deal``email``line_item``meeting``note``postal_mail``product``quote``task``ticket`custom object |
| Properties to Import | No | - | Select the properties to import. If none are selected, all properties will be imported. Click **Load Properties** to load the list of properties for the selected object type. |
| Transfer Method | Yes | Full Data Transfer | Select either **Full Data Transfer** or **Incremental Data Transfer**. For more information on [Incremental Data Transfer](/docs/incremental-data-transfer), see [Incremental Data Transfer Function](/docs/incremental-data-transfer). |

              Incremental Data Transfer for Data Source HubSpot

              

If **Incremental Data Transfer is** selected at **Data** Source HubSpot, **records updated since the last transfer** will be transferred. Therefore, if `Data Dest` ination uses the `APPEND` method of transfer, duplicate records may occur. Please note

If you want to transfer data without duplicate records to a [Data](/docs/how-to-merge-updated-rows-to-master-table-on-dwh) Destination that does not have `UPSERT or``MERGE as` a transfer mode, such as Google BigQuery, please refer to [Efficiently Updating Master Tables on DWH without Duplicate Records](/docs/how-to-merge-updated-rows-to-master-table-on-dwh).

#### If you select an association

| item name | indispensable | default value | Contents |
| --- | --- | --- | --- |
| object | Yes | --- | Select the object to be acquired. **List of Selectable Objects** `company``contact``deal``product``ticket``line_item``quote`custom object |
| association-object | Yes | - | Select the association object associated with the selected object. **Up to 100** association objects are retrieved for each object. **List of Selectable Association Objects** `company``contact``deal``product``ticket``line_item``quote`custom object |

#### If you choose an association of engagement

| item name | indispensable | default value | Contents |
| --- | --- | --- | --- |
| association-object | Yes | - | Select the association object associated with the engagement. **Up to 100** association objects are retrieved for each engagement. **List of Selectable Association Objects** `contact``company``deal``owner``workflow``ticket``content``quote` |

#### If an email event is selected

| item name | indispensable | default value | Contents |
| --- | --- | --- | --- |
| event type | Yes | - | Select the event type to be retrieved. **List of Selectable Event Types** `SENT``DROPPED``PROCESSED``DELIVERED``DEFERRED``BOUNCE``OPEN``CLICK``PRINT``FORWARD``STATUSCHANGE``SPAMREPORT` For more information on each event type, see `Event types in`[HubSpot's official documentation - Email Events API Overview.](https://legacydocs.hubspot.com/docs/methods/email/email_events_overview) |
| Data acquisition period | No | - | You can enter the start and end dates and times of the data you wish to retrieve. |

#### If pipeline or pipeline stage is selected

| item name | indispensable | default value | Contents |
| --- | --- | --- | --- |
| object type | Yes | - | Select the object type of the pipeline to be acquired. **List of selectable object types** `deal``ticket` |