Skip Navigation
Expand
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?

Environment:

Oracle Service Cloud All supported versions

Issue:

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

Resolution:

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.