Skip Navigation
Defining a result filter for "No Value" for REST API reports
Answer ID 9882   |   Last Review Date 07/24/2019

How do I use "No Value" as a filter value when executing a report in REST API?


Oracle Service Cloud All supported versions


I am unable to run a report using a  "No Value" filter value using the REST API.


To set the report value for a filter to "No Value" the REST API should have the value "~null~" in it's JSON request body. Please see example below:

     "id": 100001,
     "filters": [
               "name": "FirstFilter",
               "values": "1"
               "name": "SecondFilter",
               "values": "~null~"

For more information visit the REST API documentation.

Available Languages for this Answer:

Notify Me
The page will refresh upon submission. Any pending input will be lost.