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
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Search parameter in REST API GET call

Summary:

Requirement is to fetch AllocatedChecklists for multiple random person numbers in VBExcel addin tool. Currently it is either returning for all employees or only for 1 person at a time. It would be expensive to invoke search on all employees, so looking for solution to download only for person numbers we need.

REST API GET call is NOT returning rows when searching with person number parameter using 'in' but it works when running on 1 person with '=' as shown below:

This doesn't work → https://xxxx.fa.ocs.oraclecloud.com/hcmRestApi/resources/11.13.18.05/allocatedChecklists?finder=findByPersonNumber&q=PersonNumber+in+(4,67741)
This works →

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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