Thank you for the extended explanation. I saw the documentation myself but the lack of support for something like that was rather unexpected so I thought I'd better ask about it to be sure.

REST API does not allow for searching for null values nor Booleans. I have logged an enhancement request.

The Sage CRM REST API is a development of the SDATA. The Query Language for SDATA is described here:

sage.github.io/.../0212

This forms the basis of the way in which we can request data from Sage CRM via the REST API.

The SData 2.0 syntax should support Boolean for JSON returned values.

sage.github.io/.../05-0700

This is true for the Sage CRM REST API

The information transported through JSON is always in the form of the following basic types:

strings: double-quoted Unicode (UTF-8 by default), with backslash escaping

numbers

Boolean values: true or false

null

See: community.sagecrm.com/.../sage-crm-2019-r2-working-with-data-and-the-rest-api.aspx

But

SData and the REST doesn't seem to have a way of finding records by null values in fields nor does it have a way of selecting for Boolean values.

We can look for null values for Strings using a 'trick'.

e.g. Find all those companies without a 'source' listed

localhost/.../company ne ''

or

localhost/.../company gt ''

But we can not search for 'Booleans'.

E.g.

localhost/.../company eq true

Returns

{

"$diagnoses": [

{

"$severity": "Error",

"$applicationCode": "sdata648497",

"$message": "BadRequest ",

"$stackTrace": "sdata648497",

"status": "BAD_REQUEST",

"$sdataCode": "ApplicationDiagnosis"

}

],

}

How does one query by a boolean/checkbox field? Thanks

In the last line of this post the link for - Members of the developer program can download the file from the folder "General Development Resources (All Versions)". seems to be broken.

The link is working but you are getting the message because your community account doesn't have the all the rights you need to view the post.