Symptom
While attempting to generate Performance Management Form or 360 Reviews Form reports through the SuccessFactors Integration Center, the following error message is encountered:
[COE0018] formDataId, formContentId, or participantId can not be null or empty!
Code: COE_GENERAL_BAD_REQUEST
Status: Bad Request
Status Code: 400
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 Suite
- Integration Center
- SAP SuccessFactors Performance & Goals OData APIs
- Integration Center
Reproducing the Issue
- Go to Integration Center
- Create > Scheduled Simple File Output Integration
- Search for a Form or Form360 entity > Select
- The Bad Request - 400 error message is displayed in a pop-up, and no data is being returned
Cause
This is a limitation on Integration Center as the OData Query generated in IC follows below format:
http://<api-server>/odata/v2/<Form or Form360 Entity>?$select=formContentId,formDataId,participantId,etc. depending on the fields selected.
Whereas for the Form / Form360 Entities (Talent APIs) it is essential to include certain properties in the request URI, meaning an acceptable OData Query would look like this:
http://<api-server>/odata/v2/<Form or Form360 Entity>(formContentId=12345L,formDataId=98765L, participantId='abcd')?$format=json
Resolution
Currently Integration Center is unable to support extraction of these entities due to query format mismatch mentioned in the cause section of this KBA.
As a workaround, such data could be exported via direct OData API calls using a middleware to make this automated or Report Center. Please discuss with your Implementation Partner or Consultant to find the best alternative solution.
Kindly submit an enhancement request following KBA 2090228 to bring this improvement to the attention of IC Dev and Product Management Team for future release.
See Also
- KBA 2090228 - How to submit enhancement ideas for SAP SuccessFactors Products
- KBA 3551773 - [COE0018]Form Data id and form ContendId should be provided - Performance Management Form Entities
- Form360Participant | SAP SuccessFactors API Reference Guide (OData V2) | SAP Help Portal
Keywords
Integration Center, Talent API, OData API, Form, Form360, Reviews, COE_GENERAL_BAD_REQUEST, [COE0018], can not be null or empty! , KBA , LOD-SF-INT-INC-ODATA , ODATA API In Integration Center , LOD-SF-INT-INC , Integration Center , LOD-SF-INT-INC-JOB , Integration Center Job , LOD-SF-INT-ODATA , OData API Framework , Problem
SAP Knowledge Base Article - Public