REST API Date Range Search Returns Java.lang.NullPointerException

(Doc ID 2188466.1)

Last updated on AUGUST 15, 2017

Applies to:

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

Symptoms

Customer has written an integration for the REST web-services and they unable to perform some date range searches.

Query 1 - Doing a strictly "greater than" search works:
https://<your_server_URL>/salesApi/resources/11.1.10/leads?q=CreationDate>2016-06-05

Query 2 - Doing a strictly "less than" search works:
https://<your_server_URL>/salesApi/resources/11.1.10/leads?q=CreationDate>2016-06-06

Query 3 - Using the "AND" keyword to combine causes a 500 error and java.lang.NullPointerException:
https://<your_server_URL>/salesApi/resources/11.1.10/leads?q=CreationDate>2016-06-06+AND+<2016-06-07

Query 4 - Using "Greater than or Equal to" causes a 500 error and java.lang.NullPointerException:
https://<your_server_URL>/salesApi/resources/11.1.10/leads?q=CreationDate>=2016-06-06

Query 5 - Using "Less than or Equal to" causes a 500 error and java.lang.NullPointerException
https://<your_server_URL>/salesApi/resources/11.1.10/leads?q=CreationDate<=2016-06-07

Query 6 - Using the "AND" keyword to combine causes a 500 error and java.lang.NullPointerException
https://<your_server_URL>/salesApi/resources/11.1.10/leads?q=CreationDate>=2016-06-06+AND+<=2016-06-07

Cause

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