AnsweredAssumed Answered

API - Checking for fields that may not be populated?

Question asked by MatGeist3381 on Feb 17, 2014
Latest reply on Feb 18, 2014 by MatGeist3381
I am trying to use the API shape via Atomsphere to access X12 Connector Records. My goal is to return only documents that have not been acknowledged yet. The issue is that the fields ackStatus and ackReport are not even included in the results if the document is unacknowledged. It will not allow a filter type of IS NULL or IS NOT NULL.

Is there a way to do this?

I suppose I could return all results and manually check them, however this is the difference between several thousands of results and ~5. So obviously I absolutely do not want to do this.

Outcomes