Symptom
You are querying EmpJob, is navigating to Event Reason via eventReasonNav, and is trying to retrieve the Event Reason Name (name), however the value is coming as null even though there is data store on this field.
Environment
SAP SuccessFactors Employee Central
Cause
If
- The user that you are querying is currently inactive
- Query is not using any Time-Based filter or is using to retrieve data as of today
then the Event Reason Name will not be retrievable.
Resolution
If you want to retrieve the Event Reason Name from a user that is currently inactive, you would need to add the parameters fromDate toDate to the query. This parameter MUST match a time range in which the user was still active. As a result, you will be able to retrieve the Event Reason Name.
However, there is a scenario that makes it impossible to retrieve the Event Reason Name, in which:
- Both user and Event Reason are inactive
- Both user and Event Reason have been terminated/set to inactive on the same date
On this situation, the Event Reason Name won't be retrievable.
Keywords
eventReason, empjob, inactive, event, name, event Reason Name, odata, integration center, ic, fromDate, toDate, terminated, termination, time-based filter, filter, eventReasonNav , KBA , LOD-SF-INT-ODATA , OData API Framework , Problem