My Oracle Support Banner

How To Use Case Insensitive Filter In REST API (Doc ID 2105967.1)

Last updated on MARCH 28, 2019

Applies to:

Oracle Fusion Sales Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Accounts, Contacts, Households

How To Use Case Insensitive Filter In REST API

Here is the question detail:

Looking to filter a list of contacts using the REST API based on the Contact Name. This works although is case sensitive.
I cannot see in the documentation how to make the filter case insensitive.
Below Example shows Filter for Contact Name which works => ContactName LIKE 'Abc*'
GET https://[Hostname]:443/crmCommonApi/resources/latest/contacts?q=ContactName%20LIKE%20Abc*
However it does not work for => ContactName LIKE 'abc*'
GET https://[Hostname]:443/crmCommonApi/resources/latest/contacts?q=ContactName%20LIKE%20abc*


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.