Bulk Export Program Member Data of all Active programs
We want to export all the program member data we have.
We want to do a bulk export of everyone for every programs and then run scheduled works just to export any new members from existing programs, new members from new programs and update status or dates from existing members of existing programs.
On our ideal scenario we would have daily/weekly exports with these parameters
Lead ID | Program Id | StatusName | reachedSuccess | acquiredBy | myCustomField etc etc
We’ve tried using this API
/rest/v1/programs/{programId}/members.json
/rest/v1/programs/members/describe.json
But we would have to create job for each program or use and external resource to create the loops.
Any suggestions on how we can achieve our goal