2884860 - SFAPI Domain Error! INVALID_SFQL: Error: IN operator for <field/property> must not have more than 1000 expressions

Symptom

Getting below error when executing an SFAPI Query Operation (in this example compoundEmployee API query is used)

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

API Error Response :

<faultstring>SFAPI Domain Error!</faultstring>

<ns2:SFWebServiceFault xmlns:ns2="urn:fault.sfapi.successfactors.com" xmlns="urn:sfobject.sfapi.successfactors.com"> <ns2:errorCode>INVALID_SFQL</ns2:errorCode>

Message : Error IN operator for <field/property> must not have more than 1000 expressions

Error SFAPI.JPG

Environment

SAP Successfactors HXM Suite

Product

SAP SuccessFactors HCM Core all versions

Keywords

SFAPI Domain Error!, InvalidSFQL, 1000 WHERE clause in SFQL is limited up to 200 OR/AND subclauses, CompoundEmployee API Threshold, Limitation, Best Practice, must not have more than 1000 expressions , KBA , LOD-SF-INT-API , API & Adhoc API Framework , LOD-SF-INT , Integrations , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.