Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Retrieve API results by using like operator — Cloud Customer Connect
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
18
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!