JSON DataTransforms
When retrieving data from Microsoft Graph API you would often get a json response containing a key:value pair in return (i.e. assignments in the below example json).
{ "value": [ { "createdBy": { "user": { "id": "6463a5ce-2119-4198-9f2a-628761df4a62" } }, "planId": "xqQg5FS2LkCp935s-FIFm2QAFkHM", "bucketId": "gcrYAaAkgU2EQUvpkNNXLGQAGTtu", "title": "title-value", "orderHint": "9223370609546166567W", "assigneePriority": "90057581\"", "createdDateTime": "2015-03-25T18:36:49.2407981Z", "assignments": { "fbab97d0-4932-4511-b675-204639209557": { "@odata.type": "#microsoft.graph.plannerAssignment", "assignedBy": { "user": { "id": "1e9955d2-6acd-45bf-86d3-b546fdc795eb" } }, "assignedDateTime": "2015-03-25T18:38:21.956Z", "orderHint": "RWk1" } }, "id":"01gzSlKkIUSUl6DF_EilrmQAKDhh" } ] }
I cannot find any information on how such objects are to be mapped using the JSON DataTransformation. Does anyone know how this is to be solved or a link to relevant documentation Thx
***Edited by Moderator Rupashree S. to add Capability tags***
Pegasystems Inc.
GB
When deserializing a JSON object at run time, a JSON data transform scans the entire class on which you defined that data transform, searching for exact matches between the property names and the key names of the incoming JSON object. If a JSON key does not have a match (because your application does not contain corresponding properties), the data transform creates temporary properties of Page or Page List type in the Clipboard, based on the JSON structure. For example, in your case, the 'assignments' object would be treated as a Page property if there is no exact match in your data model. If the 'assignments' object contains multiple assignments, it would be treated as a Page List property. You can also create a direct mapping between the JSON strings and the clipboard data model through a JSON data transform. This allows you to create a mapping between properties whose names do not match and for which the automapping option is not available. Please note that the properties don't actually have to exist to demonstrate the Data Transform working - but you'll want to create them in real life.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.
Mapping JSON elements individually
When deserializing a JSON object at run time, a JSON data transform scans the entire class on which you defined that data transform, searching for exact matches between the property names and the key names of the incoming JSON object. If a JSON key does not have a match (because your application does not contain corresponding properties), the data transform creates temporary properties of Page or Page List type in the Clipboard, based on the JSON structure. For example, in your case, the 'assignments' object would be treated as a Page property if there is no exact match in your data model. If the 'assignments' object contains multiple assignments, it would be treated as a Page List property. You can also create a direct mapping between the JSON strings and the clipboard data model through a JSON data transform. This allows you to create a mapping between properties whose names do not match and for which the automapping option is not available. Please note that the properties don't actually have to exist to demonstrate the Data Transform working - but you'll want to create them in real life.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.
Mapping JSON elements individually
Creating Data Transform from Json File/Text
How to parse JSON string and assign the JSON value to the property
Automapping JSON data > Automapping and serialization
Equinor
NO
@MarijeSchillern Thank you for your reply. I am unsure if this approach will solve the issue. The challenge is not the "assignments" but the objects in the assignments. The "fbab97d0-4932-4511-b675-204639209557" is an id and used as a key for the attached assignment object. I.e. there will be one or more of these key:value objects in this list. If I create a page property called "fbab97d0-4932-4511-b675-204639209557" then the parser will resolve the object, but I will never know what the id in the response is going to be.
Updated: 2 May 2024 11:16 EDT
Pegasystems Inc.
GB
@TorIngeV thanks for the additional details.
I'm wondering if the limitations might not be found in the documentation, eg Automapping JSON data
I'll try to find an SME to provide suggestions.
Pegasystems Inc.
US
@TorIngeV , you could almost get away with using the auto-map feature of JSON Data Transform for this, since it does not validate that a property is defined when it deserializes JSON data to clipboard. However, that will not work in this case because the JSON field names under assignments contain hyphen characters, which will cause an exception to be thrown when used as a property name. The only thing I can suggest is to pre-process the JSON using either a REGEX expression or custom java.
IQZ Systems
US
Can utilize the DT of JSON where on right side we can mention the proeprties from JSOn and left we can mention pega properties thus we are mapping values from json props to pega properties.Could you try using this
Equinor
NO
@ghkumar The challenge is that there is no property name to map, the response is the form of a Map<string,object> type. And the string behaves like an id for the object it is mapped to. The closest pega type seems to be Value Group, but I am unable to map to a value group using DT of type JSON.