Symptom
You are running a Picklist query with $expand parameter and receiving the following error:
- [COE0044] Expand size XXXXX exceeds limit 10,000
Environment
- SAP SuccessFactors HXM Suite
- OData API
Reproducing the Issue
- Run the following query in Postman or any REST client
- https://apisalesdemo4.successfactors.com/odata/v2/Picklist?$select=picklistId,picklistOptions/picklistLabels/optionId,picklistOptions/picklistLabels/locale,picklistOptions/picklistLabels/label,picklistOptions/status,picklistOptions/externalCode&$expand=picklistOptions/picklistLabels
- Response Payload throws error:
[COE0044] Expand size XXXXX exceeds limit 10,000
Cause
maximumExpandKeys default value is 10000
Resolution
Because the maximumExpandKeys default value is 10000, you will need to add to the query &maximumExpandKeys=20000
e.g.
- https://apisalesdemo4.successfactors.com/odata/v2/Picklist?$select=picklistId,picklistOptions/picklistLabels/optionId,picklistOptions/picklistLabels/locale,picklistOptions/picklistLabels/label,picklistOptions/status,picklistOptions/externalCode&$expand=picklistOptions/picklistLabels&maximumExpandKeys=20000
Keywords
Picklist Query Error, [COE0044] Expand size exceeds limit 10,000, Expand Size, OData , KBA , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT , Integrations , How To
Product
SAP SuccessFactors HCM Suite all versions