I am trying to use the API to generate reports on Tickets that are unavailable in the HubSpot CRM.
It seems there is no way to filter Tickets by the API so I am having to grab them all and then filter afterwards.
This is taking a long time as there are over 7000 tickets in the system so we have to make 70 subsequent calls to https://api.hubapi.com/crm-objects/v1/objects/tickets/paged. I considered making parallel curl requests however this won't work as we need to do it sequentially in order to get the offset each time.
I considered locally caching tickets but that defeats the point of using Hubspot.
Does anyone know of a way of being able to filter Tickets by Company or date range? Or is there a way I'm missing where I can grab all of the Tickets in parallel to speed things up?
I realise the Tickets functionality is still in beta but would have thought there must be some filtering mechanism being used internally.