Custom objects count (without paginating all objects)

[crossbill]

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: Accounts Dashboard | HubSpot

[weiliang_lee]

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

WL

[storycollab]

Is this fix still operational?

[Mike_Eastwood]

Thank you @weiliang_lee

That’s a useful hack!

Mike