This worked for me after with minimal customization of OOTB activities

Step1: Customize the below two OOTB activities to your ruleset with your class names

Use OOTB pxDownloadDataRecordsAsCSV (Consider the steps from 6-8) to pull the records (Pass RD and Class Name as params).  pxConvertResultsToCSV 

Step2: Set the file location path from DDS ex: local.exportPathbefore the last java step.

Modify the Java code(Write to csv file at location java step)  to write the .csv file to the location (You should have the access to the network path)

char sep = PRFile.separatorChar; String status=""; //String exportPath= tools.getProperty("pxProcess.pyText").getStringValue(); DateTimeUtils dtu = ThreadContainer.get().getDateTimeUtils();

String fileNameParam = tools.getParamValue("FileName"); if(fileNameParam.equals("")){     fileNameParam = "RecordsToCSV"; } Boolean appendTimeStamp = tools.getParamAsBoolean(ImmutablePropertyInfo.TYPE_TRUEFALSE,"AppendTimeStampToFileName");

FileName+=fileNameParam; if(appendTimeStamp){     FileName+="_";     FileName+=dtu.getCurrentTimeStamp(); } FileName+=".csv"; String strSQLfullPath = exportPath+ sep + FileName; PRFile f = new PRFile(strSQLfullPath); try{  // Create file   PROutputStream stream = new PROutputStream(f);  PRWriter out = new PRWriter(stream, null, false);  // Bug with Excel reading a file starting with 'ID' as SYLK file. If CSV starts with ID, prepend an empty space.  if(CSVString.startsWith("ID")){     CSVString=" "+CSVString;      }  out.write(CSVString);     byte[] bytes = CSVString.getBytes();   status = ABCD_utilities.UploadFileToNetwork(bytes, exportPath, FileName, 0 );   oLog.infoForced(status);  //Close the output stream  out.close(); }catch (Exception e) {  oLog.error("Error writing csv file: " + e.getMessage()); }

Step 3:  Custom function ABCD_utilities.UploadFileToNetwork

Input Parameters:

Name   -->   Java Type   -->Pega Type

fileContent-->byte[]

networkLocation-->String-->Text

fileName-->String-->Text

maxFileSizeInMB-->Int-->Number

Java Code:

String status = null; networkLocation = networkLocation + "\\" + fileName; File file = new File(networkLocation);

/* Validate Inputs */ if ((networkLocation == null || networkLocation.equals("")) || fileName == null|| fileName.equals("") || fileContent == null) {     status = "FAIL:F1-Upload failed due to missing information";     return status; }

int fileSize = fileContent.length/1048576;

/* Validate File Size */ if (maxFileSizeInMB > 0 && maxFileSizeInMB < fileSize) {     status = "FAIL:F2-File size (" + fileSize + " MB) exceeded Max File Size Limit of " + maxFileSizeInMB + "MB";     return status; } try {     ByteArrayInputStream inByteStream = new ByteArrayInputStream(fileContent);     InputStream inStream = new BufferedInputStream(inByteStream);          OutputStream outStream = new BufferedOutputStream(new java.io.FileOutputStream(file));

    byte outBuffer[] = new byte[4096];     int len;     while (( len = inStream.read(outBuffer)) != -1)      {                  outStream.write(outBuffer, 0, len);                             }     inStream.close();     outStream.flush();     outStream.close();     status = "SUCCESS:File Uploaded"; }  catch (Exception ex)  {     oLog.error("Error writing uploaded file to Macess", ex);     status = "FAIL:F99-Upload failed due to the following exception : " + ex.getMessage(); }

return status;