The CData Excel Add-In for HubSpot models HubSpot entities as relational Tables, Views, and Stored Procedures. API limitations and requirements are documented in this section; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.

Using HubSpot API

See HubSpot Data Model for the available entities in the HubSpot API.

Using HubSpot V3 API

See HubSpot V3 Data Model for the available entities in the HubSpot V3 API.

Using HubSpot V4 API

See HubSpot V4 Data Model for the available entities in the HubSpot V4 API.

Batch Operations

The maximum batch size supported by HubSpot's API is 10, so that is the recommended value for the BatchSize connection property as well. Using a value bigger than that is not recommended, since it won't improve the performance of the add-in in any way.