Use Data-Transform to Map Properties of an Integration Service (JSON)
Hi ,
We have an Integration Service configured in Pega to accept JSON requests.
We need to map the properties in the JSON to a Data Page . The property names are different in JSON.
Say we have emp_name in JSON , which we need to map to EMPLOYEE_NAME in our application .
How do we accomplish this ? We used a Data- Transform to map properties but we are not sure how we can get the JSON request in this Data- Transform.
We tried using a param with the same name as the JSON request property (emp_name) . But this was empty in the Data Transform .
How can we access the JSON request values from within the Data Transform?
Thanks,
Smitha R
Accepted Solution
Virtusa IT Consulting
AE
Pegasystems Inc.
IN
Which version of PRPC you are using ? From 7.1.8, you can address this using pzExternalName property qualifier. Please check-out below for more details on this :
https://pdn.pega.com/community/pega-product-support/question/modify-json-response-pega-717
Pegasystems Inc.
IN
Are you parsing JSON and mapping to clipboard or generating JSON from clipboard?
Accepted Solution
Virtusa IT Consulting
AE
You should be able to map request to JSON type on clipboard from Service-REST rule itself as in request tab you set 'map to' as 'JSON' and 'map to key' as a pagelist property and rest of the data modelling will be dynamically taken care on clipboard you just need to refer the values later from clipboard wherever required. For example as you want to use data transform you can use the pagelist which has request data as source (seggregated with proper indexes) and set it to target property.
Synechron
US
I am getting the same Error;
Map Inbound Data Failure
I am doing the mapping as below in the Post Request tab. Please need your help.
Thanks,
Janaka
Synechron
US
Found the Answer:
Thanks,
Janaka Perera
Pegasystems Inc.
IN
Hello Janaka,
Thank you for updating the post with the solution!
Regards,
Lochan | Community Moderator | Pegasystems Inc.
You should be able to map request to JSON type on clipboard from Service-REST rule itself as in request tab you set 'map to' as 'JSON' and 'map to key' as a pagelist property and rest of the data modelling will be dynamically taken care on clipboard you just need to refer the values later from clipboard wherever required. For example as you want to use data transform you can use the pagelist which has request data as source (seggregated with proper indexes) and set it to target property.