Data Source - DataSpot
- Print
- PDF
Data Source - DataSpot
- Print
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
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.
idcreated_atupdated_at
Setting items
STEP1 Basic settings
| item name | indispensable | default value | Contents |
|---|---|---|---|
| HubSpot Connection Configuration | Yes | - | Select the preregistered HubSpot Connection Configuration that has the necessary permissions for this ETL Configuration. |
| Acquisition Target | Yes | object | Select the target of data acquisition from the following |
When an object is selected
| item name | indispensable | default value | Contents |
|---|---|---|---|
| object type | Yes | - | Select the object to be acquired.List of Selectable Objectscompanycontactdealproductticketline_itemquote |
| Transfer Method | Yes | Full Data Transfer | Select either Full Data Transfer or Incremental Data Transfer. For more information on Incremental Data Transfer, see Incremental Data Transfer Function. |
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 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.
If you select an association
| item name | indispensable | default value | Contents |
|---|---|---|---|
| object | Yes | --- | Select the object to be acquired.List of Selectable Objectscompanycontactdealproductticketline_itemquote |
| 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 Objectscompanycontactdealproductticketline_itemquote |
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 Objectscontactcompanydealownerworkflowticketcontentquote |
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 TypesSENTDROPPEDPROCESSEDDELIVEREDDEFERREDBOUNCEOPENCLICKPRINTFORWARDSTATUSCHANGESPAMREPORTFor more information on each event type, see Event types inHubSpot's official documentation - Email Events API 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 typesdealticket |
Was this article helpful?