Issue with GET API Request to retrieve where records not equal to value

Issue with GET API Request to retrieve where records not equal to value

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/myappname/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.