basicbass
Can't filter between two number values
Cool, no worries @charles thank you. For what it's worth (in case anybody else has this issue in the meanwhile), I worked around it by figuring out which filter wouldl result in fewer records, then I just exported the companies and did it in a spreadsheet (good enough for my purpose).
11 replies
Is there a limit on the createManyCompanies endpoint?
So far so good. I've ended up processing in batches of 500 and adding a 10 second delay to each call. Seems like each call is taking around 3 seconds to complete on my machine and we're up to 20,000 without.
To be honest though, if I had thought about it properly rather than rushing through over a coffee, I should have just executed the next batch on receipt of 200, and handled errors gracefully. But I'm impatient and this will (hopefully) be a one off.
17 replies
Is there a limit on the createManyCompanies endpoint?
Thanks for the pointers @ɃØĦɆᵾS. And yeah, lots of orgs right?! Service is applicable to UK charity sector, SMB thru Enterprise, so quite a large target base in absence of an ICP at the moment. There are around 200k charities in the UK so the target list is just a subset, believe it or not.
In my case, I'm just running locally, so not concerned about DDoS but definitely going to be spacing out those requests to avoid killing my machine (probably just with a
time.sleep() as I'll just quickly script this in python).
It seems like 1500 rows is accepted via the UI and given there's not much difference in character count between rows I'll probably just try to do this in batches of 1500 and see how I get on.17 replies