offset / search api / more than 10000 results

Developer Support APIs & Integrations
5

Actually, sorry nevermind. There’s a limit to how many you can have in a NOT_IN filter and also the initial request would be too long to process anyway.

I did however run into this:

https://community.hubspot.com/t5/APIs-Integrations/How-to-fetch-more-than-10-000-records-using-Hubspot-API/m-p/571539#:~:text=Once%20the%20after%20value%20reaches,need%20to%20restart%20your%20loop.

So the idea is to use the object ID as a marker

{

“propertyName”: “hs_object_id”,

“operator”: “GT”,

“value”: “{last id stored value (default to 0)}”

}

and grab the next set of 10000 from that (assuming you’re grabbing in ascending order of ID rather than any other search)