Skip to content

HubSpot

HubSpot is a customer relationship management software that helps businesses attract visitors, connect with customers, and close deals.

ingestr supports HubSpot as a source.

URI format

The URI format for HubSpot is as follows:

plaintext
hubspot://?api_key=<api-key-here>

URI parameters:

  • api_key: The API key is used for authentication with the HubSpot API.

The URI is used to connect to the HubSpot API for extracting data.

Setting up a HubSpot Integration

HubSpot requires a few steps to set up an integration, please follow the guide dltHub has built here.

Once you complete the guide, you should have an API key. Let's say your API key is pat_test_12345, here's a sample command that will copy the data from HubSpot into a DuckDB database:

sh
ingestr ingest --source-uri 'hubspot://?api_key=pat_test_12345' --source-table 'companies' --dest-uri duckdb:///hubspot.duckdb --dest-table 'companies.data'

The result of this command will be a table in the hubspot.duckdb database.

Tables

HubSpot source allows ingesting the following sources into separate tables:

TablePKInc KeyInc StrategyDetails
companies-replaceRetrieves information about organizations.
contacts-replaceRetrieves information about visitors, potential customers, and leads.
deals-replaceRetrieves deal records and tracks deal progress.
tickets-replaceHandles requests for help from customers or users.
products-replaceRetrieves pricing information of products.
quotes-replaceRetrieves price proposals that salespeople can create and send to their contacts.
schemasidmergeReturns all object schemas that have been defined for your account.

Use these as --source-table parameter in the ingestr ingest command.

WARNING

Hubspot does not support incremental loading, which means ingestr will do a full-refresh.