What is the best way to enumerate all Constituents? I don't see a getAll for Constituents. I was thinking about using the search endpoint with very open (or no) search criteria.
I just replied differently in a different thread, but technically it is possible to enumerate constituents through the API by using a list and output set with custom criteria. This is NOT a straightforward solution, as it involves a lot of server-side state. Be aware that the API isn’t really designed for for this, and a different solution like an ETL process might be a better fit for your use case; that said, options for this are limited if the database lives in the RAMP managed hosting environment.
Thanks, Nick, for your answers. What options do I have for extraction piece of an ETL process? Would that be using the reporting features?
Since Tessitura is built on a Microsoft-oriented stack, the recommendation would be to use SQL Server Integration Services (SSIS), connecting directly to the SQL Server database. Most of the other options would also involve SQL Server technology, but there are better resources for that outside the Tessitura forums.