# HubSpot

[HubSpot](https://www.hubspot.com) 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.

## Establishing Connection

Skyvia uses OAuth authentication for HubSpot. You need to simply sign in with HubSpot and select the account to use.

### Creating Connection

While [creating a connection](https://docs.skyvia.com/connections/#creating-connections), you need to perform the following steps:

1. Click **Sign In with HubSpot**.


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


3. Select your account to use and click **Choose Account**.


4. On the opened page, click **Connect app** to approve the access request.


5. After this, you can save the connection.

### Additional Connection Parameters

#### Metadata Cache

You can specify the period of time, after which [Metadata cache](https://docs.skyvia.com/connections/metadata-cache.html) is considered expired.

#### Batch API

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. The **Batch API** checkbox in the **Advanced Settings** controls using Batch API via the connection.

Batch API allows much higher performance and lower API call use, but also provides less information about the success or error of an 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](https://docs.skyvia.com/data-integration/import/) success logs and won’t be able to use the [Import Returning](https://docs.skyvia.com/data-integration/import/#returning) feature.

Additionally, you cannot use Batch API with [synchronization](https://docs.skyvia.com/data-integration/synchronization/) packages, because synchronization relies on obtaining inserted record ids to establish correspondence between source and target records. Thus, if you plan to use a HubSpot connection for synchronization of HubSpot Contacts, Companies, Tickets, or Products or use the Returning import feature for obtaining record ids when loading data to these objects, **you need to turn off Batch API for this connection**.

#### Custom Objects

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** checkbox in the **Advanced Settings** to work with custom objects.

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

## Supported Actions and Actions Specifics

Skyvia supports all the [common actions](https://docs.skyvia.com/data-integration/actions.html#common-actions), available for most of the connectors, for HubSpot.

## Data Integration Tutorials

You can read the following tutorial on HubSpot - Zoho CRM integration: [How to Import Deals and Contacts from Zoho CRM to HubSpot Preserving Relations](https://docs.skyvia.com/data-integration/tutorials/import-tutorials/how-to-import-deals-and-contacts-from-zoho-crm-to-hubspot-preserving-relations.html)

## Troubleshooting

### Hapikey Does Not Have Proper Permissions!

If you have such an error, probably you are trying to access a paid HubSpot product feature that you are not paying for.

For example, see the following links at the HubSpot community portal:

https://integrate.hubspot.com/t/api-error-this-hapikey-does-not-have-proper-permissions/8244
https://integrate.hubspot.com/t/this-hapikey-xxxx-does-not-have-proper-permissions/6484/6
https://integrate.hubspot.com/t/no-proper-permissions/2188/2

### 414 Request-URI Too Large

Such an error means that there are too many custom fields in the object you are querying. You need to exclude some fields from the query (or replication, backup, or export - depending on where you get this error).