I encountered this strange behavior while processing the data through the Business Rule and referencing the JSON profile fields. I would like to understand this behavior better so I can avoid mistakes in my design.
The “Student” JSON profile contains two qualified records:
The Boomi process after retrieving “student” record it applies business rules to check various parameters.
In the “failed/false” error message of a Business Rule I included message displaying Student ID from all three profile paths (one non-qualified and two from the qualified). As you see below only one of the qualified outputs brings the data – not related to any criteria applied to the original query.
To complete the picture. The mapping from DB record into JSON is done for non-qualified output.