Question
SCB
IN
Last activity: 19 Jan 2025 16:00 EST
Case attached CSV file data convert to Page list in Constellation
how to convert case attached CSV file data to page list in Pega Constellation
Pegasystems Inc.
CA
Can you please check this one?
https://support.pega.com/question/how-can-we-convert-csv-file-pagelist-constellation
I hope this helps!
HCA Healthcare
US
@Penchalaiah B To convert a case-attached CSV file to a page list in Pega Constellation, you can use a Data Transform with a file parsing approach. First, ensure the CSV file is attached to the case and accessible through the pxAttachments page. Use a Data Transform or an activity to read the CSV content using the pzGetAttachmentContent function, which retrieves the file's binary data. Then, pass this data to a utility function, like pxParseCSV, which converts the CSV into a JSON object or page structure. Map the parsed content to a page list property in your data model using a looping mechanism. For efficient parsing, you can use the JSONUtils or a related Constellation API for structured processing. Finally, validate and handle any exceptions to ensure the data integrity and store the page list for further case processing.