Symptom
Entity : FO_JobCode
Entity Type : SFAPI
The response returned by the FO_JobCode SFAPI entity returns URL instead of value for the custom_string.
Environment
Successfactors Bizx Environment
Reproducing the Issue
1. Log on to successfactors system
2. Check if the custom_string is selectable in SFAPI data dictionary
3. Fill in the value for the custom_string15 which has field label (Target %):
3. Now trigger the query "Select custom_string15,externalCode From FO_jobCode", when we check the response we can see that the value for custom_string15 will be:
<sfobject>
<type>FO</type>
<custom_string15 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>
<externalCode>ANALYST-IT</externalCode>
</sfobject>
Cause
The root cause is Successfactors system has some speicial handing when custom string property is assigned with number values.
Resolution
If the values for custom_string is exactlly a number, It is always advised to configure as custom_long or custom_double instead of custom_string.
Resolution:
1. Do the backend changes, configure custom_long or custom_double instead of custom_string, and check if the changes are reflected in the SFAPI data dictionary.
2. Fill in the value for the newly added custom_long field.
3. Query the FO_JobCode SFAPI, you will receive the response corectly.
<sfobject>
<type>FO</type>
<custom_long1>10</custom_long1>
<externalCode>ANALYST-IT</externalCode>
</sfobject>
<sfobject>
Keywords
KBA , sfapi entity not returning values , custom_string not returning values , LOD-SF-INT-EC , Employee Central SFAPI & OData Entities , LOD-SF-INT , Integrations , Problem