How to fetch multipe records from hubSpot

Describe the problem/error/question

Hi Team,

I have a use case involving 2000 records in HubSpot CRM companies. According to the API limit, I can only fetch 100 records at a time.

The HubSpot API enforces a maximum limit of 100 records per request for most of its endpoints, including the /crm/v3/objects/companies/search endpoint. If you set a limit higher than 100, the API will default to its maximum limit of 100 records per response.

How can I retrieve all the records using the limit and after parameters using different nodes? Could you guide me on how to perform the iterations with the limit and after counters?

What is the error message (if any)?


Please share your workflow

Share the output returned by the last node

Information on your n8n setup

  • n8n version: 0.234.1
  • Database (default: SQLite): postgresql
  • n8n EXECUTIONS_PROCESS setting (default: own, main): Default
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: MAC

@Gouravdev , take a look at the solution provided in Hubspot API pagination help! - #8 by EmeraldHerald.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.