SAP Knowledge Base Article - Public

3516660 - Invalid SFQL! Error: query "" is not properly formed - CompoundEmployee API

Symptom

You are using CompoundEmployee API to get employee's data.

In the API response, you are getting an error similar to the following:

  • Invalid SFQL! Error: query "" is not properly formed

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

Environment

SAP SuccessFactors HCM

  • Compound Employee API

Reproducing the Issue

  1. Make an CompoundEmployee API call directly, or through other middleware.
  2. You have provided xml payload in the API call.
  3. But you still get the error as mentioned above.

Cause

The query in the request payload is not in a proper format for CompoundEmployee.

If you provide a wrong one, the query will be mentioned explicitly in the error message.

If you provide an empty query, in the error message there will be nothing between the double quotes.

Resolution

Please review your request payload and make sure the CompoundEmployee API query is valid.

In case you cannot check the payload, you can follow below KBA to reproduce the issue and check API Audit Log (SFAPI).

3141692 - How to provide API Audit Logs to Cloud Support - SuccessFactors

See Also

Employee Central Compound Employee API

Keywords

SF, CE API, SOAP, fail, S:Server, SFAPI Domain Error, INVALID_SFQL , KBA , LOD-SF-INT-CE , Compound Employee API , Problem

Product

SAP SuccessFactors HCM Core 2405