SAP Knowledge Base Article - Public

2830981 - Query doesn't return all possible records in one page - Compound Employee API

Symptom

A query with the condition "EFFECTIVE_END_DATE" was made.

The parameter "maxRows" was set as 400 but, in the query results, the field "numResults" show less rows than 400 and the field "hasMore" contains the value "true", meaning that the query generated more pages.

Environment

  • SAP SuccessFactors HCM Suite
  • SFAPI
  • Compound Employee

Cause

The condition "EFFECTIVE_END_DATE" doesn't affect the data being selected from the database, it affects the results of the query. It acts more like a filter than a selection condition.

Resolution

To prevent this from happening, other paramaters would need to be used instead of "EFFECTIVE_END_DATE".

The filters selectToDate / selectFromDate are an option.

See Also

"EFFECTIVE_END_DATE" is explained in this page of Compound Employee guide.

The filters selectToDate / selectFromDate are explained in this page.

The complete Compound Employee guide can be accessed in this link.

Keywords

sfapi, success factors, successfactors, api, compound employee, ce, Unexpected behavior, pagination, SAP_SuccessFactorsHasMoreRecords.SuccesssFactorEC.SuccessFactors, entry, entries, results, payload , KBA , LOD-SF-INT-CE , Compound Employee API , LOD-SF-INT , Integrations , Problem

Product

SAP SuccessFactors HXM Suite all versions