topic Re: Custom objects count (without paginating all objects) in APIs & Integrations

Custom objects count (without paginating all objects)

crossbill — Thu, 01 Dec 2022 17:40:24 GMT

Is there an API endpoint available that allows me to get the total count of custom objects for a particular schema, without paginating through all the objects using the "crm/v3/objects/{objectType"?

For example, would be great if in the payload sent back from endpoint (above), an additional field would be included like:

page: { next: null},total_count: 35000

I suspect there's probably some sort of API (perhaps internally available to hubspot only) that reveals the total count, given that at the top of the Hubspot console page/dashboard, the total count of items is displayed. Without that scalar value (total count) available, we would be required to pagination through all pages, an expensive operation (in terms of number of API calls) since each request permits only 100 records to be returned at a time...so if we have 30000 custom objects, we'd need to issue 300 API calls.

Source: https://developers.hubspot.com/docs/api/crm/crm-custom-objects

Re: Custom objects count (without paginating all objects)

weiliang_lee — Fri, 02 Dec 2022 02:41:26 GMT

Hi there,

Try using the search endpoint:

/crm/v3/objects/{object}/search

Using the Contacts Object as an example, the List endpoint doesn't give the total count indeed. But using the Search endpoint, the payload would include the "total" property. (You can use the Search endpoint and provide an empty body in the request, that would net the same results as doing a List).

Cheers

Re: Custom objects count (without paginating all objects)

storycollab — Tue, 12 Mar 2024 22:54:04 GMT

Is this fix still operational?

Re: Custom objects count (without paginating all objects)

Mike_Eastwood — Mon, 17 Feb 2025 03:48:20 GMT

Thank you @weiliang_lee

That's a useful hack!

Mike