# Troubleshooting Data Mapper output and formulas

*Omnistudio Developer Study Guide · Troubleshooting and Debugging · Last updated October 27, 2026 · https://www.certifyforce.com/study-guide/omnistudio-developer/troubleshooting-and-debugging/troubleshooting-data-mapper-output-and-formulas*

How to read a Data Mapper formula's wrong result (false, {} or an error message), fix unquoted strings and unsupported date formats, explain missing or reordered output nodes, and trace side effects such as assignment-rule emails from a Load.

- Certification: Salesforce Omnistudio Developer
- Exam section: Troubleshooting and Debugging
- Study guide: https://www.certifyforce.com/study-guide/omnistudio-developer

**Official exam objective:**

> Resolve Data Mapper output and Data Mapping issues.

## What the exam expects

- Tell from a formula's result (a false branch, `{}` or an error message) which kind of mistake caused it.
- Fix unquoted string values and date values in formats a function doesn't accept.
- Decide whether a Preview Response that differs from the Expected JSON Output is a defect, and explain missing null nodes and shifting list order.
- Trace unexpected side effects of Load options such as Use Assignment Rules.

Key terms: **formula result path** (the JSON node that stores a formula's result), **error response `{}`** (what functions return for missing or wrongly typed values), **Expected JSON Output** (the target structure pasted for a Transform), **Use Assignment Rules** (Load option that applies assignment rules to sObjects such as Cases).

## Key facts

| Fact | Detail | Source |
|---|---|---|
| Unquoted string | Resolves to null, or false, when it names no object | [Data Types](https://help.salesforce.com/s/articleView?id=xcloud.os_omnistudio_data_mapper_and_integration_procedure_data_types.htm&language=en_US&type=5) |
| Error response | {} for missing, wrongly typed or unevaluable parameters | [Data Types](https://help.salesforce.com/s/articleView?id=xcloud.os_omnistudio_data_mapper_and_integration_procedure_data_types.htm&language=en_US&type=5) |
| Function names | All uppercase; Sqrt fails as "not a Function or Operator" | [Data Types](https://help.salesforce.com/s/articleView?id=xcloud.os_omnistudio_data_mapper_and_integration_procedure_data_types.htm&language=en_US&type=5) |
| Operator comparisons | Case-insensitive; string functions are case-sensitive | [Data Types](https://help.salesforce.com/s/articleView?id=xcloud.os_omnistudio_data_mapper_and_integration_procedure_data_types.htm&language=en_US&type=5) |
| AGE input | AGE("01 Jan 2025") is an error case | [Data Types](https://help.salesforce.com/s/articleView?id=xcloud.os_omnistudio_data_mapper_and_integration_procedure_data_types.htm&language=en_US&type=5) |
| Top-level node order | May differ from the Expected JSON Output in a correct Transform | [Formulas](https://help.salesforce.com/s/articleView?id=sf.os_use_formulas_in_dataraptors_47540.htm&language=en_US&type=5) |
| Null fields | No output node unless Include null values in the response is selected | [Transform mappings](https://help.salesforce.com/s/articleView?id=xcloud.os_dataraptor_transform_data_mappings_46630.htm&language=en_US&type=5) |
| Use Assignment Rules | Sends Case assignment-rule emails; guest users can't trigger the rules | [Load](https://help.salesforce.com/s/articleView?id=sf.os_object_field_mapping_47137.htm&language=en_US&type=5) |

## Check yourself

- Why does a formula with two independent IF functions on separate lines fail?
- When does a function return `{}` instead of an error message?
- Why can a Data Mapper Load send emails when no Email action exists?

## Sources

- [Supported Data Mapper and Integration Procedure Data Types](https://help.salesforce.com/s/articleView?id=xcloud.os_omnistudio_data_mapper_and_integration_procedure_data_types.htm&language=en_US&type=5)
- [Use Formulas in Omnistudio Data Mappers](https://help.salesforce.com/s/articleView?id=sf.os_use_formulas_in_dataraptors_47540.htm&language=en_US&type=5)
- [Map Inputs and Outputs for Transformations](https://help.salesforce.com/s/articleView?id=xcloud.os_dataraptor_transform_data_mappings_46630.htm&language=en_US&type=5)
- [Configure an Omnistudio Data Mapper Load](https://help.salesforce.com/s/articleView?id=sf.os_object_field_mapping_47137.htm&language=en_US&type=5)

## About the full unit

The "Core concepts", "Exam traps" and "Worked scenario" sections of this unit, its 4 linked practice questions, and unlimited timed mock exams are included with the Omnistudio Developer pack (USD $19): https://www.certifyforce.com/practice-exams