How do we add Not equal to condition to REST API url

Rajanmehta · ‎05-06-2017

hi

We are on Helsinki. Can someone please help and show me how to add Not Equal to condition to REST API url?

Please see the url below. And I want to filter out sys_class_name = Hyper-V Server from the result set. (i.e. sys_class_name =! 'Hyper-V Server')

The way I have added it, doesn't work.

Please advise.

Thanks,

https://XXXXXX.service-now.com/api/now/table/cmdb_ci_server?sysparm_query=&sysparm_fields=name%2Cos%...

Rajan Mehta

Jon Barnes · ‎05-06-2017

I'm not on my computer right now, so I don't know the system name of the host name field, but the easiest way to build your query is go to cmdb_ci_list.do in your instance. Then use the filter to add all of the conditions you want and verify your results are correct.

then right click the filter text and click copy query. This will copy the encoded query for you, and then you can put that right after sysparm_query= in your URL.

View solution in original post

Shishir Srivast · ‎05-06-2017

Hi Rajan,

Provided link is not getting open, but i noticed that you are using equal not (=!) instead, please try Not Equal (!=). Thank you!

Rajanmehta · ‎05-06-2017

Hello Shishir,

I tried doing it that way, but still it doesn't filter.

"https://XXXXX.service-now.com/api/now/table/cmdb_ci_server?sysparm_query=sys_class_name!=Hyper-V%20S..."

Any idea.

Thanks,

Rajan Mehta

Jon Barnes · ‎05-06-2017

sysparm_query=sys_class_name!=cmdb_ci_hyper_v_server

Rajanmehta · ‎05-06-2017

Hello Jonathan,

I tried doing it that way, but still it doesn't filter.

"https://XXXXX.service-now.com/api/now/table/cmdb_ci_server?sysparm_query=sys_class_name!=Hyper-V%20S..."

Any idea.

Thanks,

Rajan Mehta