Troubleshooting and Debugging15% of the exam
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.
Resolve Data Mapper output and Data Mapping issues.
~5 min read · 4 practice questions ·
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
Unquoted string
- Detail
- Resolves to null, or false, when it names no object
Error response
- Detail
- {} for missing, wrongly typed or unevaluable parameters
Function names
- Detail
- All uppercase; Sqrt fails as "not a Function or Operator"
Operator comparisons
- Detail
- Case-insensitive; string functions are case-sensitive
AGE input
- Detail
- AGE("01 Jan 2025") is an error case
Top-level node order
- Detail
- May differ from the Expected JSON Output in a correct Transform
Null fields
- Detail
- No output node unless Include null values in the response is selected
Use Assignment Rules
- Detail
- Sends Case assignment-rule emails; guest users can't trigger the rules
- 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?
The questions are free to read. Answers with their sources and self-grading are included with the pack.
Keep reading with the Omnistudio Developer pack
- Core concepts
- Exam traps
- Worked scenario
The pack includes:
- All 46 lessons of the Omnistudio Developer guide, with reading progress
- Interactive decision walks and step-by-step sequence steppers
- Inline practice questions and one-click topic practice (4 questions for this lesson)
- An official source cited for every claim
- An AI tutor that answers from the guide
- Unlimited timed practice exams