SAP Knowledge Base Article - Public

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

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

2.png

3. Fill in the value for the custom_string15 which has field label (Target %): 

 

1.png

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.

    res1.png

2. Fill in the value for the newly added custom_long field.

    res2.png

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 , custom_string not returning values , sfapi entity not returning values , LOD-SF-INT-EC , EC SF API/OData Entities , LOD-SF-INT , SF Integrations - EC Payroll, Boomi/ HCI, API , Problem

Product

SAP SuccessFactors HCM Core all versions