2433301 - 'SFAPI Domain Error - Internal Error' when querying the SFAPI entity with 'IN' operator

Symptom

When using 'IN' operator in an SFAPI query like-

SELECT <field1>, <field2>, <field3> from <ENTITY_NAME> Where <field4> IN ('1','2','3','4','5',.........,'400','401',.....................'999','1000','1001',.....)

It returns below error message-

[SFAPI Domain Error!] Error Code=[INTERNAL_ERROR] Error Message=[Internal error. Please contact support.]

Environment

Successfactors

Cause

Incorrect query formation

Resolution

The error is coming due to the number of values in the 'IN' clause exceeding the maximum number allowed.

We therefore suggest to not use more than '800' values in the 'IN' clause and that will resolve the error.

Keywords

'SFAPI Domain Error - Internal Error'
Using 'IN' operator in SFAPI queries

, KBA , LOD-SF-INT-API , API & Adhoc API Framework , LOD-SF-INT , Integrations , Problem

Product

SAP SuccessFactors HCM Core 1702 ; SAP SuccessFactors HCM Suite all versions