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

[former_member455910]

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]

Hi Netrey,

You are aware of the 1,000 row limit in the SuccessFactors OData implementation, right? We thought we were getting random data too until we found that it was limited to the first 1000 rows. See https://answers.sap.com/questions/388819/how-to-select-massive-data-from-successfactors-usi.html for more details.

[former_member455910]

Thanks Eben de Lange,
I checked the link that you provided. However, there is no solution mentioned to this issue there. How can we fetch more than 1000 records from OData API?

Regards,
Netrey