SAP Knowledge Base Article - Public

2478472 - How to avoid dependents information while using SFOData.PerPersonal entity in Integration Center

Symptom

When we query the succesfactors system using SFOData.PerPersonal API along with employee information,dependent information also gets returned.

Environment

Successfactors

Reproducing the Issue

  1. Login to Successfactors system
  2. Admin Center --> Integration Center
  3. Create a simple CSV file output integration and choose PerPersonal as the starting entity or one of the navigation entity
  4. Now in the configure fields tab while viewing the data we can see certain records with the format "x_dy" where X represents PersonIDExternal for the employee and y is a mere number

For Example: A dependent for employee with PersonIDExternal=2 might have a dependent with PersonIDExternal = 2_d775

Cause

This is because PerPersonal entity by default fetches the entire data of employees+dependents from the underlying table.

Resolution

To fetch/obtain only employee records in the query result please use the following filter: UserID is not equal to Null.

Logic behind this filter is as follows: A dependent will not have employment information filled in and thus using the foreignkey relation, we are validating the result set by the following condition "get me those records for which the employment information exists"

Navigation from PerPersonal:

Navigation.JPG

Filter Condition:

Filter.JPG

Keywords

  • How to avoid dependents information in PerPersonal entity
  • Users not searchable in Successfactors which are returned by PerPersonal entity
, KBA , how to avoid dependents information whil , LOD-SF-INT-API , API & Adhoc API Framework , LOD-SF-INT-INC , Integration Center , Problem

Product

SAP SuccessFactors HCM Core all versions