Best strategy for large volume automation?

Andrew Hill

if i want to insert 10,000 donations this appears to require a very chatty connection, as constituent, address, phone number. gift, soft credit, custom fields, etc are all updated per record.
updating one person could have 10 to 20 api calls needed, meaning that a file of 10k records could use most of an entire days quota all by itself.

Is there a best way to update multiple people at one time, or at least have the capability to “insert, ignoring the record if it already exists”, otherwise i need to do a search + insert or update for every attribute.

Ben Regier

I don't believe SKY API has the ability to do batch updates or inserts. There are also no “insert, ignoring the record if it already exists” endpoints to my knowledge. I think you are correct that this could be a chatty process to set up.

If it were me, I'd first check to see if this insert could be done with an Import rather than using the API. The options you have there might be better for this scenario. If you need to use the API, I'd break the data up into several chunks and process one per day for several days.