One click downloading multiple documents and creating zip file

Hello Community members,

I am using the 'Get Base64 document from database' smart node to fetch a document from the database.

As part of the new requirement, I need to fetch multiple such documents from db, create a ZIP file and allow users to download it - all in one click.

I tried creating a web API to call an Appian integration that starts a process. The process uses either MNI or looping flow to fetch all the documents, creates a zip and terminates.

Both options seem to be unreliable as not all the docs get downloaded using a loop or MNI with activity chaining (plus it's not best practice to use MNI + activity chaining).

Have you encountered similar problems in your project? If so, do you have a solution for me?