Question
RBC
CA
Last activity: 29 Aug 2023 10:59 EDT
how to read json file from manual upload file in pega
Can we upload .Json file from UI and parse the json data to clipboard.
Pegasystems Inc.
GB
@dileepm4794 Yes, you can upload a JSON file from the UI and parse the data to the clipboard. To achieve this, you can use a File control in your UI to allow users to upload the JSON file. Once the file is uploaded, you can use an activity to read the file content and parse the JSON data. You can then use a JSON data transform to map the JSON data to the clipboard properties, creating a one-to-one mapping between the JSON keys and clipboard properties. This will allow you to process and manipulate the data within your Pega application.
This answer came from a Pega gen-AI assistant using the below references. As a Support Center moderator, I reviewed the answer and references for accuracy:
Mapping Single Value properties to JSON data
How JSON As Simple File Coming to PRPC from File Listner can be Parsed
RBC
CA
Thank you for the response.
can you advice how to parse the JSON using OOTB ( Activity or function), How do I validate if the JSON is structured or not?
I am using PRPC 8.6 environment.
Pegasystems Inc.
GB
@dileepm4794 do the articles provided earlier not help?
The AI suggests the following:
To upload a JSON file from the UI and parse it to the clipboard, follow these steps:
- Create a File Upload control in your UI to allow users to upload the JSON file.
- Create an activity to process the uploaded JSON file. In this activity, use the "pxUploadFile" activity to store the uploaded file in a temporary location.
- Read the JSON file content into a text property.
- Use the OOTB function "@importJsonOntoPage()" to parse the JSON content and create a clipboard page. Pass the JSON content as the first parameter and the target clipboard page as the second parameter.
- Process the clipboard page as needed for your application requirements.
These steps will help you upload a JSON file from the UI, parse it, and store the data in the clipboard for further processing.
How JSON As Simple File Coming to PRPC from File Listner can be Parsed
Extract information from a text property that contains a JSON