topic Re: Increase the limit parameter in Get all companies in APIs & Integrations

Increase the limit parameter in Get all companies

Kumarp1 — Mon, 09 Sep 2019 09:48:17 GMT

I have more than 6000 companies in HubSpot and i want to get all companies while hitting the Get all companies API. Currently i can get Max 250 companies at a time. Please suggest me how can i manage such kind of situation.

Re: Increase the limit parameter in Get all companies

WendyGoh — Tue, 10 Sep 2019 02:44:14 GMT

Hi @Kumarp1,

I hope all is well with you 😄

When looking to get all companies using this endpoint here: Get all companies there is a maximum value of 250 return limit. The reason behind having a limit is because there may be portals with significant number of contacts and returning all of them in a single request would result in timeouts and/or huge response sizes.

That said, your team can look into using a if statement to gather all the companies records. If the has-more value is true, it means that there's another page of company records and for that you can use the offset value to get to the next page.

E.g.:

https://api.hubspot.com/companies/v2/companies/paged?portalId={{portal_id}}&offset=2100755540

Hope this helps to clarify!

Re: Increase the limit parameter in Get all companies

Kumarp1 — Tue, 10 Sep 2019 17:48:49 GMT

Hi WendyGoh

Thankyou so much for your support.

Re: Increase the limit parameter in Get all companies

Kishore — Sat, 03 Oct 2020 20:41:56 GMT

Hi WendyGoh,

do we have to change Offset values very time at endpoint ? Or it takes automatically?

i have same problem, i have 3357 companies records , incase if we have to change offsetvalue manually every time at endpoint then what is the use of API if we do manually ??

please help me with your reply.

Re: Increase the limit parameter in Get all companies

Kishore — Sat, 03 Oct 2020 21:05:14 GMT

Hi Kumar,

how did you achive it please help me

i have same problem, i have 3357 companies records , incase if we have to change offsetvalue manually every time at endpoint then what is the use of API if we chnage offset manually ??

please help me with your reply.

Re: Increase the limit parameter in Get all companies

WendyGoh — Mon, 05 Oct 2020 08:22:06 GMT

Hey @Kishore,

As mention on this documentation here:

each request will also return two values, offset and has-more. If has-more is true, you'll need to make another request, using the offset to get the next page of company records. These are often used with a recursive function in order to get all companies stored in a CRM.

For instance, if you've 300 companies in your portal and your team is looking to get all 300 companies records using the Get all companies endpoint:

1. The first API call will return a maximum number of result - 250 (if the limit is set to 250)
i.e.
GET companies/v2/companies/paged?limit=250

Assuming, the has-more is true and the offset value is 4552438489

2. On the second API call, you would need to include the offset value on the request url to page to the second page
i.e.
GET companies/v2/companies/paged?limit=250&offset=4552438489

*If on the second call, has-more is still true, you would need to grab the newly generated offset value and use it on the third call.

The offset value change upon each call.

Re: Increase the limit parameter in Get all companies

JMiljak — Wed, 14 Jul 2021 14:32:23 GMT

Hi,

do you know how to return body data from callback function of request function :

request(finalUrl, async (error, response, body) => { ... return JSON.parse(body)}

I know it must be something with asynchronous code, but I do not know how to return data from callback inside request function?

Re: Increase the limit parameter in Get all companies

Cerwind — Sat, 06 Jul 2024 12:42:17 GMT

We used a recursive function to fetch all our companies as there's a limit.

For example, let's say you have your function "callHubspotApi" with the argument "url". Inside this function you'd call the hubspot API and check if there's a "next page", if there is call the same function within itself while updating the "url" parameter with the next page. Keep doing this until there are no more pages left.