How to map JSON message to clipboard using Data Transform
Data Transform now supports JSON and I am trying to learn how to use it.
This article explains a lot, but it is a bit abstract for me. I will give a specific example below, so can anyone please advise how exactly to map JSON message to Work property?
Let's say, I have a Work Class (MyCo-MyApp-Work-PurchaseRequest) and have three Text properties under this class - A, B, and C. External system will send a REST request with three String - X, Y, and Z in the JSON Body message. I have created a Service Package, Service REST and an activity. I am now able to map the entire JSON message to Param.jsonData.
[Service REST - Service]
Data Transform now supports JSON and I am trying to learn how to use it.
This article explains a lot, but it is a bit abstract for me. I will give a specific example below, so can anyone please advise how exactly to map JSON message to Work property?
Let's say, I have a Work Class (MyCo-MyApp-Work-PurchaseRequest) and have three Text properties under this class - A, B, and C. External system will send a REST request with three String - X, Y, and Z in the JSON Body message. I have created a Service Package, Service REST and an activity. I am now able to map the entire JSON message to Param.jsonData.
[Service REST - Service]
[Service REST - POST Method]
[Activity]
This activity does not really make sense because it is always opening P-1 but please assume this is just for a testing purpose. What I want to do here is to parse X, Y, and Z in the Param.jsonData into A, B, and C on tempPR page using Data Transform. I think I will need to call Apply-DataTransform between step 1 and 2 but how exactly should I do it? Where should the DT be located, and what does it look like in rule form?
[JSON message]
Thanks,
Pegasystems Inc.
IN
Hi,
Yes, you will need to call the json DataTransform after step1.
Please find the attached document for the DataTransform rule configuration.
Hope it helps.
Thanks.
Prime Inc
US
Hi Sree Priya ,
I'm trying to consume JSON and map to page in clipboard by using Data Transform with data model of JSON. I did follow your steps in above document. But that didn't map the prop to clipboard.
We're having big JSON object in DB table as a column . Once we get the JSON thru SQL integration(Connect-SQL) .Now JSON will have Repetable elements and normal elements . I'd like to map it to clipboard page whole JSON object and from there i should be able to map to properties in my application.
Any suggestions
Pegasystems Inc.
IN
Hi,
Can you try @(Pega-RULES:Page).pxConvertStringToPage(tools, Primary, Param.Request, "json") in Data transform.
Basically pxConvertStringToPage function, takes 4 args . attached in the screenshot