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.

 

Skyvia supports HubSpot connections via API key or OAuth 2.0 authentication.

hubspot-connection-new

 

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

 

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

1.Open the Connections page by clicking Connections in the menu on the left side of the page.
2.Click the New button.
3.In the opened pane click HubSpot.
4.In the opened New Connection dialog box, 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.
 
hubspot-connection-oauth
6.In the opened window, enter your HubSpot credentials and click Login.
 
hubspot-connection-login2
7.Select your account to use.
 
hubspot-connection-select-account
8.(Optional) Change the value for the Metadata cache parameter if needed.
9.Click Save.

 

You can also optionally change a value for the Metadata Cache parameter. This parameter determines how often to update cached metadata for the connection. By default, Skyvia caches metadata of available objects for cloud sources. You can configure how often the cache is refreshed automatically or reset in manually on the Connection Details page of the corresponding connection by clicking the Clear link in the Metadata cache parameter in the Parameters pane. The following values are available for this setting:

oDisabled - the metadata cache is not created, and metadata are queried automatically whenever the connection is opened.
oOne Hour - the metadata cache expires after one hour since the previous refresh, and it is refreshed after this when the connection is opened.
oOne Day - the metadata cache expires after one day since the previous refresh, and it is refreshed after this when the connection is opened.
oOne Week - the metadata cache expires after one week since the previous refresh, and it is refreshed after this when the connection is opened.
oOne Month - the metadata cache expires after one month since the previous refresh, and it is refreshed after this when the connection is opened.
oInfinite - the cache is never reset automatically. Default value.