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 with Redwood for Oracle Cloud HCM   Begin Now

Fusion HCM REST API: How to Use OrderBy on an Attribute From a Child Resource?

edited May 19, 2023 9:36AM in HCM REST APIs 1 comment

Summary:

When I was trying to sort the assignments under the workRelationship API it throws an error:

URL request parameter orderBy with value workRelationships.StartDate:asc is not valid.

Content (required):

Is there a query to return employees assignment ordered by StartDate of assignments in descending order?

When I was trying to sort the assignments under the workRelationship API it throws an error:

URL request parameter orderBy with value workRelationships.StartDate:asc is not valid.

/hcmRestApi/resources/11.13.18.05/workers?q=PersonNumber=<data>&expand=workRelationships&effectiveDate=4712-12-31&onlyData=true&orderBy=workRelationships.StartDate:asc

Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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