API Search_Criteria not working with the operating_system.os field

API Search_Criteria not working with the operating_system.os field

Hi

I am trying to get all assets, with an API call, that meets the following search criterias:
      * Assets In Use.
       * Assets is a Server.
      * OS name must contain "Microsoft Windows Server".

I can get the two first criterias to work together, but at soon as I add the last criteria, i get an JSON error, saying invalid input?   
What am I doing wrong?

"list_info": {
        "row_count": 100,
        "start_index": 101,
        "sort_field": "id",
        "sort_order": "asc",
        "get_total_count": true,
        "search_criteria":[
                   {"condition":"is","field":"product_type.name","value":"Server"} ,
                   {"condition":"contains","field":"state.name","value":"In Use","logical_operator": "and"},
                   {"condition":"contains","field":"operating_system.os","value":"Microsoft Windows Server","logical_operator": "and"}
         ]
    }

I have also tried to just use Search_Fields like this:

"list_info": {
        "row_count": 100,
        "start_index": 101,
        "sort_field": "id",
        "sort_order": "asc",
        "get_total_count": true,
        "search_fields":{"state.name":"In Use","product_type.name":"Server","operating_system.os":"Microsoft Windows Server"}
    }

That does not give me an JSON error, but it is still not working. The return data is not filtered by operating_system.os. I get many hits that does not contain "Microsoft Windows Server" in the OS name.

Can you not filter with the field operating_system.os using API?

Regards Brian

                  New to ADSelfService Plus?