Question
ANZ
IN
Last activity: 23 May 2025 1:29 EDT
Decode Base 64 string data and store the data in Database Table
I have requirement to fetch the csv file which has 4 columns A,B,C and D from AWS S3. I'm using D_pxGetfile to fetch the file from repository. The content of the file is fetched in base 64 encoded String format. I'm using the function @Default.Base64Decode(.pyContents) to decode the data.
The data is stored in Param or Text property. I was unable to parse the data. Need an approach to parse the data and store the data in database Table Columns A,B,C and D.
Capgemini
FR
What is the format of the data to be parsed? Does it look like XML? Could you share a snippet of the data in a screenshot?
ANZ
IN
@RusselK1 The file is of csv format. Once we fetch the file using Repository API we get the content in base 64 format. Sample base 64 Content -> YSxiLGMsZA==
We need to parse this data to page/ page list.