Mapping Json Fields from Connect Rest Service
Hello Team,
I am getting the below mentioned error message when I am trying to map the json values to clipboard. This is because of special characters in the field name, Pega is not recognizing that field name and throwing an exception.
Test Json Sample: "newData":{"TESTDBDATA:4:slaveID:4.9":{"LatestAttributes":{"FirstName":"Testuser","Surname":"Tesingusers","BirthDate":"10.10.1993"}
Exception Message: The reference TESTDBDATA:4:slaveID:4.9 is not valid. Reason: invalid property name: TESTDBDATA:4:slaveID:4.9
The property TestPage.NewData was of mode String while com.pega.pegarules.data.internal.clipboard.ClipboardPropertyStrMinFeatureImpl.getProperty(String) was expecting a non-String mode. Details: encountered while trying to get TESTDBDATA:4:slaveID:4.9 com.pega.pegarules.pub.clipboard.WrongModeException: The property TestPage.NewData was of mode String while com.pega.pegarules.data.internal.clipboard.ClipboardPropertyStrMinFeatureImpl.getProperty(String) was expecting a non-String mode. Details: encountered while trying to get TESTDBDATA:4:slaveID:4.9
I also tried using pzexternalname property qualifier by saving it in our application ruleset but it did not work out. Also tried skipping this particular field through Data Transform but that also didn't work. Can anyone help me with this issue?
Ai4Process
GB
If you are using a data page then you can use the Post Load Processing to call an activity.
You can handle the guilty property by doing your own mapping then get rid of it (modifying the Json directly) and call the Json data transform.
T-Systems
DE
@Damien Could you please elaborate it for me, I am already using an activity and in that activity calling rest service to get the response and then using Data Transform. What is your suggestion? An example would help here...
Thanks!! :)
Updated: 27 May 2022 4:25 EDT
Ai4Process
GB
Hello,
You are using an activity already, ok.
When you call the REST service, the JSON text is populated into pyResponseData by default.
The Json you are using is not valid so you have to manually deal with these odd object names: "TESTDBDATA:4:slaveID:4.9"
My suggestion is to rename "TESTDBDATA:4:slaveID:4.9" with something like this: "TESTDBDATA_4_slaveID_4_9" or else
{
"newData": {
"TESTDBDATA_4_slaveID_4_9": {
"LatestAttributes": {
"FirstName": "Testuser",
"Surname": "Tesingusers",
"BirthDate": "10.10.1993"
}
}
}
}
Then you can call the Json Data Transform.
The idea is to manually change the value of the property as it seems it is not accepted by the Data Transform.
Because the property TESTDBDATA:4:slaveID:4.9 seems to be dynamic and can change, you will have to use a Page Group.
Page group is what I use to handle dynamic property key names
Lint Group Ltd
IN
Hi @ManishS96,
The JSON structure which you have shared is not correctly formatted.
Could you please verify it once?
Regards,
K Chandra Prakash.
T-Systems
DE
Hi Chandra,
Json structure format may be incorrect, it is the sample data that I have posted. There is no issue with the json structure because I am able to map other field names in clipboard, it is just this particular field name is causing issue.
JPMC
IN
