Requirement to set a blank string value to null in REST Service response
Requirement is to set a blank value to null in outbound response of the Service-REST
The blank value of Text properties are set to “” instead null
For integer/decimals it's setting null ( as expected )
Pega Service Response :-
Actual Response
{ "Application":{ "Status":"Pending-Review", "ApplyingWith":"", "InterestRate":null, "StreetAddress":"" } }
Expected :-
{ "Application":{ "Status":"Pending-Review", "ApplyingWith":null, "InterestRate":null, "StreetAddress":null } }
I don't want to use below function which removes the blank properties from the JSON but we need blank values with null ( not "")
@(Pega-RULES:Page).pxConvertPageToString(tools, myStepPage, "json")
Requirement is to set a blank value to null in outbound response of the Service-REST
The blank value of Text properties are set to “” instead null
For integer/decimals it's setting null ( as expected )
Pega Service Response :-
Actual Response
{ "Application":{ "Status":"Pending-Review", "ApplyingWith":"", "InterestRate":null, "StreetAddress":"" } }
Expected :-
{ "Application":{ "Status":"Pending-Review", "ApplyingWith":null, "InterestRate":null, "StreetAddress":null } }
I don't want to use below function which removes the blank properties from the JSON but we need blank values with null ( not "")
@(Pega-RULES:Page).pxConvertPageToString(tools, myStepPage, "json")
2) Even followed the local changes mentioned here but didn't help
2.1) convert the page to json using data transform .
2.2) Map the param.jsonData to .pyJsonData
2.3) In the response tab , configured Map from "Clipboard" and Map from key .pyJsonData
Updated: 21 Mar 2020 0:36 EDT
Pegasystems Inc.
IN
Hi Brahmesh,
Returning empty string instead of null is default clipboard behaviour, changing it may lead to regression issues.
Please follow the workaround of not using Clipboard and populating Request JSON by yourself.
It can be done as follows:
1. In the request Tab give Map from clipboard and Map from key as .pyJsonData as shown in attached image.
2. Before calling the Connect-REST in an activity, populate .pyJsonData with your JSON request. You need to take care of inputting proper JSON if you use this approach.
CGI
SE
Thanks for the response ..
I tried the same but didn't work as mentioned above ,anyway pasting the content again .let me know if missing something here .
Even followed the local changes mentioned here but didn't help
2.1) convert the page to json using data transform .
2.2) Map the param.jsonData to .pyJsonData
2.3) In the response tab , configured Map from "Clipboard" and Map from key .pyJsonData
Updated: 24 Mar 2020 9:49 EDT
CGI
SE
1) @(Pega-RULES:Page).pxConvertPageToString(tools, sourcepage, "json") eliminates blank values but getting pxobjclass element in json and it's not retaining pega property type as marking all decimals/integers elements are enclosed in quotes like string .
2) if try to use Json data transform then no option to remove blank values or override blank with null .