Question
Infosys
IN
Last activity: 3 Oct 2018 1:41 EDT
JSON util component usage
Is JSON will give the results of inner class properties?
I am trying to read the value of 'Name' using GetValueFromJSON but returns null value.
JSON ex: {
"pxObjClass":"test1"
,"ProfDtls":[
{
"addressType":"1"
,"EffectiveDt":"2018-04-01"
,"EnterpriseID":"1001"
,"IsActive":"true"
,"Name":"test"
,"AddrDtls":{
"FullAddress":"test"
,"pxObjClass":"Test"
}
,"SpecialtyList":[
{
"pxObjClass":"test"
,"Specialty":"test"
,"specialtyCd":"test"
}
]
}
]
}
Given above json and Name as inputs but result is not returning. If simple json then returning results.
Also, let me know how to pass object in case of desterilize the json. I mean how to define the object and pass as input.
Accepted Solution
Pegasystems Inc.
US
The attached screenshot is of automation design where it takes the input of JSON and key value and outputs the JSON value.
Pegasystems Inc.
US
JSONUtil can get values from complex JSON string too. In your case, ProfDtls is an array object, so you have to specify an index number for which value set “Name” property is requested. I was able to get the name property from the ProfDtls with "ProfDtls[0].Name" key and FullAddress details from AddrDtls, as it's a normal object of the first value set ProfDtls with key "ProfDtls[0].AddrDtls.FullAddress".
For the desiralizion of the json, I used the same JSON code from above and use Serialize method to serialize and then Deserialized it with Type as a String.
Serialized JSON :
"{\r\n\"pxObjClass\":\"test1\",\r\n\"ProfDtls\":[\r\n\t{\r\n\t\"addressType\":\"1\",\r\n\t\"EffectiveDt\":\"2018-04-01\",\r\n\t\"EnterpriseID\":\"1001\",\r\n\t\"IsActive\":\"true\",\r\n\t\"Name\":\"test\",\r\n\t\"AddrDtls\":\r\n\t{\r\n\t\"FullAddress\":\"test\",\r\n\t\"pxObjClass\":\"Test\"\r\n\t},\r\n\t\"SpecialtyList\":[\r\n\t{\r\n\t\"pxObjClass\":\"test\",\r\n\t\"Specialty\":\"test\",\r\n\t\"specialtyCd\":\"test\"\r\n\t}\r\n\t ]\r\n\t }\r\n\t]\r\n}"
Desiralized JSON output from the Serialized JSON is the same as original posted.
You can write your own simple or complex JSON string and use serialized method to see how it is formatted and write your own based on that.
Accepted Solution
Pegasystems Inc.
US
The attached screenshot is of automation design where it takes the input of JSON and key value and outputs the JSON value.