1

I am integrating Contacts in Xero with BC. Per default, Contacts in Xero have ContactNumber set to null. But when clearing it is empty (" "). Therefore, when connecting a contact in BC with a contact in Xero, I need to filter on something like this:

ContactStatus == "ACTIVE" && ( ContactNumber == null OR ContactNumber == " ")

But this does not work, does anyone know how to apply a nested or filter? Thank you in advance.

{ "ErrorNumber": 16, "Type": "QueryParseException", "Message": "Syntax error" }

rpuelma
  • 13
  • 2

1 Answers1

0

I could not see any issue with the query and when I tried it with API Explorer it worked fine.

API Explorer query for GET /Contacts?where=ContactStatus == "ACTIVE" && (ContactNumber == null OR ContactNumber == " ")

Doel Jangkrik
  • 188
  • 3