SAP Knowledge Base Article - Public

3020636 - OData API: Picklist Query Returns [COE0044] Expand size XXXXX exceeds limit 10,000

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

  1. Run the following query in Postman or any REST client
  2. 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
  3. 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