You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Unable to filter on Incident Status values instead of ID in REST Report API

Received Response
20
Views
4
Comments
edited Jun 8, 2022 12:10PM in General Technical Discussions 4 comments

Summary

Even though "incidents.status_id.name" is the filter I am using, only ID values are being considered as input.

Content

Hi,

I am trying to run a report API with Incident status filter using REST Analytics. Always Status ID is being considered as the input value even though I have mentioned incidents.status_id.name as a filter definition (pls refer filter.png).

REST request payload:  - Not Working

{
"id":103061, 
"filters": 
[
{
"name": "IncidentStatus",
"values": "'Initiated'"
}
],
"limit":500
}
 

REST request payload:  -  Working

{
"id":103061, 
"filters": 
[
{
"name": "IncidentStatus",
"values": "'119'"
}
],
"limit":500
}

119 is the ID of Initiated value. I am wondering why report is not able to consider value as an input. This specific issue is not the same for custom menu objects. They work in the normal way. I am assuming some special syntax need to be used here for named ID fields.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!