OData API query in SuccessFactors Employee Central does not return all records from custom MDF

[Former Member]

Hello Experts,

We have a custom MDF created in SuccessFactors that stores employee attendance details (in time, out time, terminal number etc.). These records are "effective dated". Every day a new attendance record is created with effective date as today's date.

We are trying to fetch all these details (including historical attendance entries) for all employees via OData API. Below is the query that we constructed,

https://<server_url>/odata/v2/cust_objectname?fromDate=1900-01-01

Ideally it should return all the records for all the employees. However, this query returns a random number of records for employees. For example, for an employee where there are 18 historical records, we are getting only 2 records in the OData response.

I also checked the permissions of the user that's accessing this OData API and the user id has full access.

Kindly suggest if this is a known issue and there is any solution to this.

Thanks in advance,

- Netrey

[ebendl · Accepted solution]

Hi Netrey,

Here's another link -- https://apps.support.sap.com/sap/support/knowledge/public/en/2582815

Look for the __next token to call and fetch subsequent rows.