I will paste the java code bellow for anyone interested. FYI the system out prints don't work on Saviynt only used for local testing.
package com.custom.utilities;
import java.io.File;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.util.HashMap;
import java.util.Map;
import java.util.zip.ZipEntry;
import java.util.zip.ZipFile;
public class ZipExtractor {
public static void main(String[] args) {
Map<String,String> data = new HashMap<String,String>();
data.put("path", "ONLY TO TEST LOCALLY");
data.put("fileName", "ONLY TO TEST LOCALLY");
ExtractCSV(data);
}
public static File getLastModified(String directoryFilePath) {
File directory = new File(directoryFilePath);
File[] files = directory.listFiles(File::isFile);
long lastModifiedTime = Long.MIN_VALUE;
File chosenFile = null;
if (files != null) {
for (File file : files) {
if (file.lastModified() > lastModifiedTime && file.getName().toString().contains(".zip")) {
chosenFile = file;
lastModifiedTime = file.lastModified();
}
}
}
return chosenFile;
}
public static void ExtractCSV(Map<String,String> args) {
String zipDirectoryPath = args.get("path");
System.out.println(zipDirectoryPath);
String zipFileName = "";
String csvFileName = args.get("fileName");
try {
try {
zipFileName = getLastModified(zipDirectoryPath).getName().toString();
} catch (Exception e) {
e.printStackTrace();
}
ZipFile zipFile = new ZipFile(zipDirectoryPath+zipFileName);
ZipEntry entry = zipFile.getEntry(zipFileName.replace(".zip", ".csv"));
if (entry != null) {
InputStream inputStream = zipFile.getInputStream(entry);
FileOutputStream outputStream = new FileOutputStream(new File(zipDirectoryPath + csvFileName));
byte[] buffer = new byte[1024];
int length;
while ((length = inputStream.read(buffer)) > 0) {
outputStream.write(buffer, 0, length);
}
outputStream.close();
inputStream.close();
zipFile.close();
System.out.println("CSV file extracted successfully.");
} else {
System.out.println("CSV file not found in the ZIP archive.");
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
