Hi Experts
I have a problem where I need to generate an excel without storing the data in DB.
I'm using Export CDT to excel smart service,
But I have nearly 6000 rows to fetch with only 3 columns(Request ID, DOC ID, Doc Name).
I want to know what is the maximum amount of data in terms of size(MB or KB) a process variable of type CDT can hold.
And if is there any better solution of what I'm doing, please suggest me.
Thank you in advance
Discussion posts and replies are publicly visible
I do not believe there is a defined maximum here. In my experience 6000 rows with 3 columns is not much data for Appian to handle. I would just pay attention to your process archiving/deleting settings for server health but it should be no issues to process that size data.
To note, while the Export CDT to Excel service is deprecated, I still utilize it as well as there is no other service with it's capability available.