- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-28-2017 06:21 PM
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!=''
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-28-2017 06:44 PM
You should be able to append an encoded query like this:
sysparm_query=column_aISNOTEMPTY
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-28-2017 07:15 PM
Thanks Srinivas,
That was helpful too.
I tried your way and Jonathan's way and got the same response.
Thanks,
Rajan Mehta