How JSON As Simple File Coming to PRPC from File Listner can be Parsed
Dear All,
We are having a Proposal from Client that we need to Read a File . ==> OK
The file will be Read through the File Listner ==> OK
The File will contain JSON each and every time with a Response Structure ==> OK
But after we Receive the file in the PRPC we need to process/parse the same in PRPC to extract the Information out of it. ==> NOT OK
(WHY NOT OK : We have Implemented CSV Files or the XML Files Parsing which we receive from the File Listners But how can we parse the JSON, is there a way of achieving it with some OOTB activities which Reads JSON FIle format and give us a Clipboard page , as the same happens in the Case of the CSV files or XML Files.) ???? That is my question.
Accepted Solution
capgemini
AU
Solution :
On my Initial analysis the JSON Parsing without Rest from the File is possible. Please see the below explanation .
-
Use the Activity
-
For Example I have taken the Sample JSON from http://www.w3schools.com/js/js_json_intro.asp
{"employees":[
{"firstName":"John", "lastName":"Doe"},
{"firstName":"Anna", "lastName":"Smith"},
{"firstName":"Peter", "lastName":"Jones"}
]}
3.The Same Json has been Passed to the Parameter. And the Result was good and successful in Tracer.
4.The Page Structure which got created is given below :
Resultant Page :
Solution :
On my Initial analysis the JSON Parsing without Rest from the File is possible. Please see the below explanation .
-
Use the Activity
-
For Example I have taken the Sample JSON from http://www.w3schools.com/js/js_json_intro.asp
{"employees":[
{"firstName":"John", "lastName":"Doe"},
{"firstName":"Anna", "lastName":"Smith"},
{"firstName":"Peter", "lastName":"Jones"}
]}
3.The Same Json has been Passed to the Parameter. And the Result was good and successful in Tracer.
4.The Page Structure which got created is given below :
Resultant Page :
Pegasystems Inc.
IN
Check out these articles if they are of any help.
https://collaborate.pega.com/question/how-parse-json-string-pega-62-sp2
https://collaborate.pega.com/question/how-parse-json-request
https://collaborate.pega.com/question/how-parse-json-data-pega
Accepted Solution
capgemini
AU
Solution :
On my Initial analysis the JSON Parsing without Rest from the File is possible. Please see the below explanation .
-
Use the Activity
-
For Example I have taken the Sample JSON from http://www.w3schools.com/js/js_json_intro.asp
{"employees":[
{"firstName":"John", "lastName":"Doe"},
{"firstName":"Anna", "lastName":"Smith"},
{"firstName":"Peter", "lastName":"Jones"}
]}
3.The Same Json has been Passed to the Parameter. And the Result was good and successful in Tracer.
4.The Page Structure which got created is given below :
Resultant Page :
Solution :
On my Initial analysis the JSON Parsing without Rest from the File is possible. Please see the below explanation .
-
Use the Activity
-
For Example I have taken the Sample JSON from http://www.w3schools.com/js/js_json_intro.asp
{"employees":[
{"firstName":"John", "lastName":"Doe"},
{"firstName":"Anna", "lastName":"Smith"},
{"firstName":"Peter", "lastName":"Jones"}
]}
3.The Same Json has been Passed to the Parameter. And the Result was good and successful in Tracer.
4.The Page Structure which got created is given below :
Resultant Page :