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

    Workers API query using WorkerNumber

    in HCM REST APIs 2 comments

    Hi Support,


    I am trying to query "Workers" API endpoint using WorkerNumber, but I am receiving the below error:

    Query: https://ebuu-dev1.fa.ap1.oraclecloud.com/hcmRestApi/resources/11.13.18.05/workers/?expand=workRelationships.assignments.assignmentsDFF&q=workRelationships.WorkerNumber='F111111'&onlyData=true&limit=100

    Error: "detail": "Failed to build ViewCriteria from expression \"workRelationships.WorkerNumber='F111111'\" using view object Worker. Unable to create criteria item from node: \"workRelationships\". "


    I am successfully getting response when I am querying with other fields in workRelationships like:

    https://ebuu-dev1.fa.ap1.oraclecloud.com/hcmRestApi/resources/11.13.18.05/workers/?expand=workRelationships.assignments.assignmentsDFF&q=workRelationships.LegalEntityId='1111111111111'&onlyData=true&limit=100

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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