SAP Knowledge Base Article - Public

2532811 - SFOData.TeamGoal entity limitation on number of records returned in the Query response


Query operation on SFOData.TeamGoal entity errors out with message: "Failed to retrieve result with given criteria"



Reproducing the Issue

Use the following query https://<API_URL>/odata/v2/TeamGoal_26?$format=json

"error" : {
"code" : "COE_GENERAL_SERVER_FAILURE", "message" : {
"lang" : "en-US", "value" : "Failed to retrieve result with given criteria."

Note: The API URL can be choosen from the KBA 2215682


If the API user with which we are querying this entity has more than 1000 team goals, this issue occurs


Currently the maximum supported team goals or shared goals for the login user with which the query is made=1000.

Workaround available: unshare or delete some unused team goals so that you can get the correct result from this API.


  • TeamGoal entity fails to query
  • Team goal entity has error "Failed to retrieve result with given criteria"
, KBA , failed to retrieve result with given cri , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT , Integrations , LOD-SF-INT-API , API & Adhoc API Framework , Problem


SAP SuccessFactors HXM Core all versions