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

Last updated on FEBRUARY 11, 2016

Applies to:

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

Goal

On : 11.1.10.0.0 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*
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms