A data transform defines how to convert data that is in one format and class (the source) into data of another format and class (the target). Use JSON data transforms when you need to integrate disparate data, for example, responses from external data sources, with the application data model.
Mapping JSON elements to multiple clipboard properties
If you map a single JSON element to multiple clipboard properties in a JSON data transform, the system sets the value from the JSON element on the last property. This behavior applies to properties that are included within the same hierarchy level.
For example, you set an Append and Map to action in your JSON data transform and configure two properties, .CardName and .CardName2. You set both properties to the "name" JSON element. If you run the JSON data transform in deserialization mode, only .CardName2 is set to "name" because it is the latter property in the set action.
Conversely, you configure two properties called .CardName, and set one property to the “name” JSON element and the other property to the “name2” JSON element. If you run the JSON data transform in serialization mode, the system sets the value of .CardName to “name2” because “name2” is the latter field in the set action.
For more information about JSON data transforms, see the following documentation: