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