Hey everyone!
I am far from being an API or Python expert, but I managed to write a code that gets certain properties from a Custom Object, puts them in a Pandas Dataframe, applies some calculations, and then exports the result to Excel (the idea would be that the result gets imported to a new HubSpot property).
Problem is, I can’t seem to understand exactly how to overcome the 100 request limit rate per call. I read that paginating could help, but I am not sure how to set it up.
We have around 6000 lines in that Custom Object, so you can imagine how this can be a bit of a headache!
Does anyone have any recomendations? Or maybe someone has tried this before? Cheers!
@FedericoG - If I understand your issue correctly, as a part of the returned data in your first call you should get an ‘after’ property that indicates that there is additional data to be retrived and the offset of that next set of reture=ned values. So you can set up a loop to make the call repeatly, including that ‘after’ property in calls 2-n, and append the new results to your first 100. When ‘after’ is no longer populated in the returned data you have all the record infrmation that satifies your initial query.
Hope that this helps!
Steve
Hi Steve!
Thank you so much for the reply and sorry for not answering earlier, I was out of the office last week.
I will try to do what you suggested with the loop and see if that works.
Have a good one!