Connecting to HubSpot

HubSpot is an all-in-one cloud CRM, sales, and marketing platform.

Data integration: Skyvia supports importing data to and from HubSpot, exporting HubSpot data to CSV files, replicating HubSpot data to relational databases, and synchronizing HubSpot data with other cloud apps and relational databases.

Backup: Skyvia Backup supports HubSpot backup.

Query: Skyvia Query supports HubSpot.

HubSpot Connections

Skyvia supports HubSpot connection via both API key and OAuth 2.0 authentication.

To connect to HubSpot using API Key authentication, you need to specify the HubSpot API key. For the information on how to get a HubSpot API key, visit this HubSpot knowledgebase article.

Connection Editor window

To connect to HubSpot using OAuth authentication, you need to perform the following steps:

  1. Click +NEW in the top menu.
  2. Open the Select Connector page by clicking Connection in the menu on the left.
  3. In the opened page, click HubSpot.
  4. In the Connection Editor page, specify a connection name that will be used to identify the connection and select OAuth 2.0 in the Authentication list.
  5. Click Log In with HubSpot.

    Connection Editor window

  6. In the opened window, enter your HubSpot credentials and click Log in.

    HubSpot Login window

  7. Select your account to use.

    Choose an Account window

  8. In the opened page, click Grant access to approve access request.

    Permission window

  9. Change the value for the Metadata cache parameter if needed (optional) on the Connection Editor page.
  10. Click Create Connection.

You can also optionally change a value for the Metadata Cache parameter. This parameter determines how often the cached metadata are updated. By default, Skyvia caches metadata of available objects in cloud sources. When creating a connection, you can configure how often cache is refreshed or, when the connection already exists, you can reset it manually on the Connection Editor page by clicking the Clear Cache button. The following values are available for this setting:

  • Disabled — metadata cache is not created; metadata are queried automatically whenever the connection is opened.
  • One Hour — metadata cache expires one hour after the last refresh; it is refreshed when the connection is opened again.
  • One Day — metadata cache expires one day after the last refresh; it is refreshed when the connection is opened again.
  • One Week — metadata cache expires one week after the last refresh; it is refreshed when the connection is opened again.
  • One Month — metadata cache expires one month after the last refresh; it is refreshed when the connection is opened again.
  • Infinite — cache is never reset automatically. Default value.