How to create zip file with Code-Pega-List result

General
, , ,
1

Requirement is to fetch Parent Child hierarchy and export the contents to zip file and store in server path.
The parent child instances might be in 3 to 4L records , so if going through loop or recursion in Pega through activity to fetch the hierarchy results will lead to performance .

We went with approach of writing DB query to fetch Parent child hierarchy .
After writing DB query, we have used Connect-SQL to fetch DB query results into Pega.

Now we are storing the results in Code-Pega-List results.

Question here is , how to export the Code-Pega-List results into zipfile and place the zip file in server path .

All ruleset ,Product export code we went through , but these are not helping our requirement.

Can some one assist us on the same?

2

Hi All,
I figured out the way to package Code-Pega-List results into zip file and place it in StaticFolder/global/export folder.
This can be done using java step .PFA text file with java code written to solve this requirement

Java Step for exporting Code-Pega-List results and create zip file in static folder.txt (2.51 KB)