AnsweredAssumed Answered

How to check for null using web services

Question asked by Paul Cherrier on Mar 3, 2017
Latest reply on Mar 5, 2017 by Boris Lekumovich

I'm using the findAccounts web service to pull specific accounts pertaining to  an ID. I want to further filter them to orphaned accounts. Meaning orphaned_date != null.

 

How do I filter on a column whos value simply exists?

 

cmd=findAccounts&format=csv&application_id=501&returnColumns=name&&sortByColumns=name&sortDirection=asc

Outcomes