Question
Luxoft
IN
Last activity: 5 Sep 2022 3:02 EDT
How to read multiple top level json structure for same API in Connect-REST
Requirement is that same API gives different top level structure in positive(Page List) and negative(Page) scenario.
But Pega Connect-Rest response configuration of type json allows either page/pagelist not both.
Any suggestion/approach to implement this requirement will be really helpful. Please share your thoughts.
Positive response: page list [ "test":"1", .......... ], [ "test":"2", ...... ]
Negative response : Page
{
"errors" : [ "err":"1",
"err":"2"] }
***Edited by Moderator Marije to change Type from Discussion to Question***
Updated: 19 Aug 2022 6:24 EDT
Accenture
SG
Hi @JayashreeN6128, Approch 1 : Json DT
- Map api response data to a scalar property ( In the response tab of API select map to clipboard), then map the Json data manually to the clipboard using Json data transform.
- Have a when condition.. check for the structure whether it's page or page list and according to that invoke Json data transform.
Approach 2: Using function pxConvertStringToPage
- Map api response data to a scalar property ( In the response tab of API select map to clipboard), then map the Json data manually to the clipboard using function @pxConvertStringToPage(tools,PageName,Param.jsonData,"JSON")
- Make sure that you have the response structure available under the page you are passing to above function.
Thanks, Vinay
Updated: 2 Sep 2022 6:55 EDT
Luxoft
IN
Thanks for your input, we had tried this approach but we got blocked while mapping from string to JSON.
@pxConvertStringToPage(tools,PageName,Param.jsonData,"JSON").
In the response string , we have property names with special characters, those we have mapped it through pzExternalName in Pega.
Pega is not mapping these properties in function(pxConvertStringToPage) as well as in json DataTransform.
ex: ["name":"XXX" , "user-id":"1234" ]
Here for user-id, Property created is "userid" and configured with pzExternalName= user-id.
In function pxConvertStringToPage, we expect it maps value of "user-id" to "userid" property, but we observe invalid property exception.
Hence we were looking for other approach's. Any thoughts on this will be helpful.
Thanks,
Jayashree
Accenture
SG
Did you try with JSON data transform ?
JPMC
IN
@JayashreeN6128 Can you not have the positive scenario pagelist and negative scenario page structures created under a page for e.g., .response_GET?
Updated: 5 Sep 2022 3:08 EDT
Luxoft
IN
@BhanuPrakash_G , We could do that but challenge is mapping it to clipboard, converting from string to Page or mapping response to Page(by Pega).
Pega Connect REST> Response tab > json mapping allows only one property it should be either page (Response_get.ResultPage)/ pagelist((Response_get.ResultPageList)) not both.
Lventur
IN
In response tab select the Map To option as "JSON" and in Map To Key field provide a page property name like "response_body".
You need to define your data model in the way that system should be able to process both positive and negative scenario.
Example Data Model:
response_body = Page Property
Page Definition of response_body page property = XYZ-Int-Update-Response
Positive Response Page-List property "test " class should be XYZ-Int-Update-Response and pages-list page definition you can have anything based on business need.
Negative Response Page property "errors " class should be XYZ-Int-Update-Response and page property page definition you can have anything based on business need.
If you are going for this data model, then Pega will be able to map both Positive and Negative response inside response_body page property without any issues.