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:
    Pegasystems Documentation

  • 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

@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.

:warning: This is a GenAI-powered tool. All generated answers require validation against the provided references.

Managing data export

Interaction history

Creating a File data set record for embedded files

JSON data transforms

JSON file structure for historical data