How can we help?

New post
0

Connecting with Hubspot

Avatar
John Tse
None
Follow

Is it possible to grab more than 2500 rows of data from Hubspot?  Is this a payment wall or more of a hard-coded limitation?

Max Page setting is 10 and the URL I am using is:

https://api.hubapi.com/deals/v1/deal/paged?includeAssociations=true&limit=250&properties=dealname&properties=dealstage&properties=amount&properties=pipeline&properties=closedate&properties=createdate

Note: Anything about limit=250 returns an error:

"We couldn't retrieve the data you requested. Check your account permissions and connection and try again."

Date Votes

1 comment

  • Avatar
    Pratyusa Ray Official comment

    Hi John,

    Thanks for reaching out.

    HubSpot API has a 250 records per page limit,10 pages is the maximum number of pages that can be brought in at this time. This is more of a hardcoded limitation. If you'd like to see that number increase, I suggest logging a feature request for this. 

    With that in mind, perhaps once you cross the 2500 record threshold, you can create a 2nd data source that begins returning records after that 2500th record. You can do this either by specifying the date range in your Hubspot query, or by using our date parameters to specify a created_date that matches the 2501st record. 

    Hope this helps.

    Kind Regards,

    Pratyusa Ray

Please sign in to leave a comment.