API, making REST query where some records are empty (null?)

API, making REST query where some records are empty (null?)

I'm perplexed by the lack of documentation on the part of Zoho, I see just this page:

https://www.zoho.com/creator/help/api/rest-api/rest-api-view-records-in-view.html#http_method

I have a query where I want to retrieve records that do not have certain text in them, so records where:

Message_Status is not equal to 'Sent'

I have a lot of records where Message_Status is blank and some where Message_Status is qual to 'Send'


This query, however, only picks up records that DO HAVE a value for Message_Status (so are not blank) and that are not equal to 'Sent':



It seems it dosn't pick up blank (or null?) values, I have tried something like this too:

https://creator.zoho.com/api/json/stacksavings/view/Lead_Marketing_Report&authtoken=xxxx&raw=true&criteria=(Message_Status!="Sent"||Message_Status!=null)

But this doesn't work.. the documentation from the API is simply not complete, as far as I can tell, so it doesn't provide enough information to infer how to make this work. Would greatly appreciate any advice.