Hello, I’ve been posting a larger file ok many times, however, I am now just getting this error message:
Too many rows detected",“code”:“TOO_MANY_ROWS”,“context”:{“maximumAllowedRows”:[“500000”]
How do I fix? We have way more than 500k customers, I dont want to split into many posts.
Hey @Ron_at_BRCC
Could you confirm what endpoint you are posting to?
Hey @Ron_at_BRCC
Assuming that you are referencing importing contacts(Was pretty sure you were, but wanted verification), we recently fixed a bug that was accidentally allowing unlimited size imports which had the potential to cause reliability issues. The limits for imports are listed in this kb article. We are allowing double the documented limit for API imports. You will need to split your import into multiple calls.
Thanks Dennis, yes it is a contact import.
Surely there is a workaround? I will have to split into several calls. And I’m sure there are larger companies that have many millions of customers… what are they doing?
thanks
Ron
What is your typical strategy for large imports?
@Ron_at_BRCC we’ve faced similar issues with these errors. Our best workaround is an automated process to generate multiple smaller files that the HubSpot API will accept. We check each file for the row size, and split the file into multiple smaller files if it’s under the limit.
OK thank you.