We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

Retrieve API results by using like operator

Accepted answer
17
Views
4
Comments
edited Jan 5, 2021 3:37PM in HCM Integrations 4 comments

Summary

How to use like operator in API

Content

Hi,

We're trying to use the like operator in Fusion HCM API but for some reason it doesn't work.

for example - hcmRestApi/resources/11.13.18.05/emps?q=FirstName like '%Natalia%'

According to this doc - https://docs.oracle.com/en/cloud/saas/applications-common/20b/farca/op-hcmrestapi-scim-bulk-post.html

It should be possible but I always get a kind of error message below. 

I would much appreciate your assistance.

{
    "items": [],
    "count": 0,
    "hasMore": false,
    "limit": 25,
    "offset": 0,
    "links": [
        {
            "rel": "self",
            "name": "emps",
            "kind": "collection"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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