SAP Knowledge Base Article - Public

2339754 - Invalid SFQL! Error: Invalid WHERE clause. No internal code exists for external code "XXXXX" of "company"

Symptom

Receiving below error message when querying Compound Employee API having filter criteria as 'company IN ('XXXXX')'

Screenshot1.jpg

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

Environment

  • SuccessFactors HXM suite
    • Integrations
      • SFAPI

Cause

Incorrect value 'XXXXX' passed in the query

Resolution

To verify whether the value passed in the query is correct or not, you can follow below steps-

  1. Login to SFSF Instance and navigate to 'Admin Center -> Manage Data'.
  2. Now select the option 'company' as shown in the screenshot below and you can see a list of all the values present in the drop down right next to it.
  3. And if you select any of the values from the dropdown, you will see below screen in which the highlighted 'Company ID' field is actually the external Code value that should be used in the query.

Screenshot2.jpg

Keywords

No internal code exists for external code "XXXXX" of "company", Compound Employee error, SFAPI Domain Error!, Invalid SFQL, API, SFAPI , KBA , LOD-SF-INT , Integrations , LOD-SF-INT-API , API & Adhoc API Framework , How To

Product

SAP SuccessFactors HXM Suite all versions