function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
alal 

How to handle null fields for search or query via API2.0

We have a need to collect lists of information from Accounts and Contacts where a specific field is/is not empty (null, blank, "", etc.)

When using XML RPC, how do you query on a null, or not-null field?

We tried a few things, like having a 'value' element with no value, but we either got all records or no records.

Any ideas?

Al G

DevAngelDevAngel

Hi al,

You cannot use null or missing or '' or any other representation of an empty field.
alal

Is it then possible to query on a field substring?

Like, retrieve field X where the first two characters are "ab"?

 

The real issue is that we need to get at our reports. The API does not allow this, so we

are trying to reproduce the reports via the API. You can specify null, or 'not null' as report

criteria, but cannot in the API.

 

Thanks for any suggestions you can offer,

Al G
DevAngelDevAngel

Hi Al,

Well, you could certainly use a query filter with the operator being "starts with".  Would that help?