SAP Knowledge Base Article - Public

2535484 - How to query Goal Rating from Performance Management Form via OData API

Symptom

While querying FormContent entity in OData API following error is returned by the API server "The form data id and form content id are not match."

Environment

Successfactors

Reproducing the Issue

Following is the Query: odata/v2/FormContent?$expand=pmReviewContentDetail&$top=25&isIC=true

Error:

{
"error" : {
"code" : "COE_GENERAL_BAD_REQUEST", "message" :
{ "lang" : "en-US", "value" : "The form data id and form content id are not match." }
}
}

Cause

  • A formDataId is associated many formContentId, because when we route/send/reject/sign a form, system will generate a new record in the DataBase, and each formContent record relates a Audit Trail record, otherwise, system consider this form content as illegal form content.
  • When we create a form, the first form content does not relate the Audit Trail record, and when we launch the query of example as shown in the "Reproducing the Issue" section, system will fetch each "pmReviewContentDetail" of form content included the first record, hence the error message

Resolution

Please pass "formContentId" and "formDataId" in the query.

For Example: http://<API_URL>/odata/v2/FormContent(formContentId=999L,formDataId=999L)?$expand=pmReviewContentDetail&$top=25&$format=json

Also, the below picture gives you a clear understanding of the relation

''

Keywords

KBA , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT , SF Integrations - EC Payroll, Boomi/ HCI, API , How To

Product

SAP SuccessFactors HCM Core 1702