AnsweredAssumed Answered

API filter on on dropdown value

Question asked by Mary Warner on Nov 6, 2015
Latest reply on Nov 6, 2015 by Alan Beam

Sugar Professional 7.6.0

So there are a number of resources that talk about how to check if a field equals, contains, etc. values.   None of those resources talk about how to check if a drop down has a value.  

 

The two filters that I cannot seem to get to work are:

{
  "filter":[
       {//Territory is a dropdown that contains a large number of values. I just want to make sure to get the ones where the value is set
            "territory_c":{
                 "$not_null"
            }
       }
  ]
}
{
  "filter":[
       { //There are a number of account types, I only want one account type. 
            "account_type":{
                 "$in":{"hospital"}
            }
       }
  ]
}

Outcomes