2361469 - Recruitment - SFAPI Error with Entity JobApplication when adding a filter with field lastModifiedForAppStatus in query

SAP Knowledge Base Article - Public

2361469 - Recruitment - SFAPI Error with Entity JobApplication when adding a filter with field lastModifiedForAppStatus in query

Symptom

Getting an error when try to add a filter with field “lastModifiedForAppStatus” from JobApplication entity in query

Environment

Successfactors RCM SFAPI

Reproducing the Issue

SFAPI response throwing an error when try to add a filter with field “lastModifiedForAppStatus” in the query. Field is present in the SFAPI “JobApplication” entity.

Querry having issue:

select candidateId, statusId, jobReqId, jobReqTemplateId from JobApplication where lastModifiedForAppStatus > to_date('2015-06-13T00:00:01Z')

Request: Add a filter with field "lastModifiedForAppStatus"

Request.PNG

 

Response:Getting an error "SFAPI Domain Error" in the response

Error Response.PNG

Resolution

The issue is because of the incorrect format of the date field in the filter used in the query.

Correct format for lastModifiedForAppStatus field when used in filter in query is below:

SELECT candidateId,jobReqId,jobReqTemplateId,statusId FROM jobapplication WHERE lastModifiedForAppStatus > to_date('2015-06-13','yyyy-mm-dd')

The difference in the error query and the correct one is the format of the date which is highlighted in bold above. When you run this query, it will result the data.

Keywords

lastModifiedForAppStatus, JobApplication Entity , KBA , LOD-SF-RCM-API , Webservices & APIs , Problem

Product

SAP SuccessFactors HCM Core 1605