Excel Add-In for HubSpot

Build 25.0.9434

Pagesize

Specifies the maximum number of records to retrieve per page when querying data from HubSpot.

Data Type

int

Default Value

-1

Remarks

This property controls the page size used in API calls to HubSpot and can be tuned based on the type of data being queried. The effective default and maximum values vary by object type and API endpoint:

  • Search API (HubSpotV3): The default value is 100. The maximum value is 200.
  • PropertiesHistory views (HubSpotV3 and HubSpotV4): The default value is 50. The maximum value is 50.
  • Lists (HubSpotV3): The default value is 100. The maximum value is 500.
  • ListMemberships (HubSpotV3): The default value is 100. The maximum value is 250.
  • Association tables (HubSpotV4); when the Id and Type columns are present in the criteria and ExpandAssociations is disabled, or when the Id column is present in the criteria and ExpandAssociations is enabled: The default and maximum value is 500.
  • All other cases (HubSpotV3 and HubSpotV4): The default and maximum value is 100.
Note: This property is supported only in the HubSpotV3 and HubSpotV4 schemas.

Performance Considerations

Larger page sizes reduce the number of API calls required to retrieve data but may increase memory usage and response time per request. Smaller values may be more reliable when working with large datasets or limited bandwidth environments.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434