3667575 - Expanding relNationalIdNav via PerPersonRelationship returns only the first record of National ID for dependents

While trying to fetch the details for PerNationalId of the dependents by navigating from PerPersonRelationship, only first record is returned for national id of dependents via Integration center or OData API query.

SAP SuccessFactors HCM suite

• OData API
• Integration Center

1. Perform an OData API get call or create an Integration Center job with starting entity as PerPersonRelationship.
2. From PerPersonRelationship, navigate to PerNationalId to fetch the details for National ID of the dependent.
3. The result returns only the first record for PerNationalId of the dependent.

This is a legacy behavior. The navigation from PerPersonRelationship to PerNationalId is many-to-one navigation. Therefore, it only returns first record from DB even if the related person/dependent has multiple national id details available.

In order to query all the records of PerNationalId via API/Integration center is to query PerNationalId entity seperately by filtering the relPerson's id. 

PerPersonRelationship | SAP Help Portal

LOD-SF-INT-API, OData, API, Integration center, PerPersonRelationship, PerNationalId, many-to-one, navigation, LOD-SF-INT-ODATA , KBA , LOD-SF-INT-EC , Employee Central SFAPI & OData Entities , LOD-SF-INT-ODATA , OData API Framework , Problem