We are migrating away from local copy of hubspot data to present tickets to our users and trying to use API endpoints. I got blocked multiple times by search endpoint limitations and is really a frustrating experience so far.
While using a filter with IN operator, I am limited to an array of 100 values. Splitting the filter/requests and stitching the results afterwards seems like an expensive yet complex process at this point due to our reliance on filter, pagination and sorting. Is there any way to get pass this limitation? I could not find this anywhere in API documentation which would have helped us deter from this path early on.