SAP Knowledge Base Article - Public

2211667 - FO_JOBCODE SFAPI entity not pulling the numeric value present in the custom_stringXX


Entity : FO_JobCode

Entity Type : SFAPI

The response returned by the FO_JobCode SFAPI entity returns URL instead of value for the custom_string.


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:



       <custom_string15 xmlns:xsi="" xsi:nil="true"/>




The root cause is Successfactors system has some speicial handing when custom string property is assigned with number values.


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.


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.



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


SAP SuccessFactors HCM Core all versions