Omnistudio Data Mapper Transform Examples

Data Mapper Transform examples demonstrate how to convert a single item into a list with one item and how to convert a list of objects to a list of values.

For additional Data Mapper Transform examples, see Transforming Lists with Data Mappers and Use Formulas in Omnistudio Data Mappers.

• Convert a Single Item to a List with One Item
  Sometimes, a component requires input as a list, but the input isn’t a list. You can use the Output Data Type setting in an Omnistudio Data Mapper Transform to convert JSON data to a list. Use a formula to remove the second level of the hierarchy.
• Convert a List of Objects to a List of Values
  You can convert a list of JSON objects (key-value pairs in braces) to a list of single values, regardless of the length of the list. The trick is to use a formula to remove the second level of the hierarchy.
• Change the Hierarchical Level of a List
  If a list is defined at the wrong level of a JSON node hierarchy, you can use an Omnistudio Data Mapper Transform to change the level at which the list is defined. This approach only works for a short list with a known number of items.