HubSpot ETL Source

See the Connector Marketplace topic. Please request your administrator to start a trial or subscribe to the Premium HubSpot connector.

With Gathr’s HubSpot Data Source, you can read data from your HubSpot account.

Schema Type #

See the topic Provide Schema for ETL Source → to know how schema details can be provided for data sources.

After providing schema type details, the next step is to configure the data source.

Data Source Configuration #

Each configuration property available in the HubSpot data source is explained below.

Connection Name: Connections are the service identifiers. A connection name can be selected from the list if you have created and saved connection details for HubSpot earlier. Or create one as explained in the topic - HubSpot Source Connection →

Table Name: The HubSpot table to be read should be selected.

Fields: Select the fields that are required to be read.

Additional Query Options: Limit the maximum number of records to be fetched from the selected table using the additional query options.

• Limit: Set this option to limit the maximum number of records to be fetched. It must be in range [0…100]

• After: The count of initial records to be skipped while reading data from a HubSpot table should be provided. This endpoint is limited to 10000 total results for any given query.

Filter Groups: Useful to fetch specific records by providing filter criteria. Either draft queries using the intuitive Designer mode or provide queries in the Editor in a JSON format.

• Use Designer to provide queries.

  • Select a field on which the filter query should be applied.

  • Select the operator to be applied to the data.

    Example: Less than, Not equal to, and so on.

  • Provide a value as per the operator selected.

  • Add Filter: Additional filter conditions can be added with And Condition.

  • Add group: Additional filter groups can be added with Or Condition.

  👉

  You can include a maximum of three Filter Groups with up to three filters in each group.
  👉

  If incremental read option is to be used in the data source, a maximum of two filters can only be used in each filter group. Incremental Read is counted as one filter in each filter group.
  💡

  Queries prepared in Designer mode can be automatically transformed to JSON format if switched to Editor mode while designing, and vice-a-versa.

Sort By: The records that are fetched from the table will be sorted with reference to the field selected. Only one sorting rule can be applied to any search.

Enable Parallel Read: The number of requests that should be triggered per second, in parallel.

If Enable Parallel Read option is enabled, then by default the Retry Count is three, and the Retry Interval is One Second. You can pass the retryCount and retryInterval keys in the Add Configuration option to override the default values.

Max no. of requests per sec: The number of read requests to be triggered in parallel. The minimum value should be 1.

Add Configuration: Additional properties can be added using this option as key-value pairs.

Detect Schema #

Check the populated schema details. For more details, see Schema Preview →

Incremental Read #

Optionally, you can enable incremental read. For more details, see HubSpot Incremental Configuration →

Pre Action #

To understand how to provide SQL queries or Stored Procedures that will be executed during pipeline run, see Pre-Actions →

Notes #

Optionally, enter notes in the Notes → tab and save the configuration.

Limitations #

To understand the limitations in HubSpot, please refer to the link below:

HubSpot Limitations