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

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

Received Response
126
Views
1
Comments
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!