You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Querying Records using REST API

edited May 15, 2019 11:10AM in HCM Integrations 4 comments

Summary

Querying Records using REST API

Content

Hi All,

I am trying to retrieve active employees with Projected End Date less than sysdate using REST.

Getting below error URL request parameter q with value (assignments.AssignmentProjectedEndDate < '2019-05-15') and (assignments.AssignmentStatus = "ACTIVE") is not valid.

Do you have any idea to do this?

Thanks,

Parthiban

 

Version

19B

Code Snippet

https://[EndPoint]/hcmRestApi/resources/11.13.18.05/emps?q=(assignments.AssignmentProjectedEndDate < '2019-05-15') and (assignments.AssignmentStatus = "ACTIVE")

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!