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

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."

Successfactors

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." }
}
}

• 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

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

KBA , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT , Integrations , How To