Hubspot node doesn't return all items (Tickets)

Questions
1

Describe the problem/error/question

Hey guys!

I’m trying to get Tickets from Hubspot with the Hubspot Node. My organization has 1.583 Tickets. But when I execute my workflow it only returns 300 items (Tickets).

To avoid this I put a loop in my workflow. But when it restarts returns 5k (it already has duplicated tickets)

The main point is that I don’t know when it will get all the results and when should I stop the execution. Also, I don’t know why it got only 300 in the first execution

Please share your workflow

Share the output returned by the last node

But I know when the workflow runs 2 times it returns all the Tickets I need. Putting some “execution counter” in the workflow and “if it is greater than 2 stop the execution” should work for now!

Information on your n8n setup

  • n8n version:
  • Database (default: SQLite): Hubspot
  • n8n EXECUTIONS_PROCESS setting (default: own, main): default
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Cloud
  • Operating system: Windows 11
3

Hi @Lucas_Santos :wave:

It sounds like you might be running into Hubspot limits - you may want to try to make this request with the HTTP Request node and using batching, returning 100 objects at a time and seeing if that fixes this up for you :bowing_man:

4

Hi @EmeraldHerald!!

Where can I found the URL for the Hubspot api?

5

Hi @Lucas_Santos :slight_smile: You can call the Hubspot API at https://api.hubapi.com/crm-objects/v1/objects/tickets/paged , and you can read their documentation here: API Overview | HubSpot API

6

Thank you!! I’m gonna try this way and later I will tell you if it works!

1 Like