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

Absence REST API - Query by Start Date & Last Updated Date

edited Apr 23, 2025 8:34AM in Workforce Management 5 comments

Hi,

Hope you are well.

I am trying to query the 'Get all absence records' API:

REST API for Oracle Fusion Cloud HCM - Get all absence records

I would like to query this by both the Start Date & Last Updated Date fields.

If I do each query individually, these work perfectly:

oraclecloud.com/hcmRestApi/resources/11.13.18.05/absences?limit=25&offset=0&onlyData=true&q=startDate >= 2025-01-01 AND <= 2025-01-07

oraclecloud.com/hcmRestApi/resources/11.13.18.05/absences?limit=25&offset=0&onlyData=true&q=lastUpdateDate >= 2025-01-01 00:00:00 AND <= 2025-01-07 23:59:59

Reading up the guidance, it says I should be able to combine multiple queries together - my latest attempt:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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