Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Smitha Rajasenan (SmithaR1)
Nielsen

Nielsen
US
SmithaR1 Member since 2016 27 posts
Nielsen
Posted: Nov 8, 2016
Last activity: Jan 29, 2017
Posted: 8 Nov 2016 13:04 EST
Last activity: 29 Jan 2017 23:25 EST
Closed
Solved

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

To see attachments, please log in.
Low-Code App Development
Data Integration

Accepted Solution

Posted: 8 years ago
Posted: 9 Nov 2016 4:34 EST
Habeeb Baig (BaigHabeeb)
Virtusa IT Consulting
Lead Decisioning Architect
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.

 

To see attachments, please log in.
Posted: 8 years ago
Posted: 8 Nov 2016 23:52 EST
Chandra Sekhar B K (ChandraSekharBk)
PEGA
Software Architect, Services Engineering
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 

https://collaborate.pega.com/question/rest-json-attributes-starting-not-being-mapped-corresponding-properties-generated-rest

 

To see attachments, please log in.

Accepted Solution

Posted: 8 years ago
Posted: 9 Nov 2016 4:34 EST
Habeeb Baig (BaigHabeeb)
Virtusa IT Consulting
Lead Decisioning Architect
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.

 

To see attachments, please log in.
Posted: 7 years ago
Posted: 29 Jan 2017 23:25 EST
Lochana Durgada Vijayakumar (Lochan_DV)
PEGA
Senior Manager, Knowledge Management
Pegasystems Inc.
IN

Hello Janaka,

Thank you for updating the post with the solution!

Regards,
Lochan  |  Community Moderator  |  Pegasystems Inc.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice