How do I filter empty rows with REST API?

[Rajanmehta]

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!=''

[Jon Barnes · Accepted solution]

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

sysparm_query=column_aISNOTEMPTY

[Rajanmehta]

Thanks Jonathan.

That was very helpful.

Thanks,

Rajan Mehta

[Neha18]

in the same manner i tried hitting

https://<server_ip>/api/space/managed-domain/ctps?filter=descriptionISNOTEMPTY  or

https://<server_ip>/api/space/managed-domain/ctps?filter=descriptionISEMPTY

But this didn't work showing syntax error in postman.

Actually i want to filter and get the records where description row is empty.

When I am trying with "https://<server_ip>/api/space/managed-domain/ctps?filter=(description eq NULL) " its giving zero result.

I want to get the result of empty description.Can you pls help me here.

[srinivasthelu]

https://instance.service-now.com/api/now/table/TABLE_NAME?sysparm_query=FIELD_NAME!=''