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

To connect to HubSpot, 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.
  5. Click Sign 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. If you plan using this connection for synchronizing HubSpot Contacts, Companies, Tickets, or Products, click Advanced Settings and clear the Use Batch API checkbox.
  11. Click Create Connection.

You can also optionally change a value for the Metadata Cache parameter. This parameter determines for how long the cached metadata for the connection are considered valid. By default, Skyvia caches metadata of available objects in cloud sources. Whenever necessary, you can reset metadata cache for a connection manually in the Connection Editor by clicking the Clear now link. The following values are available for this parameter:

  • Disabled — metadata cache is not created; metadata are queried automatically whenever required.
  • One Hour — metadata cache expires one hour after the last refresh.
  • One Day — metadata cache expires one day after the last refresh.
  • One Week — metadata cache expires one week after the last refresh.
  • One Month — metadata cache expires one month after the last refresh.
  • Infinite — cache never expires/resets automatically. Default value.

How to Delete Hubspot Connection

You can delete a Hubspot connection at any time. This won’t affect your Hubspot data. You will be able to create the same connection again.

To delete Hubspot connection, do the following:

Delete hubspot connection

  1. Navigate to Connection objects in Skyvia.
  2. Click on the Hubspot connection.
  3. Click bin icon on the upper right.

Batch API Support

Skyvia supports HubSpot Batch API to load data into Contacts, Companies, Tickets, and Products objects. It uses Batch API for loading data to these objects by default. This allows much higher performance and lower API call use, but also provides less information about success or error of the operation. For example, Batch API does not return the ids of inserted records. Thus, when using batch API, you won’t get the ids of inserted records in Import success logs and won’t be able to use the Import Returning feature.

Additionally, you cannot use Batch API with synchronization packages, because synchronization relies on obtaining inserted record ids to establish correspondence between source and target records. Thus, if you plan using a HubSpot connection for synchronization of HubSpot Contacts, Companies, Tickets, or Products or using the Returning import feature for obtaining record ids when loading data to these objects, you need to turn off Batch API for this connection. You can do it in the connection Advanced Settings.

Custom Objects Support

HubSpot allows enterprise customers to create custom objects and store data in them. Skyvia supports HubSpot custom objects - it can load data from and to them. Custom object support is not enabled by default. You need to explicitly select the Use Custom Objects in the connection Advanced Settings to work with custom objects.

Besides, if you change this setting for an existing connection, you need to clear the connection metadata. You can do it by clicking the Clear now link. If changes are made to the custom objects metadata, you also need to clear metadata cache of the connection in order for Skyvia to detect these changes.

Supported Actions and Actions Specifics

HubSpot connector supports the following actions: