How to create a file that can hold JSON
I am using the pxConvertPageToString function to convert the results on my step page to JSON format and this string is stored in a property. Please suggest how can I map this property containing the JSON string to a file. I will later be using FTP to send this file to another application. REST-Service cannot be used.
Accepted Solution
Coforge
US
Store the generated json string to a clipboard property of type text and make use of connect-file to write it to file on the server.
Pegasystems Inc.
US
Hi Rahul,
You can try with the sample code as follows as per your requirement,
//Getting the Step Page fo Getting Actual JSON Data
ClipboardPage StepPage = tools.getStepPage();
String JsonResponse = StepPage.getString("TzJsonRequest");
oLog.infoForced(JsonResponse);
String ServiceExportDir = pega.getStaticContentUtils().getServiceExportRoot();
Hi Rahul,
You can try with the sample code as follows as per your requirement,
//Getting the Step Page fo Getting Actual JSON Data
ClipboardPage StepPage = tools.getStepPage();
String JsonResponse = StepPage.getString("TzJsonRequest");
oLog.infoForced(JsonResponse);
String ServiceExportDir = pega.getStaticContentUtils().getServiceExportRoot();
String FilePath = ServiceExportDir+"UVUOutPut"+java.io.File.separator+"DailyUsage.txt";
oLog.infoForced("Actual File Path of JSON File "+FilePath);
tools.getParameterPage().putString("JSONFilePath",FilePath);
try{
//Creating a PR File Object
com.pega.pegarules.pub.util.PRFile ServiceExportFile = new com.pega.pegarules.pub.util.PRFile(FilePath);
com.pega.pegarules.pub.util.PROutputStream ServiceExportFileOut = new com.pega.pegarules.pub.util.PROutputStream(ServiceExportFile);
//ServiceExportFileOut.write(org.apache.commons.codec.binary.Base64.decodeBase64(JsonResponse));
byte[] contentInBytes = JsonResponse.getBytes();
ServiceExportFileOut.write(contentInBytes);
ServiceExportFileOut.close();
}
catch(java.io.IOException ie)
{
ie.printStackTrace();
oLog.infoForced("Error writing the file content to Service Export Directory", ie);
}
Hope this will help you to achieve your requirement.
Regards
Mahesh
JP Morgan Chase & Co.
US
Thank you for the response Mahesh. I was able to create the file using the connect-file method as suggested by Imranullah.