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

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

Successfactors RCM SFAPI

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"

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

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.

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