Solved
Pega Cloud CDH Interaction History export in CSV
Hello All,
- Context We use Pega 24.1 CDH in Pega Cloud environment. Interaction history data is extracted (saved) to the Cloud File Repository automatically via the WriteDataToInteractionFiles Data flow which destination is the InteractionFiles data set. It's a file type Data Set with JSON format by default Official documentation: https://docs.pega.com/bundle/customer-decision-hub/page/customer-decision-hub/implement/managing-data-export-cdh.html
- Question The requirement is to provide CSV files instead of JSON. Is it possible to cusomize the OOTB process and generate CSV files instead of JSON?
Thanks, Erik
***Edited by Moderator Rupashree S. to add Capability tags***
Accepted Solution
Posted: 2 months ago
Updated: 2 months ago
Updated: 3 Sep 2024 5:20 EDT
MOD
Pegasystems Inc.
GB
@ErikSzabo The out-of-the-box (OOTB) process for exporting Interaction History data using the WriteDataToInteractionFiles Data Flow generates files in JSON format by default. The system creates these files in the repository every 900 seconds or after processing 75,000 records. However, the provided context does not specify whether it is possible to customize this process to generate CSV files instead of JSON.
You could try to configure a File data set to read data from a JSON file, map the data to Pega properties, and then export the data to a CSV file.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.