Question
Accenture
IN
Last activity: 12 Nov 2021 2:23 EST
How to Parse JSON and Store it on a Single Property in Pega 7.17 V?
we have a requirement where we need to store the json in a single property. Our application is in 7.1.7 version. we tried with "@(Pega-RULES:Page).pxConvertPageToString(tools, myStepPage, "json")" this function but it does not exist in 7.1.7.
Can anyone please suggest how to achieve this requirement in 7.1.7 V of Pega ?
Capgemini
NL
Hi Akhil,
You can do that via JSON data transform. If you pass that JSON clipboard structure to that data transform it will output the data in a Param which you can take and store in a property.
You can refer the below article:
https://docs-previous.pega.com/configuring-json-data-transform-request-data-transform-data-pages
Updated: 11 Nov 2021 8:12 EST
SAMI AEC
SA
Accenture
IN
Hi Pasha,
Thanks for your response.
This "@PageToJson(PageHoldingJson)" function is not there in 7.1.7 V of Pega.
Thanks,
Akhil Narendrula
Lventur
IN
I am not sure what pega OOTB function avail in pega 7.1.7 to convert value to json.
By using java code we can convert the values to json, please find sample java code how to convert value to json below with this comment and give try with that java code..
Sample Java Code.....
outputJSON = "{}"; // initialize empty JSON output
ClipboardPage entitiesStylesPage = tools.findPage("D_pzEntitityStyleMapping", tools.getParameterPage(), false);
if(entitiesStylesPage != null) { ClipboardProperty stylesMap = entitiesStylesPage.getIfPresent("pyEntityStylesMap"); if(stylesMap != null) { org.json.simple.JSONObject json = new org.json.simple.JSONObject(); Iterator<ClipboardProperty> stylesIter = stylesMap.iterator(); while(stylesIter.hasNext()) { ClipboardPage style = stylesIter.next().getPageValue(); json.put(style.getStringIfPresent("pyEntityType"), style.getStringIfPresent("pyEntityColor")); } outputJSON = json.toJSONString(); } }