API Query for picklist fields returns ambiguous resuts i.e. for some employees the query returns ‘Option Id’ value, whereas for some it returns ‘external code’ value of the corresponding Picklist field.
This is a system behavior.
When there is no value defined in the Employee Central UI for a picklist field of some employee record, there is a possibility that the Select Query might fetch the external code value for that picklist field for that specific employee record rather than the Option Id.
The solution to this problem is to update a valid value in the Employee Central UI in Successfactors system for those picklist fields for the employees where no value is defined.
KBA , LOD-SF-INT , SF Integrations - EC Payroll, Boomi/ HCI, API , Problem