Unable To Query A Customer Name Having Single Inverted Comma Using hubOrganizations REST API (Doc ID 3003401.1)

Last updated on FEBRUARY 16, 2024

Applies to:

Symptoms

On : 11.13.23.10.0 version, Webservice / REST API

ACTUAL BEHAVIOR
---------------

Using RESTAPI /crmRestApi/resources/11.13.18.05/hubOrganizations to query a customer using customer name, where the name has a single inverted comma, returns zero results even though the record exists. But same record can be queried from UI & SOAP service using name.

Below is the sample REST API with input parameter as customer name which is causing the issue.

https://<>/crmRestApi/resources/11.13.18.05/hubOrganizations?q=OrganizationName="Test Customer's record"

This is not fetching any results, even though record exists.



EXPECTED BEHAVIOR
-----------------------
Should be able to query the customer which exists in system.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Call the API with the query as outlined above.
2. Note that no response returned even though record exists.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use this API to find the customer

Changes

Cause

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