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
Skip to content
  • 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")
    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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