REST API> Query Telephone Field

(Doc ID 2311152.1)

Last updated on OCTOBER 03, 2017

Applies to:

Oracle CRM On Demand - Version 031CS to 031CS [Release 31]
Information in this document applies to any platform.

Goal

Why REST API query for LEAD on PrimaryPhone doesn't return the result?

As an example of Rest API GET:

/OnDemand/user/Rest/026/Leads?q=PrimaryPhone= "+1 650 6679709"&fields=PrimaryPhone,LeadLastName,LeadFirstName

In UI, the value for Phone# is: +1 650 6679709

We also tried different PrimaryPhone format, like +1 6506679709, +1 650 667-9709, +16506679709. All returns empty result.

Besides, we also tried LIKE in the query string, but LIKE doesn't work for PrimaryPhone.

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