Question
Accenture GmbH
DE
Last activity: 5 Oct 2018 1:55 EDT
JSON Object Parsing in Pega
Pega recieving the response through connect-Rest in the JSON object format as shown below.
{"125-XXX-ABC":
{"cust":"xxx","emailAddress":" Proprietary information hidden","Valid":true,"Others":[{"type":"XXX","value":"125-SDF-RTZ "}]},
"350-YYY-YXF":
{"cust":"yyy","emailAddress":" Proprietary information hidden","Valid":true,"Others":[{"type":"XXX","value":"125-SDF-RTZ "}]}
Connector wizard created the datamodel specific to IDs: "125-XXX-ABC" and "350-YYY-YXF" and not working when response contains other customer Ids.
Instead of mapping reponse data to JSON: Response_Post , I mapped it to clipboard string property and passing JSON string to a function @pxconvertstringtopage after manipulating JSON string Ids (Append alphabet and convert hypen(-) to underscore ( _ ) to "P125_XXX_ABC" and "P350_YYY_YXF" . In clipboard pageless classes are created with different pagenames.
I m unable to copy the classless pages to named pages due to different page names created. Is there a better way to handle this scenario. Any suggestions are helpful.
***Updated by moderator: Lochan to update platform capability***
Pegasystems Inc.
IN
Hi Sameer,
While using your JSON ,I found that its formatted incorrectly.
I have formatted it and created a REST Connector for the same and it works fine.
Please find the Formatted JSON:
{
"125-XXX-ABC":
{
"cust":"xxx","emailAddress":" Proprietary information hidden","Valid":true,"Others":
[
{"type":"XXX","value":"125-SDF-RTZ "}
]
},
"350-YYY-YXF":
{
"cust":"yyy","emailAddress":" Proprietary information hidden","Valid":true,"Others":
[
{"type":"XXX","value":"125-SDF-RTZ "}
]
}
}
Accenture GmbH
DE
Thanks for your response. I have the connector rules created. But connector works only when the request has 125-XXX-ABC and 350-YYY-YXF. Any other Ids will not generate valid response due to dynamic values.
tata consultancy services
AU
Can you please use the following code:
String pageContent = jsonResponse;
ClipboardPage myPage = null;
try{
myPage = tools.createPage("@baseclass","ResponsePage");
myPage.adoptJSONObject(pageContent);
} catch(InvalidStreamError e){
oLog.error("ReloadSection:Invalid JSON Stream for data page params : "+e.getMessage());
} catch(Exception e){
oLog.error("ReloadSection:Expection : "+e.getMessage());
}
Accenture GmbH
DE
Thanks for your suggestion , When I try this - I get the following error in Java step.
The reference 124-XXX-200 is not valid. Reason: invalid property name: '124-XXX-200' . This error is due to the fact that Pega tries to create pages for Object names :124-xxx-200 and fails as it starts with numbers and has special characters.