How do I filter empty rows with REST API?

Rajanmehta
Mega Guru

Hi

I am making REST API call on a table with fields A, B and C.

Please let me know how can I append the query in URL not to bring rows when field A is Null?

Thanks in advance.

https://xxx.service-now.com/api/   ....   TABLE_NAME?....   &sysparm_fields=Column_A%2CColumn_B%2CColumn_C&Column_A!=''

1 ACCEPTED SOLUTION

Jon Barnes
Kilo Sage

You should be able to append an encoded query like this:



sysparm_query=column_aISNOTEMPTY


View solution in original post

5 REPLIES 5

Thanks Srinivas,



That was helpful too.



I tried your way and Jonathan's way and got the same response.



Thanks,



Rajan Mehta