SAP Knowledge Base Article - Public

2803133 - Employee not appearing in SuccessFactors SFAPI CompoundEmployee

Symptom

You are running one query in the SFAPI CompoundEmployee using the WHERE condition of just one employee and this employee is not being returned in the response.

You already reviewed all the permissions regarding the SFAPI CompoundEmployee API user.

You also checked that your API user have the permissions of this target population.

Find below one example of this query:

SELECT
person,
employment_information,
job_information
FROM CompoundEmployee
WHERE
person_id_external = ('Cgrante')

The API is returning always with zero results, according example below:

    <S:Body>
        <queryResponse xmlns="urn:sfobject.sfapi.successfactors.com" xmlns:ns2="urn:fault.sfapi.successfactors.com">
            <result>
                <numResults>0</numResults>
                <hasMore>false</hasMore>
                <querySessionId>xxxxxxxx</querySessionId>
            </result>
     </queryResponse>

Environment

SuccessFactors SFAPI CompoundEmployee

Resolution

Please check if the Person ID being stored in the "Biographical Information" matches with the value passed in the parameter person_id_external (WHERE condition).

This field is case sensitive and any difference will impact.

In my example after changing from ('Cgrante') to ('cgrante'), the SFAPI CompoundEmployee it worked.

example_SFAPI_CE.PNG

Keywords

Employee not returned, not appearing, not found, response cannot see, API, SFAPI CompoundEmployee, CE, zero results, numResults, case sensitive, lower caps,  lower case , KBA , LOD-SF-INT-CE , Compound Employee API , LOD-SF-INT , SF Integrations - EC Payroll, Boomi/ HCI, API , Problem

Product

SAP SuccessFactors HCM Suite all versions