Question
CIBC
CA
Last activity: 23 Jan 2024 7:55 EST
Append Data to a CSV File stored in pegacloudfilestorage Repository
Hi,
Using Repository API is there any way we can Append Data to an File in pegacloudfilestorage.
Here is my detailed requirement, please guide me if anyone solved this.
We have requirement where we need to retrieve data from DB, convert to CSV file and store in repository.
As it has millions of records, we are facing performance issues.
To address it we thought of retrieving x number of rows per iteration from DB and append them to the file already stored in repository.
Accepted Solution
Updated: 23 Jan 2024 7:55 EST
Pegasystems Inc.
GB
Currently, the Repository API in Pega Infinity does not support appending data to an existing file in the repository.
The API is designed to create new files or replace existing ones. For large data sets, consider breaking the data into smaller chunks and creating separate files for each chunk. Alternatively, you could use a temporary local file to accumulate the data and then write the final file to the repository. Please note that direct access to files in the Pega Cloud File Storage repository using any method other than the Repository API is not supported.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.
Using repository APIs in your application > Pega Cloud Services File Storage no
How to replace Connect File implementation with Repository API approach